APPS.IEM_MGINBOX_PUB dependencies on IEM_AGENT_ACCOUNTS

Line 52: from iem_post_mdts a, iem_agent_accounts b

48:
49: -- Cursor for p_rerun == 'N'
50: Cursor acq_cur IS
51: select a.*
52: from iem_post_mdts a, iem_agent_accounts b
53: where a.email_account_id = p_email_account_id and a.agent_id =
54: b.resource_id and b.agent_account_id = p_agent_account_id and
55: a.email_account_id = b.email_account_id
56: and a.message_id in (select message_id from iem_rt_media_items a,

Line 63: from iem_post_mdts a, iem_agent_accounts b

59:
60: -- Cursor for p_rerun == 'Y' and p_type == 'I'
61: Cursor acq_inb_re_cur IS
62: select a.*
63: from iem_post_mdts a, iem_agent_accounts b
64: where a.email_account_id = p_email_account_id and a.agent_id =
65: b.resource_id and b.agent_account_id = p_agent_account_id and
66: a.email_account_id = b.email_account_id
67: and a.message_id not in (select message_id from iem_migration_store_temp

Line 77: from iem_post_mdts a, iem_agent_accounts b

73:
74: -- Cursor for p_rerun == 'Y' and p_type == 'O'
75: Cursor acq_outb_re_cur IS
76: select a.*
77: from iem_post_mdts a, iem_agent_accounts b
78: where a.email_account_id = p_email_account_id and a.agent_id =
79: b.resource_id and b.agent_account_id = p_agent_account_id and
80: a.email_account_id = b.email_account_id
81: and a.message_id not in (select message_id from iem_migration_store_temp