APPS.IEM_EMAILACCOUNT_PUB dependencies on IEM_MSTEMAIL_ACCOUNTS

Line 19: FROM IEM_MSTEMAIL_ACCOUNTS A,

15:
16: SELECT a.from_name,
17: a.user_name,
18: a.email_account_id
19: FROM IEM_MSTEMAIL_ACCOUNTS A,
20: JTF_RS_RESOURCE_VALUES B
21: WHERE (B.resource_id=p_RESOURCE_ID)
22: AND (A.email_account_id=B.VALUE_TYPE);
23:

Line 29: FROM IEM_MSTEMAIL_ACCOUNTS A ;

25:
26: SELECT a.from_name,
27: a.user_name,
28: a.email_account_id
29: FROM IEM_MSTEMAIL_ACCOUNTS A ;
30: l_email_index number:=1;
31:
32: l_api_name VARCHAR2(255):='Get_EmailAccount_List';
33: l_api_version_number NUMBER:=1.0;

Line 149: IEM_MSTEMAIL_ACCOUNTS B

145: a.signature,
146: a.agent_id,
147: a.email_account_id
148: FROM IEM_AGENTS A,
149: IEM_MSTEMAIL_ACCOUNTS B
150: WHERE (A.resource_id=p_RESOURCE_ID)
151: AND (A.email_account_id=B.EMAIL_ACCOUNT_ID)
152: ORDER BY a.agent_id;
153:

Line 187: select sender_flag into l_flag from iem_mstemail_accounts

183: SELECT USER_NAME, SOURCE_LAST_NAME || ', ' || SOURCE_FIRST_NAME as RESOURCE_NAME
184: INTO l_user_name, l_res_name
185: FROM JTF_RS_RESOURCE_EXTNS
186: WHERE RESOURCE_ID = p_resource_id;
187: select sender_flag into l_flag from iem_mstemail_accounts
188: where email_account_id= agent_account_rec.email_account_id;
189: IF l_flag=0 then -- From Name selected from Account.
190: select from_name into l_res_name
191: from iem_mstemail_accounts

Line 191: from iem_mstemail_accounts

187: select sender_flag into l_flag from iem_mstemail_accounts
188: where email_account_id= agent_account_rec.email_account_id;
189: IF l_flag=0 then -- From Name selected from Account.
190: select from_name into l_res_name
191: from iem_mstemail_accounts
192: where email_account_id= agent_account_rec.email_account_id;
193: END IF;
194: x_Agent_Acnt_tbl(l_email_index).account_name:=l_user_name;
195: x_Agent_Acnt_tbl(l_email_index).reply_to_address:=agent_account_rec.reply_to_address;

Line 265: IEM_MSTEMAIL_ACCOUNTS B

261: a.signature,
262: a.agent_id,
263: a.email_account_id
264: FROM IEM_AGENTS A,
265: IEM_MSTEMAIL_ACCOUNTS B
266: WHERE (A.resource_id=p_RESOURCE_ID)
267: AND (A.email_account_id=B.EMAIL_ACCOUNT_ID)
268: AND A.cherry_pick_flag = 'Y'
269: ORDER BY a.agent_id;

Line 304: select sender_flag into l_flag from iem_mstemail_accounts

300: SELECT USER_NAME, SOURCE_LAST_NAME || ', ' || SOURCE_FIRST_NAME as RESOURCE_NAME
301: INTO l_user_name, l_res_name
302: FROM JTF_RS_RESOURCE_EXTNS
303: WHERE RESOURCE_ID = p_resource_id;
304: select sender_flag into l_flag from iem_mstemail_accounts
305: where email_account_id= agent_account_rec.email_account_id;
306: IF l_flag=0 then -- From Name selected from Account.
307: select from_name into l_res_name
308: from iem_mstemail_accounts

Line 308: from iem_mstemail_accounts

304: select sender_flag into l_flag from iem_mstemail_accounts
305: where email_account_id= agent_account_rec.email_account_id;
306: IF l_flag=0 then -- From Name selected from Account.
307: select from_name into l_res_name
308: from iem_mstemail_accounts
309: where email_account_id= agent_account_rec.email_account_id;
310: END IF;
311: x_Agent_Acnt_tbl(l_email_index).account_name:=l_user_name;
312: x_Agent_Acnt_tbl(l_email_index).reply_to_address:=agent_account_rec.reply_to_address;

Line 619: FROM IEM_MSTEMAIL_ACCOUNTS

615: out_host,
616: out_port,
617: template_category,
618: ssl_connection_flag
619: FROM IEM_MSTEMAIL_ACCOUNTS
620: WHERE email_account_id=p_EMAIL_ACCOUNT_ID;
621:
622: l_email_index number:=1;
623: