DBA Data[Home] [Help]

APPS.IEM_INBE_PVT dependencies on IEM_AGENTS

Line 23: from iem_mstemail_accounts a,iem_agents c

19: p_acct_flag varchar2(1);
20:
21: CURSOR c_inb_nodes_1 IS
22: select a.from_name, a.email_account_id, c.resource_id
23: from iem_mstemail_accounts a,iem_agents c
24: where a.email_account_id=c.email_account_id
25: and c.resource_id=p_resource_id
26: group by a.from_name,a.email_account_id,c.resource_id
27: order by 1;

Line 76: from iem_mstemail_accounts acc, iem_agents agents

72: begin
73: /* query to check the cherry pick flag at the user and account level*/
74: select acc.cherry_pick_flag ,agents.cherry_pick_flag
75: into p_acct_flag,p_user_flag
76: from iem_mstemail_accounts acc, iem_agents agents
77: where acc.email_account_id=cur_rec.email_account_id
78: and agents.resource_id =p_resource_id
79: and acc.email_account_id = agents.email_account_id;
80: