APPS.IEM_MGINBOX_PUB dependencies on IEM_AGENT_ACCOUNTS

Line 51: from iem_post_mdts a, iem_agent_accounts b

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

Line 59: from iem_post_mdts a, iem_agent_accounts b

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

Line 70: from iem_post_mdts a, iem_agent_accounts b

66:
67: -- Cursor for p_rerun == 'Y' and p_type == 'O'
68: Cursor acq_outb_re_cur IS
69: select a.*
70: from iem_post_mdts a, iem_agent_accounts b
71: where a.email_account_id = p_email_account_id and a.agent_id =
72: b.resource_id and b.agent_account_id = p_agent_account_id and
73: a.email_account_id = b.email_account_id
74: and a.message_id not in (select message_id from iem_migration_store_temp