APPS.IEM_MAILITEM_PUB dependencies on JTF_RS_GROUP_MEMBERS

Line 42: AND (a.group_id in (select group_id from jtf_rs_group_members where resource_id=p_resource_id

38: and a.email_account_id=b.email_account_id
39: and a.rt_classification_id=c.route_classification_id
40: AND a.email_account_id=d.email_account_id
41: AND d.resource_id=p_resource_id
42: AND (a.group_id in (select group_id from jtf_rs_group_members where resource_id=p_resource_id
43: and delete_flag<>'Y')
44: or (a.group_id=0))
45: and a.message_id not in (select message_id from iem_reroute_hists where agent_id=p_resource_id)
46: GROUP by a.email_account_id,a.rt_classification_id,b.USER_NAME,c.name;

Line 94: from jtf_rs_group_members

90: SAVEPOINT select_mail_count_pvt;
91: x_return_status := FND_API.G_RET_STS_SUCCESS;
92:
93: select count(*) into l_count
94: from jtf_rs_group_members
95: where resource_id=p_resource_id
96: and delete_flag<>'Y';
97: IF l_count>0 then -- It is a valid agent should get queue message if any
98: IF p_tbl is null then

Line 626: from jtf_rs_group_members gm

622: and resource_id=0
623: and ( p.group_id = 0
624: or exists (
625: select null
626: from jtf_rs_group_members gm
627: where resource_id=:res
628: and gm.group_id = p.group_id
629: and delete_flag <>''Y''
630: )

Line 652: from jtf_rs_group_members gm

648: and resource_id=0
649: and ( p.group_id = 0
650: or exists (
651: select null
652: from jtf_rs_group_members gm
653: where resource_id=:res
654: and gm.group_id = p.group_id
655: and delete_flag <>''Y''
656: )

Line 896: from jtf_rs_group_members

892: END IF;
893: SAVEPOINT getgroupdetails_PVT;
894: x_return_status := FND_API.G_RET_STS_SUCCESS;
895: select group_id bulk collect into x_tbl
896: from jtf_rs_group_members
897: where resource_id=p_resource_id
898: and delete_flag<>'Y';
899: IF x_tbl.count=0 then
900: raise NOT_A_VALID_AGENT;