CASE
                               WHEN(is_a999999(u.login_id) =  1  AND COUNT(*) OVER() >=  1 ) THEN  1   
                               WHEN COUNT(*) OVER() >  1  AND NOT EXISTS( SELECT  1  AS dummy
                                                                        FROM users ue
                                                                        WHERE Upper(ue.employee_id) = Upper(u.employee_id)
                                                                              AND is_a999999(u.login_id) =  1    
                                                                       ) THEN  1  
                               ELSE  0 
                            END true_row