How to find attached Responsibility to Application User

The below query used to find the which responsibility attached to which user

User user responsibility name instated of 'Bill of Material', so you will get to know whom are all attached this responsibility with user name.

 SELECT fu.user_name, fr.responsibility_name, furg.start_date, furg.end_date
  FROM fnd_user_resp_groups_direct furg, fnd_user fu, fnd_responsibility_tl fr
 WHERE fr.responsibility_name = 'Bills of Material'---Enter the responsibility name
   AND fu.user_name = user_name
   AND furg.user_id = fu.user_id
   AND furg.responsibility_id = fr.responsibility_id
   AND fr.LANGUAGE = USERENV ('LANG')