Query to get Responsibilities under specific user

SELECT frv.RESPONSIBILITY_NAME
      ,frv.responsibility_key
      ,fat.application_name
      ,fa.APPLICATION_SHORT_NAME
      ,fu.user_name
  FROM fnd_user fu
      ,fnd_user_resp_groups furg
      ,fnd_responsibility_vl frv
      ,fnd_application_tl fat
      ,fnd_application fa
   WHERE furg.responsibility_id = frv.responsibility_id
     AND fu.user_id = furg.user_id
     AND fa.APPLICATION_ID = fat.APPLICATION_ID
     AND frv.APPLICATION_ID = fat.APPLICATION_ID
     AND upper(fu.user_name) = UPPER ('USER_NAME')
     AND fat.LANGUAGE = 'US'
ORDER BY 1;