Query To Get List of all Responsibility attached for user

 SELECT fuser.user_name,
         frt.responsibility_name,
         furgd.start_date,
         furgd.end_date,
         fresp.responsibility_key,
         fapp.application_short_name,
         furgd.*
    FROM apps.fnd_user_resp_groups_direct furgd,
         apps.fnd_user fuser,
         apps.fnd_responsibility fresp,
         apps.fnd_responsibility_tl frt,
         apps.fnd_application fapp,
         apps.fnd_application_tl fat
   WHERE     1 = 1
         AND furgd.user_id = fuser.user_id
         AND furgd.responsibility_id = frt.responsibility_id
         AND fresp.responsibility_id = frt.responsibility_id
         AND fapp.application_id = fat.application_id
         AND fresp.application_id = fat.application_id
         AND frt.language = USERENV ('LANG')
         AND UPPER (fuser.user_name) = UPPER ('&Enter_User_Name')
--AND (furgd.end_date IS NULL OR furgd.end_date >= TRUNC(SYSDATE))
ORDER BY frt.responsibility_name;