APPS.IEM_CLIENT_PUB dependencies on IEM_MSTEMAIL_ACCOUNTS

Line 2106: from iem_mstemail_accounts

2102: END;
2103: --Employee Search. Shramana
2104: if (l_email_account_id is not null) then
2105: select account_type into l_acct_type
2106: from iem_mstemail_accounts
2107: where email_account_id = l_email_account_id;
2108: else
2109: select acct.account_type into l_acct_type
2110: from iem_mstemail_accounts acct, iem_agents agnt

Line 2110: from iem_mstemail_accounts acct, iem_agents agnt

2106: from iem_mstemail_accounts
2107: where email_account_id = l_email_account_id;
2108: else
2109: select acct.account_type into l_acct_type
2110: from iem_mstemail_accounts acct, iem_agents agnt
2111: where agnt.agent_id = l_agent_account_id
2112: and agnt.email_account_id = acct.email_account_id;
2113: end if;
2114:

Line 3793: from iem_mstemail_accounts acct, iem_rt_proc_emails proc

3789:
3790: -- Employee Search. shramana
3791: select acct.account_type
3792: into l_acct_type
3793: from iem_mstemail_accounts acct, iem_rt_proc_emails proc
3794: where proc.message_id = p_message_id
3795: and acct.email_account_id = proc.email_account_id;
3796:
3797: if(l_acct_type = 'I') then