APPS.IEM_DPM_PP_QUEUE_PVT dependencies on IEM_EMAIL_ACCOUNTS

Line 57: from iem_email_accounts a, iem_email_servers b, iem_migration_details c,

53:
54: cursor c_folder_details( p_type varchar2) is
55: select a.email_account_id,a.email_user||'@'||a.domain as user_name,
56: a.email_password,b.dns_name, b.port, c.migration_id, c.folder_name
57: from iem_email_accounts a, iem_email_servers b, iem_migration_details c,
58: iem_server_groups d, iem_email_server_types e
59: where ( c.folder_status='R' )
60: and c.folder_type= p_type and c.email_account_id=a.email_account_id
61: and a.server_group_id=d.server_group_id

Line 69: from iem_agent_accounts a, iem_email_accounts b,

65:
66: cursor c_agent_folder_details( p_type varchar2) is
67: select c.email_account_id,a.email_user||'@'||a.domain as user_name,
68: a.email_password,d.dns_name, d.port, c.migration_id, c.folder_name
69: from iem_agent_accounts a, iem_email_accounts b,
70: iem_migration_details c, iem_email_servers d, iem_server_groups e,
71: iem_email_server_types f
72: where ( c.folder_status='R' )
73: and c.folder_type= p_type and c.email_account_id=a.email_account_id