Queries to check request Group associated with Concurrent Program and Request Set

SELECT
  r.APPLICATION_ID "Request Group Application ID",
  R.REQUEST_GROUP_ID "Request Group - Group ID",
  R.REQUEST_GROUP_NAME,
  R.DESCRIPTION,
  ru.unit_application_id,
  ru.request_group_id "Request Group Unit - Group ID",
  ru.request_unit_id,cp.concurrent_program_id,
  cp.concurrent_program_name,
  cp1.user_concurrent_program_name,
  DECODE(ru.request_unit_type,'P','Program','S','Set',ru.request_unit_type) "Unit Type"
FROM
  apps.fnd_request_groups r,
  apps.fnd_request_group_units ru,
  apps.fnd_concurrent_programs cp,
  apps.FND_CONCURRENT_PROGRAMS_TL cp1
WHERE r.request_group_id = ru.request_group_id
  AND ru.request_unit_id = cp.concurrent_program_id
  AND cp.concurrent_program_id = cp1.concurrent_program_id
  AND cp1.user_concurrent_program_name ='&ENTER_CP_NAME'


SELECT
  R.APPLICATION_ID "Request Group Application ID",
  R.REQUEST_GROUP_ID "Request Group - Group ID",
  R.REQUEST_GROUP_NAME,
  R.DESCRIPTION,
  ru.unit_application_id,
  ru.request_group_id "Request Group Unit - Group ID",
  ru.request_unit_id,
  rs.USER_REQUEST_SET_NAME
FROM
  apps.fnd_request_groups r,
  apps.fnd_request_group_units ru,
  apps.FND_REQUEST_SETS_TL rs
WHERE r.request_group_id = ru.request_group_id
  AND ru.request_unit_id = rs.REQUEST_SET_ID
  AND rs.USER_REQUEST_SET_NAME ='&ENTER_CP_REQUEST_SET_NAME'