Find Responsibility a Concurrent Request is attached to

select

    fcpt.user_concurrent_program_name,

    fcp.concurrent_program_name,

    req_grps.request_group_name,

    fr.responsibility_name

from fnd_concurrent_programs fcp

inner join (

    select *

    from fnd_concurrent_programs_tl

) fcpt on fcpt.concurrent_program_id=fcp.concurrent_program_id

inner join (

    select

        frg.request_group_name,

        frg.request_group_id,

        frgu.unit_application_id,

        frgu.request_unit_id

    from fnd_request_group_units frgu

    inner join (

        select *

        from fnd_request_groups

    ) frg on frg.request_group_id=frgu.request_group_id

) req_grps on req_grps.request_unit_id=fcp.concurrent_program_id

left join (

    select

        fr1.request_group_id,

        frt.responsibility_name

    from fnd_responsibility fr1

    inner join (

        select *

        from fnd_responsibility_tl

    ) frt on frt.responsibility_id=fr1.responsibility_id

) fr on req_grps.request_group_id=fr.request_group_id

where user_concurrent_program_name = 'XXGC_PEN_RETIRE'

order by request_group_name, responsibility_name