SELECT fu.user_id, 
       fu.last_logon_date, 
       fu.user_name, 
       fur.responsibility_id, 
       fr.responsibility_name 
FROM   fnd_user fu, 
       fnd_user_resp_groups fur, 
       fnd_responsibility_vl fr 
WHERE  fu.user_id = fur.user_id 
       AND fr.application_id = fur.responsibility_application_id 
       AND fr.responsibility_id = fur.responsibility_id 
       AND Trunc (sysdate) BETWEEN Trunc (fr.start_date) AND 
                                   Trunc (Nvl (( 
                                   fr.end_date - 1 
                                               ), sysdate)) 
       AND Trunc (sysdate) BETWEEN Trunc (fur.start_date) AND Trunc ( 
                                   Nvl (( 
                                                              fur.end_date - 1 ) 
                                   , 
                                   sysdate) 
                                                              ) 
       AND user_name LIKE 'USHETTY' --- for all user or for particular user 
--AND fur.responsibility_application_id = 155 ?- Check particular resp. 
ORDER  BY user_name