APPS.IEM_CONCURRENT_MDT_PVT SQL Statements

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

Line: 35

         SELECT count(*) into l_status_count from IEM_COMP_RT_STATS
         WHERE TYPE='MAILPROC' and PARAM='RUNTIME STATUS';

Line: 38

             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: 70

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

Line: 79

         DELETE FROM iem_comp_rt_Stats
         WHERE TYPE='MAILPROC' and PARAM='RUNTIME STATUS';

Line: 233

                 SELECT email_account_id from iem_email_accounts;

Line: 247

        SELECT	EMAIL_PASSWORD,	EMAIL_USER,	DOMAIN, DB_SERVER_ID
  		INTO l_pass,	l_email_user, l_domain, 	l_db_server_id
  	    FROM IEM_EMAIL_ACCOUNTS
   		WHERE EMAIL_ACCOUNT_ID = email_account_id_list(i);

Line: 252

        IEM_DB_CONNECTIONS_PVT.select_item(
               		p_api_version_number =>1.0,
                 	p_db_server_id  =>l_db_server_id,
               		p_is_admin =>'P',
  					x_db_link=>l_IM_LINK1,
  					x_return_status =>l_stat,
  					x_msg_count    => l_count,
  					x_msg_data      => l_data);

Line: 275

                select resource_id
                from jtf_rs_resource_values where value_type = to_char(email_account_id_list(i));

Line: 284

                           select a.user_name into l_user_name
                           from fnd_user a, jtf_rs_resource_extns b
                           where a.user_id = b.user_id and b.resource_id = l_resource_id;