APPS.BIX_KPI_AGENT_RPT_PKG dependencies on BIX_DM_AGENT_CALL_SUM

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

164: /* g_time_range = 3 implies user wants data by 2 hour : get the data from 2 hour MV */
165: /* g_time_range = 4 implies user wants data by 4 hour : get the data from 4 hour MV */
166: /* g_time_range = 5 implies user wants data by day : get the data from day MV */
167: IF (g_time_range = 1) THEN
168: g_sqlstmt := g_sqlstmt || 'FROM bix_dm_agent_call_sum a ';
169: ELSIF (g_time_range = 2) THEN
170: g_sqlstmt := g_sqlstmt || 'FROM bix_dm_agent_sum1_mv a ';
171: ELSIF (g_time_range = 3) THEN
172: g_sqlstmt := g_sqlstmt || 'FROM bix_dm_agent_sum2_mv a ';

Line 468: FROM bix_dm_agent_call_sum;

464: IF (g_period_ind IS NULL) THEN
465: /* If the period indicator is NULL then report on the maximum date for which data has been collected */
466: SELECT MAX(period_start_date)
467: INTO l_temp_date
468: FROM bix_dm_agent_call_sum;
469:
470: g_from_date := to_date(to_char(l_temp_date, 'dd/mm/yyyy') || ' 00:00:00','dd/mm/yyyy hh24:mi:ss');
471: g_to_date := to_date(to_char(l_temp_date, 'dd/mm/yyyy') || ' 23:59:59','dd/mm/yyyy hh24:mi:ss');
472: