SELECT fcp.concurrent_program_name
,fr.responsibility_name
,frg.request_group_name
,fcp.user_concurrent_program_name
FROM
fnd_request_group_units frgup
,fnd_concurrent_programs_vl fcp
,fnd_request_groups frg
,fnd_responsibility_vl fr
WHERE 1=1
AND fr.request_group_id = frg.request_group_id
AND frg.request_group_id = frgup.request_group_id
AND frgup.request_unit_type = 'P'
AND frgup.request_unit_id = fcp.concurrent_program_id
AND fcp.concurrent_program_name LIKE '%&concurrent_program_name%';