APPS.HRI_OLTP_CONC_SUPH_MASTER SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 33

  SELECT
   fcp.concurrent_program_name
  ,fcr.phase_code
  ,fcr.status_code
  FROM
   fnd_concurrent_requests  fcr
  ,fnd_concurrent_programs  fcp
  WHERE fcr.request_id = v_request_id
  AND fcr.concurrent_program_id = fcp.concurrent_program_id
  AND fcr.program_application_id = fcp.application_id;