Query to find the Request Group of a Concurrent Program

- Run the following query to find the Request Group of a Concurrent Program.
- Provide Concurrent Program executable name for the following query.

SELECT fa.application_short_name,
       frg.request_group_name,
       fe.execution_file_name,
       fe.executable_name
  FROM fnd_request_group_units frgu,
       fnd_concurrent_programs fcp,
       fnd_request_groups frg,
       fnd_executables fe,
       fnd_application fa
 WHERE     frgu.request_unit_id = fcp.concurrent_program_id
       AND frgu.request_group_id = frg.request_group_id
       AND fe.executable_id = fcp.executable_id
       AND FRG.application_id = fa.application_id
       AND fe.executable_name = '&CP_EXEC_NAME';

Note:
A Concurrent Program can be attached to a multiple Request Groups. So, if the query returns more than one row do NOT get confused.