program which responsibility

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%';