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 500: FROM IEM_MSTEMAIL_ACCOUNTS

496: email_account_id,
497: out_host,
498: out_port,
499: template_category
500: FROM IEM_MSTEMAIL_ACCOUNTS
501: WHERE email_account_id=p_EMAIL_ACCOUNT_ID;
502:
503: l_email_index number:=1;
504: