APPS.BIX_CALLS_HANDLED_RPT_PKG dependencies on BIX_DM_AGENT_CALL_SUM

Line 151: g_sqlstmt := g_sqlstmt || 'FROM bix_dm_agent_call_sum a ';

147: /* g_time_range = 3 implies user wants data by 2 hour : get the data from 2 hour MV */
148: /* g_time_range = 4 implies user wants data by 4 hour : get the data from 4 hour MV */
149: /* g_time_range = 5 implies user wants data by day : get the data from day MV */
150: IF (g_time_range = 1) THEN
151: g_sqlstmt := g_sqlstmt || 'FROM bix_dm_agent_call_sum a ';
152: ELSIF (g_time_range = 2) THEN
153: g_sqlstmt := g_sqlstmt || 'FROM bix_dm_agent_sum1_mv a ';
154: ELSIF (g_time_range = 3) THEN
155: g_sqlstmt := g_sqlstmt || 'FROM bix_dm_agent_sum2_mv a ';

Line 443: FROM bix_dm_agent_call_sum;

439: IF (g_period_ind IS NULL) THEN
440: /* If the period indicator is NULL then report on the maximum date for which data has been collected */
441: SELECT MAX(period_start_date)
442: INTO l_temp_date
443: FROM bix_dm_agent_call_sum;
444:
445: g_from_date := to_date(to_char(l_temp_date, 'dd/mm/yyyy') || ' 00:00:00','dd/mm/yyyy hh24:mi:ss');
446: g_to_date := to_date(to_char(l_temp_date, 'dd/mm/yyyy') || ' 23:59:59','dd/mm/yyyy hh24:mi:ss');
447: