APPS.IEM_MDTSTARTPROCESS_PUB SQL Statements

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

Line: 67

   SELECT VALUE into l_status from IEM_COMP_RT_STATS
   WHERE TYPE='MAILPROC' and PARAM='RUNTIME STATUS';

Line: 70

   INSERT into IEM_COMP_RT_STATS
			(
   			COMP_RT_STATS_ID,
   			TYPE,
   			PARAM,
   			VALUE,
   			LAST_UPDATED_BY,
   			LAST_UPDATE_DATE)
   VALUES
   			(-1,
    			'MAILPROC',
   			'RUNTIME STATUS',
   			'T',
   			99999,
  			SYSDATE);

Line: 86

  delete from iem_comp_rt_Stats
  WHERE TYPE='MAILPROC' and PARAM='RUNTIME STATUS'
  and rownum<
  (select count(*) from iem_comp_rt_stats
  WHERE TYPE='MAILPROC' and PARAM='RUNTIME STATUS');

Line: 104

		 SELECT value into l_status from iem_comp_rt_stats
		 WHERE type='MAILPROC' and param='RUNTIME STATUS';

Line: 273

   UPDATE IEM_COMP_RT_STATS
   set VALUE='F'
   WHERE TYPE='MAILPROC' and PARAM='RUNTIME STATUS';

Line: 316

		SELECT  item_key
 		from wf_item_activity_statuses
 		where item_type=p_item_type
		and activity_status = 'ERROR'
		and begin_date<=to_date(p_end_date,'yyyy/mm/dd hh24:mi:ss');