Concurrent Programs Attached to Responsibilities Query

  SELECT frt.responsibility_name,
         frg.request_group_name,
         frgu.request_unit_type,
         frgu.request_unit_id,
         fcpt.user_concurrent_program_name
    FROM fnd_Responsibility fr,
         fnd_responsibility_tl frt,
         fnd_request_groups frg,
         fnd_request_group_units frgu,
         fnd_concurrent_programs_tl fcpt
   WHERE     frt.responsibility_id = fr.responsibility_id
         AND frg.request_group_id = fr.request_group_id
         AND frgu.request_group_id = frg.request_group_id
         AND fcpt.concurrent_program_id = frgu.request_unit_id
         AND frt.LANGUAGE = USERENV ('LANG')
         AND fcpt.LANGUAGE = USERENV ('LANG')
         AND NVL ( :conc_prg_name, fcpt.user_concurrent_program_name) =
                fcpt.user_concurrent_program_name
         AND NVL ( :Responsibility_name, frt.responsibility_name) =
                frt.responsibility_name
         AND NVL ( :REQUEST_GROUP, frg.request_group_name) =
                frg.request_group_name
ORDER BY 1,
         2,
         3,
         4