Query to Find the Request Group,Responsibility name by concurrent program

SELECT fcpt.user_concurrent_program_name, frg.request_group_name,

fcp.concurrent_program_name, frt.responsibility_name

FROM fnd_request_group_units frgu,

fnd_concurrent_programs fcp,

fnd_concurrent_programs_tl fcpt,

fnd_request_groups frg,

fnd_executables fe,

fnd_responsibility fr,

fnd_responsibility_tl frt

WHERE frgu.request_unit_id = fcp.concurrent_program_id

AND frgu.request_group_id = frg.request_group_id

AND fe.executable_id = fcp.executable_id

AND fcp.concurrent_program_id = fcpt.concurrent_program_id

AND fcpt.user_concurrent_program_name LIKE :Concurrent_program_name

AND frg.request_group_id = fr.request_group_id

AND fr.responsibility_id = frt.responsibility_id