APPS.BIX_CALLS_HANDLED_BIN_PKG dependencies on JTF_RS_GROUP_MEMBERS

Line 35: FROM jtf_rs_group_members grp

31: IF l_default_group_id IS NULL THEN
32: BEGIN
33: SELECT grp.group_id
34: INTO l_default_group_id
35: FROM jtf_rs_group_members grp
36: , jtf_rs_resource_extns rsc
37: WHERE grp.resource_id = rsc.resource_id
38: AND rsc.user_id = fnd_global.user_id()
39: AND ROWNUM <= 1;

Line 72: , jtf_rs_group_members mem

68: , bix_util_pkg.get_hrmiss_frmt(trunc(SUM(bac.in_talk_time + bac.out_talk_time + bac.in_wrap_time +
69: bac.out_wrap_time) / DECODE(SUM(bac.in_calls_handled + bac.out_calls_handled),
70: 0, 1, SUM(bac.in_calls_handled + bac.out_calls_handled))))
71: FROM bix_dm_agent_call_sum bac
72: , jtf_rs_group_members mem
73: , jtf_rs_resource_extns rsc
74: WHERE mem.group_id = l_default_group_id
75: AND mem.resource_id = rsc.resource_id
76: AND mem.resource_id = bac.resource_id