APPS.IEM_CONCURRENT_PVT SQL Statements

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

Line: 188

                 SELECT email_account_id from iem_email_accounts;

Line: 202

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

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

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

Line: 239

                           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;