All responsibilities registered to a concurrent program

select frt.responsibility_name

   , frg.request_group_name

   , frgu.request_unit_type

   , frgu.request_unit_id

   , fcpt.user_concurrent_program_name
    From fnd_Responsibility f

     , fnd_responsibility_tl frt

     , fnd_request_groups frg

     , fnd_request_group_units frgu
     , fnd_concurrent_programs_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.concurrent_program_id = frgu.request_unit_id
    and frt.language = USERENV('LANG')
    and fcpt.language = USERENV('LANG')
    and fcpt.user_concurrent_program_name = :conc_prg_name
    order by 1,2,3,4