SQL Query to find out the Resposibility and Request Group assigned to Concurrent program

  /*****************************************************************
*PURPOSE: To list out Responsibilities & Request Group assigned to Conc Prgm*
*PARAMETERS: Concurrent program Name                                                          *
******************************************************************/
SELECT fcpt.user_concurrent_program_name,
  frg.request_group_name,
  fcp.concurrent_program_name,
  frt.responsibility_name
FROM fnd_request_group_units frgu,
  fnd_concurrent_programs fcp,
  fnd_concurrent_programs_tl fcpt,
  fnd_request_groups frg,
  fnd_executables fe,
  fnd_responsibility fr,
  fnd_responsibility_tl frt
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 fcp.concurrent_program_id = fcpt.concurrent_program_id
AND fcpt.user_concurrent_program_name = '&Conc_Prgm_Name'
AND frg.request_group_id = fr.request_group_id
AND fr.responsibility_id = frt.responsibility_id;