DBA Data[Home] [Help]

APPS.BIX_CALLS_HANDLED_BIN_PKG dependencies on JTF_RS_RESOURCE_EXTNS

Line 36: , jtf_rs_resource_extns rsc

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;
40: EXCEPTION

Line 73: , jtf_rs_resource_extns rsc

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
77: AND bac.period_start_date = l_reporting_date