Query To List All The Request Sets Which Are Created With The Concurrent Program

ELECT DISTINCT USER_REQUEST_SET_NAME
FROM FND_REQUEST_SETS_TL
WHERE REQUEST_SET_ID IN
  (SELECT REQUEST_SET_ID
  FROM FND_REQUEST_SET_PROGRAMS
  WHERE CONCURRENT_PROGRAM_ID =
    (SELECT CONCURRENT_PROGRAM_ID
    from FND_CONCURRENT_PROGRAMS_TL
    WHERE upper(USER_CONCURRENT_PROGRAM_NAME) LIKE upper('<Concurrent Program Name>')
    )
  )