Find Concurrent Programme

/* Formatted on 12/31/2013 10:26:58 AM (QP5 v5.163.1008.3004) */

  SELECT responsibility_name,

         frg.request_group_name,

         fcpv.user_concurrent_program_name,

         fcpv.description

    FROM fnd_request_groups frg,

         fnd_request_group_units frgu,

         fnd_concurrent_programs_vl fcpv,

         fnd_responsibility_vl frv

   WHERE     frgu.request_unit_type = 'P'

         AND frgu.request_group_id = frg.request_group_id

         AND frgu.request_unit_id = fcpv.concurrent_program_id

         AND frv.request_group_id = frg.request_group_id

         AND responsibility_name = NVL (:RESP_NAME, responsibility_name)

         AND frg.request_group_name = NVL (:RG_NAME, frg.request_group_name)

         AND fcpv.user_concurrent_program_name =

                NVL (:USER_CP_NAME, fcpv.user_concurrent_program_name)

ORDER BY responsibility_name;