APPS.BIX_CALLS_HANDLED_BIN_PKG dependencies on BIX_DM_AGENT_CALL_SUM

Line 49: FROM bix_dm_agent_call_sum;

45:
46: /* The bin will always display data for maximum date for which data has been collected */
47: SELECT MAX(period_start_date)
48: INTO l_reporting_date
49: FROM bix_dm_agent_call_sum;
50:
51: /* Fetch the records of all the agents belonging to the group */
52: /* l_default_group_id and insert them in the table bix_dm_bin */
53: INSERT /*+ PARALLEL(tb,2) */ INTO bix_dm_bin tb (

Line 71: FROM bix_dm_agent_call_sum bac

67: , SUM(bac.out_calls_handled)
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