DBA Data[Home] [Help]

APPS.IEM_REROUTE_PUB dependencies on IEM_REROUTE_HISTS

Line 178: and d.resource_id not in (select agent_id from iem_reroute_hists where message_id=p_msgid);

174: jtf_rs_group_members c,iem_agents d
175: where group_id=l_post_rec.group_id
176: and delete_flag = 'N' and c.resource_id<>p_agent_id and c.resource_id = d.resource_id
177: and d.email_account_id = l_post_rec.email_account_id
178: and d.resource_id not in (select agent_id from iem_reroute_hists where message_id=p_msgid);
179: IF l_count>0 then --existing group is a valid group
180: l_group_id:=l_post_rec.group_id;
181: ELSE
182: l_group_id:=0; -- No more valid group available.So route to ALL group