SQL Query to list responsibilities based on Concurrent Program Name

/******************************************************************
*PURPOSE: To list Responsibilities having the specified           *
*         concurrent Program                                      *
*PARAMETER: Concurrent Program Name                               *
******************************************************************/

SELECT fcpt.user_concurrent_program_name,

       fcp.concurrent_program_name,

       fat.application_name,

       frg.request_group_name,

       frt.responsibility_name

  FROM fnd_request_groups frg,

       fnd_application_tl fat,

       fnd_request_group_units frgu,

       fnd_concurrent_programs fcp,

       fnd_concurrent_programs_tl fcpt,

       fnd_responsibility fnr,

       fnd_responsibility_tl frt

 WHERE frg.application_id           = fat.application_id

   AND frg.application_id           = frgu.application_id

   AND frg.request_group_id         = frgu.request_group_id

   AND frg.request_group_id         = fnr.request_group_id

   AND frg.application_id           = fnr.application_id

   AND fnr.responsibility_id        = frt.responsibility_id

   AND frgu.request_unit_id         = fcp.concurrent_program_id

   AND frgu.unit_application_id     = fcp.application_id

   AND fcp.concurrent_program_id    = fcpt.concurrent_program_id

   AND frt.LANGUAGE                 = 'US'

   AND fat.LANGUAGE                 = 'US'

   AND fcpt.user_concurrent_program_name LIKE '&user_conc_name'