APPS.IEM_UTILS_PUB dependencies on IEM_EMAIL_ACCOUNTS

Line 41: select email_account_id, account_name, email_user, domain bulk collect into l_account_id_tbl, l_account_name_tbl, l_email_user_tbl, l_domain_tbl from iem_email_accounts

37: END IF;
38: -- Initialize API return status to SUCCESS
39: x_return_status := FND_API.G_RET_STS_SUCCESS;
40:
41: select email_account_id, account_name, email_user, domain bulk collect into l_account_id_tbl, l_account_name_tbl, l_email_user_tbl, l_domain_tbl from iem_email_accounts
42: where upper(email_user)<>upper('intent') and upper(email_user)<>upper('acknowledgements') order by upper(email_user) ||'@'||upper(domain) asc;
43:
44: for l_index in l_account_id_tbl.FIRST..l_account_id_tbl.LAST LOOP
45: x_email_account_tbl(l_index).email_account_id:=l_account_id_tbl(l_index);