APPS.IEM_EMAILACCOUNT_PUB SQL Statements

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

Line: 16

   SELECT    a.from_name,
             a.user_name,
        	a.email_account_id
   FROM      IEM_MSTEMAIL_ACCOUNTS A,
             JTF_RS_RESOURCE_VALUES B
   WHERE     (B.resource_id=p_RESOURCE_ID)
   AND       (A.email_account_id=B.VALUE_TYPE);

Line: 26

   SELECT    a.from_name,
             a.user_name,
		 a.email_account_id
   FROM      IEM_MSTEMAIL_ACCOUNTS A ;

Line: 144

      SELECT      nvl(nvl(b.reply_to_address,b.return_address),b.email_address) reply_to_address,
             a.signature,
             a.agent_id,
        	   a.email_account_id
   FROM      IEM_AGENTS A,
             IEM_MSTEMAIL_ACCOUNTS B
   WHERE     (A.resource_id=p_RESOURCE_ID)
   AND       (A.email_account_id=B.EMAIL_ACCOUNT_ID)
   ORDER BY a.agent_id;

Line: 183

	SELECT  USER_NAME, SOURCE_LAST_NAME || ', ' || SOURCE_FIRST_NAME as RESOURCE_NAME
          INTO  l_user_name, l_res_name
          FROM JTF_RS_RESOURCE_EXTNS
          WHERE RESOURCE_ID = p_resource_id;

Line: 187

	select sender_flag into l_flag from iem_mstemail_accounts
	where email_account_id= agent_account_rec.email_account_id;

Line: 189

	IF l_flag=0 then			-- From Name selected from Account.
		select from_name into l_res_name
		from iem_mstemail_accounts
		where email_account_id= agent_account_rec.email_account_id;

Line: 260

      SELECT      nvl(nvl(b.reply_to_address,b.return_address),b.email_address) reply_to_address,
             a.signature,
             a.agent_id,
        	   a.email_account_id
   FROM      IEM_AGENTS A,
             IEM_MSTEMAIL_ACCOUNTS B
   WHERE     (A.resource_id=p_RESOURCE_ID)
   AND       (A.email_account_id=B.EMAIL_ACCOUNT_ID)
   AND        A.cherry_pick_flag = 'Y'
   ORDER BY a.agent_id;

Line: 300

	SELECT  USER_NAME, SOURCE_LAST_NAME || ', ' || SOURCE_FIRST_NAME as RESOURCE_NAME
          INTO  l_user_name, l_res_name
          FROM JTF_RS_RESOURCE_EXTNS
          WHERE RESOURCE_ID = p_resource_id;

Line: 304

	select sender_flag into l_flag from iem_mstemail_accounts
	where email_account_id= agent_account_rec.email_account_id;

Line: 306

	IF l_flag=0 then			-- From Name selected from Account.
		select from_name into l_res_name
		from iem_mstemail_accounts
		where email_account_id= agent_account_rec.email_account_id;

Line: 437

			IN (select respgrp.user_id,max(respgrp.responsibility_id)
				from fnd_user_resp_groups respgrp,fnd_responsibility resp
				where respgrp.responsibility_id=resp.responsibility_id
				and resp.application_id=680 and (resp.responsibility_key =''EMAIL_CENTER_SUPERVISOR'' or resp.responsibility_key=''IEM_SA_AGENT'')
				group by respgrp.user_id) ';

Line: 460

l_string := 'select agnt.resource_id, concat(concat(res.source_last_name, '', ''), res.source_first_name) as resource_name, res.user_name,
	resptl.responsibility_name
   from iem_agents agnt, fnd_responsibility resp,fnd_user_resp_groups respgrp,
	jtf_rs_resource_extns res, fnd_user fu,fnd_responsibility_tl resptl
   where agnt.resource_id=res.resource_id and res.user_id=respgrp.user_id
	and resp.application_id=680
	and resp.responsibility_id=respgrp.responsibility_id
	and respgrp.user_id=fu.user_id
	and resptl.application_id=680
	and resptl.responsibility_id=resp.responsibility_id
	and resptl.LANGUAGE = USERENV (''LANG'')
	 and trunc(sysdate) between trunc(nvl(respgrp.start_date, sysdate))
    	and trunc(nvl(respgrp.end_date, sysdate))
    	 and trunc(sysdate) between trunc(nvl(fu.start_date, sysdate))
    	and trunc(nvl(fu.end_date, sysdate))
    	and trunc(sysdate) between trunc(nvl(res.start_date_active, sysdate))
      	and trunc(nvl(res.end_date_active, sysdate))
      	and res.resource_id in ( select unique rel.role_resource_id from jtf_rs_role_relations rel where
       rel.role_id in (28, 29, 30) and rel.delete_flag = ''N''
        and rel.role_resource_type = ''RS_INDIVIDUAL''
          and trunc(sysdate) between trunc(nvl(rel.start_date_active, sysdate))
      	and trunc(nvl(rel.end_date_active, sysdate)) ) ';

Line: 506

	l_temp_tbl.delete;

Line: 519

     select to_char(max(begin_date_time), 'MM/DD/RRRR HH24:MI:SS') into l_last_login_time
	 	    from ieu_sh_sessions where application_id=680 and resource_id=l_resource_id;

Line: 610

   SELECT    from_name,
             user_name,
		   email_address,
      	   nvl(nvl(reply_to_address,return_address),email_address) reply_to_address,
             email_account_id,
		   out_host,
		   out_port,
		   template_category,
		   ssl_connection_flag
   FROM      IEM_MSTEMAIL_ACCOUNTS
   WHERE     email_account_id=p_EMAIL_ACCOUNT_ID;