How to find Concurrent Program registered under which responsibility

SELECT
DISTINCT FNRTL.RESPONSIBILITY_NAME
FROM
APPS.FND_REQUEST_GROUPS FRG,
APPS.FND_APPLICATION_TL FAPP,
APPS.FND_REQUEST_GROUP_UNITS FRGU,
APPS.FND_CONCURRENT_PROGRAMS FCP,
APPS.FND_CONCURRENT_PROGRAMS_TL FCPL,
APPS.FND_RESPONSIBILITY FNR,
APPS.FND_RESPONSIBILITY_TL FNRTL
WHERE 1=1
AND FRG.APPLICATION_ID=FAPP.APPLICATION_ID
AND FRG.APPLICATION_ID=FRGU.APPLICATION_ID
AND FRG.REQUEST_GROUP_ID=FRGU.REQUEST_GROUP_ID
AND FRG.REQUEST_GROUP_ID=FNR.REQUEST_GROUP_ID
AND FRG.APPLICATION_ID=FNR.APPLICATION_ID
AND FNR.RESPONSIBILITY_ID=FNRTL.RESPONSIBILITY_ID
AND FRGU.REQUEST_UNIT_ID=FCP.CONCURRENT_PROGRAM_ID
AND FRGU.UNIT_APPLICATION_ID=FCP.APPLICATION_ID
AND FCP.CONCURRENT_PROGRAM_ID=FCPL.CONCURRENT_PROGRAM_ID
AND FCPL.USER_CONCURRENT_PROGRAM_NAME='Trial Balance - Detail'  ---(Change Program Name as per need)
AND FNRTL.LANGUAGE='US'
AND FAPP.LANGUAGE='US'

#oracleebs #responsibility #concurrentprogram #programname #query #oracler12 #sql