DBA Data[Home] [Help]

APPS.IEM_REROUTE_PUB dependencies on JTF_RS_GROUP_MEMBERS

Line 174: jtf_rs_group_members c,iem_agents d

170: -- The below query verify that existing group for the message is valid. In this regard it checks its association
171: -- with more than one agent i.e group should have some additional agent then the current one to fetch the
172: -- message
173: select count(*) into l_count from
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);