APPS.IEM_ROUTE_PVT dependencies on IEM_MSTEMAIL_ACCOUNTS

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

1682: end if;
1683:
1684: -- check if the account_id exist in iem_email_accounts
1685:
1686: select count(*) into l_account from iem_mstemail_accounts
1687: where email_account_id = p_email_account_id;
1688:
1689: if l_account < 1 then
1690: raise IEM_ADMIN_ACCOUNT_NOT_EXIST;

Line 1857: Select count(*) into l_acct_cnt from iem_mstemail_accounts

1853:
1854: IF p_email_account_id <> FND_API.G_MISS_NUM THEN
1855: /*Check For Existing DB Server Group Id */
1856:
1857: Select count(*) into l_acct_cnt from iem_mstemail_accounts
1858: where email_account_id=p_email_account_id;
1859:
1860:
1861: IF l_acct_cnt = 0 then