Oracle Apps - Query to list the responsibility to which the concurrent program is assigned

Oracle Apps - Query to list the responsibility to which the concurrent program is assigned

Query to find the responsibilities to which the concurrent program is assigned.

select    frt.responsibility_name, 

frg.request_group_name, 

frgu.request_unit_type, 

frgu.request_unit_id, 

fcpt.user_concurrent_program_name 

from      fnd_Responsibility fr, 

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        fcpt.user_concurrent_program_name = :P_CONCURRENT_PROGRAM_NAME

order by 1,2,3,4