responsibility that can run a specific report

SELECT r.responsibility_name,
g.request_group_name,
cp.user_concurrent_program_name
FROM fnd_responsibility_vl r,
fnd_request_groups g,
fnd_request_group_units rg,
fnd_concurrent_programs_vl cp
WHERE r.request_group_id = g.request_group_id
AND rg.request_group_id = g.request_group_id
AND rg.request_unit_id = cp.concurrent_program_id
AND rg.application_id = 'your application_id'
AND r.responsibility_name = 'your name responsibility'

you can also try note: 134036.1 - List Responsibilities That Can Run a Given Concurrent Program(WHOCANRUN.SQL)