Query to find concurrent program attached Responsibility

SELECT FRT.RESPONSIBILITY_NAME , FRG.REQUEST_GROUP_NAME , FRGU.REQUEST_UNIT_TYPE , FRGU.REQUEST_UNIT_ID , FCPT.USER_CONCURRENT_PROGRAM_NAME FROM FND_RESPONSIBILITY FR , FND_RESPONSIBILITY_TL FRT , FND_REQUEST_GROUPS FRG , FND_REQUEST_GROUP_UNITS FRGU , FND_CONCURRENT_PROGRAMS_TL FCPT WHERE FRT.RESPONSIBILITY_ID = FR.RESPONSIBILITY_ID AND FRG.REQUEST_GROUP_ID = FR.REQUEST_GROUP_ID AND FRGU.REQUEST_GROUP_ID = FRG.REQUEST_GROUP_ID AND FCPT.CONCURRENT_PROGRAM_ID = FRGU.REQUEST_UNIT_ID AND FRT.LANGUAGE = USERENV ('LANG') AND FCPT.LANGUAGE = USERENV ('LANG') AND FCPT.USER_CONCURRENT_PROGRAM_NAME = :CONC_PRG_NAME ORDER BY 1, 2, 3, 4