Find the Responsibility list for Given Request Set

Use the below query which is list out the Responsibility for the given Request Set


    select frt.responsibility_name,
           frg.request_group_name,
           frgu.request_unit_type,
           frgu.request_unit_id,
           fcpt.user_request_set_name
      From apps.fnd_Responsibility      fr,
           apps.fnd_responsibility_tl   frt,
           apps.fnd_request_groups      frg,
           apps.fnd_request_group_units frgu,
           apps.fnd_request_Sets_tl     fcpt
     where frt.responsibility_id = fr.responsibility_id
       and frg.request_group_id = fr.request_group_id
       and frgu.request_group_id = frg.request_group_id
       and fcpt.request_set_id = frgu.request_unit_id
       and frt.language = USERENV('LANG')
       and fcpt.language = USERENV('LANG')
       and fcpt.user_request_set_name = ':request_set_name'
     order by 1, 2, 3, 4