APPS.IEM_EMAILPROC_PVT dependencies on IEM_MSTEMAIL_ACCOUNTS

Line 17: -- Liang Xia 12/03/2004 Changed for 115.11 schema: iem_mstemail_accounts. file version:115.9

13: -- Liang Xia 12/04/2002 Completely fixed NOCOPY FND_API.G_MISS GSCC warning
14: -- Liang Xia 06/10/2003 Added Document Retrieval Rule type
15: -- Liang Xia 08/11/2003 Added Auto-Redirect Rule type
16: -- Liang Xia 01/20/2004 Bugfix:3362872. Do not auto-redirect to the same account.
17: -- Liang Xia 12/03/2004 Changed for 115.11 schema: iem_mstemail_accounts. file version:115.9
18: -- Mina Tang 07/26/2005 Implemented soft delete for R12
19: -- --------- ------ ------------------------------------------
20:
21:

Line 1327: select count(*) into l_account from iem_mstemail_accounts

1323: end if;
1324:
1325: -- check if the account_id exist in iem_email_accounts
1326: -- Changed for 115.11 schema compliance
1327: select count(*) into l_account from iem_mstemail_accounts
1328: where email_account_id = p_email_account_id;
1329:
1330: if l_account < 1 then
1331: raise IEM_ADMIN_ACCOUNT_NOT_EXIST;