SQL Query - Responsibility list having a specific Concurrent Request

This SQL query can be used to find out which concurrent program attached to which all responsibility

select responsibility_name
from    fnd_responsibility_tl rsp_tl,
        fnd_responsibility fr,
        fnd_request_groups frg,
        fnd_request_group_units frgu,
        fnd_concurrent_programs_tl fcpt

where rsp_tl.responsibility_id = fr.responsibility_id
and frg.request_group_id = fr.request_group_id
and fr.request_group_id = frgu.request_group_id
and fcpt.concurrent_program_id = frgu.request_unit_id
and upper(fcpt.USER_CONCURRENT_PROGRAM_NAME) = upper('Payroll Register Report') -- concurrent program name
order by responsibility_name

PREVIOUS POST || NEXT POST