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