APPS.IEM_MOVEMSG_PVT SQL Statements

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

Line: 89

   	SELECT	DB_SERVER_ID,EMAIL_USER,DOMAIN,EMAIL_PASSWORD
  				INTO 	l_db_server_id,l_user,l_domain,l_pass
  				FROM IEM_EMAIL_ACCOUNTS
   				WHERE EMAIL_ACCOUNT_ID=p_email_account_id;

Line: 94

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

   	SELECT	DB_SERVER_ID,EMAIL_USER,DOMAIN,EMAIL_PASSWORD
  				INTO 	l_db_server_id,l_user,l_domain,l_pass
  				FROM IEM_EMAIL_ACCOUNTS
   				WHERE EMAIL_ACCOUNT_ID=p_email_account_id;

Line: 237

  	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);