APPS.IEM_ROUTE_CLASS_PVT dependencies on IEM_MSTEMAIL_ACCOUNTS

Line 1654: -- ***** Changed from iem_email_accounts ==> iem_mstemail_accounts for 11i compliance *****

1650: raise IEM_RT_CLASS_NO_DATA;
1651: end if;
1652:
1653:
1654: -- ***** Changed from iem_email_accounts ==> iem_mstemail_accounts for 11i compliance *****
1655: -- check if the account_id exist in iem_mstemail_accounts
1656: -- removed the where clause "and active_flag='Y'" for bug fix of 4945889
1657: select count(*) into l_account from iem_mstemail_accounts
1658: where email_account_id = p_email_account_id and deleted_flag='N';

Line 1655: -- check if the account_id exist in iem_mstemail_accounts

1651: end if;
1652:
1653:
1654: -- ***** Changed from iem_email_accounts ==> iem_mstemail_accounts for 11i compliance *****
1655: -- check if the account_id exist in iem_mstemail_accounts
1656: -- removed the where clause "and active_flag='Y'" for bug fix of 4945889
1657: select count(*) into l_account from iem_mstemail_accounts
1658: where email_account_id = p_email_account_id and deleted_flag='N';
1659:

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

1653:
1654: -- ***** Changed from iem_email_accounts ==> iem_mstemail_accounts for 11i compliance *****
1655: -- check if the account_id exist in iem_mstemail_accounts
1656: -- removed the where clause "and active_flag='Y'" for bug fix of 4945889
1657: select count(*) into l_account from iem_mstemail_accounts
1658: where email_account_id = p_email_account_id and deleted_flag='N';
1659:
1660: if l_account < 1 then
1661: raise IEM_ADMIN_ACCOUNT_NOT_EXIST;

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

2226: IF p_email_account_id <> FND_API.G_MISS_NUM THEN
2227:
2228: -- removed the where clause "and active_flag='Y'" for bug fix of 4945889
2229:
2230: Select count(*) into l_acct_cnt from iem_mstemail_accounts
2231: where email_account_id=p_email_account_id and deleted_flag='N' ;
2232:
2233: IF l_acct_cnt = 0 then
2234: raise IEM_ADMIN_ACCOUNT_NOT_EXIST;