APPS.IEM_NEXT_GEN_PROCESS_EMAIL_PVT 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 -- New Table
   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: 100

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

Line: 217

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

Line: 261

			SELECT  item_key
 			from wf_item_activity_statuses
 			where item_type=p_item_type
			and activity_status = 'ERROR'
			and begin_date<=p_end_date;