APPS.IEM_CONCURRENT_PVT dependencies on IEM_EMAIL_ACCOUNTS

Line 188: SELECT email_account_id from iem_email_accounts;

184:
185: begin
186: declare
187: CURSOR r_cur is
188: SELECT email_account_id from iem_email_accounts;
189: begin
190: open r_cur;
191: LOOP
192:

Line 204: FROM IEM_EMAIL_ACCOUNTS

200: end;
201: for i in 1..email_account_id_list.count loop
202: SELECT EMAIL_PASSWORD, EMAIL_USER, DOMAIN, DB_SERVER_ID
203: INTO l_pass, l_email_user, l_domain, l_db_server_id
204: FROM IEM_EMAIL_ACCOUNTS
205: WHERE EMAIL_ACCOUNT_ID = email_account_id_list(i);
206:
207: IEM_DB_CONNECTIONS_PVT.select_item(
208: p_api_version_number =>1.0,