To get all Conc Programs attached to a Reponsibility

SELECT
responsibility_name,
frg.request_group_name,
fcpv.user_concurrent_program_name,
fcpv.description
FROM
fnd_request_groups frg,
fnd_request_group_units frgu,
fnd_concurrent_programs_vl fcpv,
fnd_responsibility_vl frv
WHERE
frgu.request_unit_type = 'P' AND
frgu.request_group_id = frg.request_group_id AND
frgu.request_unit_id = fcpv.concurrent_program_id AND
frv.request_group_id = frg.request_group_id
ORDER BY responsibility_name