To find from which responsibility a concurrent program can be run

select distinct

   a.user_concurrent_program_name,

   a.description,

   request_group_name,

   e.responsibility_name

from

   fnd_concurrent_programs_tl a,

   fnd_request_groups b,

   fnd_request_group_units c,

   fnd_responsibility d,

   fnd_responsibility_tl e

where

   a.concurrent_program_id = c.request_unit_id   

and b.request_group_id = c.request_group_id

and b.request_group_id = d.request_group_id

and d.responsibility_id = e.responsibility_id

and a.application_id = b.application_id

and b.application_id = c.application_id

and d.application_id = e.application_id

and a.concurrent_program_id = :p_conc_program_id