Get list of responsibilities that can access ccp

SELECT c.user_concurrent_program_name, --a.request_group_name,
d.responsibility_name
FROM apps.fnd_request_groups a,
apps.fnd_request_group_units b,
apps.fnd_concurrent_programs_tl c,
apps.fnd_responsibility_vl d
WHERE a.request_group_id = b.request_group_id
AND a.application_id = b.application_id
AND c.concurrent_program_id = b.request_unit_id
AND d.request_group_id = a.request_group_id
AND c.user_concurrent_program_name=:p