APPS.HRI_BPL_CONC_ADMIN SQL Statements

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

Line: 32

  l_sql_stmt := 'SELECT count(*) FROM ' || p_table_name || ' WHERE rownum < 2';

Line: 59

  SELECT DECODE(NVL(SUM(recs),0),0,'Y','N')
  FROM  (SELECT 1 recs
         FROM   hri_cs_suph
         WHERE  rownum = 1
         UNION ALL
         SELECT 1 recs
         FROM   hri_mb_asgn_events_ct
         WHERE rownum = 1
         UNION ALL
         SELECT 1 recs
	 FROM   hri_cl_wkr_sup_status_ct
         WHERE rownum = 1
         );

Line: 119

  SELECT
   rso.object_name
  ,rso.object_owner
  ,rso.object_type
  ,opt.option_value       refresh_mode
  ,rset.request_set_id
  ,rset.application_id
  FROM
   fnd_concurrent_requests  fcr
  ,fnd_request_sets_vl      rset
  ,bis_request_set_objects  rso
  ,bis_request_set_options  opt
  WHERE fcr.request_id = v_request_id
  AND rso.set_app_id = rset.application_id
  AND rso.request_set_name = rset.request_set_name
  AND rset.application_id = to_number(fcr.argument1)
  AND rset.request_set_id = to_number(fcr.argument2)
  AND opt.request_set_name = rso.request_set_name
  AND opt.set_app_id = rso.set_app_id
  AND opt.option_name = 'REFRESH_MODE';