APPS.BIX_CALLS_TYPE_BIN_PKG dependencies on BIX_DM_AGENT_CALL_SUM

Line 26: FROM bix_dm_agent_call_sum;

22:
23: /* The bin will always display data for maximum date for which data has been collected */
24: SELECT MAX(period_start_date)
25: INTO l_reporting_date
26: FROM bix_dm_agent_call_sum;
27:
28: /* Fetch all the records from the summary table for l_reporting_date grouped by classification */
29: INSERT /*+ PARALLEL(tb,2) */ INTO bix_dm_bin tb (
30: session_id

Line 48: FROM bix_dm_agent_call_sum acs

44: , bix_util_pkg.get_hrmiss_frmt(SUM(acs.queue_time)
45: / DECODE(SUM(acs.calls_in_queue), 0, 1, SUM(acs.calls_in_queue)))
46: , trunc((SUM(acs.calls_answrd_within_x_time)
47: / DECODE(SUM(acs.in_calls_handled), 0, 1, SUM(acs.in_calls_handled))) * 100, 2)
48: FROM bix_dm_agent_call_sum acs
49: , cct_classifications cct
50: WHERE acs.period_start_date = l_reporting_date
51: AND acs.classification_id = cct.classification_id
52: GROUP BY acs.classification_id