APPS.BIX_CALLS_TYPE_BIN_PKG dependencies on CCT_CLASSIFICATIONS

Line 49: , cct_classifications cct

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
53: , cct.classification );