QUERY TO GET RESPONSIBILITIES AND REQUEST GROUPS ASSIGNED FOR CONCURRENT PROGRAM

SELECT FCONC.USER_CONCURRENT_PROGRAM_NAME,
       FR.REQUEST_GROUP_NAME             ,
       FRESP.RESPONSIBILITY_NAME 
  FROM FND_CONCURRENT_PROGRAMS_VL FCONC,
       FND_REQUEST_GROUP_UNITS FREQ,
       FND_REQUEST_GROUPS      FR  ,
       FND_RESPONSIBILITY_VL   FRESP
  WHERE FCONC.CONCURRENT_PROGRAM_ID = FREQ.REQUEST_UNIT_ID
    AND FREQ.REQUEST_GROUP_ID       = FR.REQUEST_GROUP_ID
    AND FR.REQUEST_GROUP_ID         = FRESP.REQUEST_GROUP_ID
    AND FCONC.USER_CONCURRENT_PROGRAM_NAME = :P_NAME