Here's the query to find the request group name by passing concurrent program name as parameter
SELECT
FRG.REQUEST_GROUP_NAME,
FRG.DESCRIPTION,
CP.CONCURRENT_PROGRAM_ID,
CP.CONCURRENT_PROGRAM_NAME,
CPT.USER_CONCURRENT_PROGRAM_NAME,
FRV.RESPONSIBILITY_NAME
FROM
FND_REQUEST_GROUPS FRG,
FND_REQUEST_GROUP_UNITS FRGU,
FND_CONCURRENT_PROGRAMS CP,
FND_CONCURRENT_PROGRAMS_TL CPT,
FND_RESPONSIBILITY_VL FRV
WHERE
FRG.REQUEST_GROUP_ID = FRGU.REQUEST_GROUP_ID
AND FRGU.REQUEST_UNIT_ID = CP.CONCURRENT_PROGRAM_ID
AND CP.CONCURRENT_PROGRAM_ID = CPT.CONCURRENT_PROGRAM_ID
AND FRV.REQUEST_GROUP_ID = FRG.REQUEST_GROUP_ID(+)
AND CPT.USER_CONCURRENT_PROGRAM_NAME LIKE 'XX Conc Pgm Name';
SELECT
FRG.REQUEST_GROUP_NAME,
FRG.DESCRIPTION,
CP.CONCURRENT_PROGRAM_ID,
CP.CONCURRENT_PROGRAM_NAME,
CPT.USER_CONCURRENT_PROGRAM_NAME,
FRV.RESPONSIBILITY_NAME
FROM
FND_REQUEST_GROUPS FRG,
FND_REQUEST_GROUP_UNITS FRGU,
FND_CONCURRENT_PROGRAMS CP,
FND_CONCURRENT_PROGRAMS_TL CPT,
FND_RESPONSIBILITY_VL FRV
WHERE
FRG.REQUEST_GROUP_ID = FRGU.REQUEST_GROUP_ID
AND FRGU.REQUEST_UNIT_ID = CP.CONCURRENT_PROGRAM_ID
AND CP.CONCURRENT_PROGRAM_ID = CPT.CONCURRENT_PROGRAM_ID
AND FRV.REQUEST_GROUP_ID = FRG.REQUEST_GROUP_ID(+)
AND CPT.USER_CONCURRENT_PROGRAM_NAME LIKE 'XX Conc Pgm Name';