APPS.BIX_CALLS_TYPE_RPT_PKG dependencies on BIX_DM_AGENT_CALL_SUM

Line 120: g_sqlstmt := g_sqlstmt || 'FROM bix_dm_agent_call_sum a, cct_classifications b ';

116: /* g_time_range = 3 implies user wants data by 2 hour : get the data from 2 hour MV */
117: /* g_time_range = 4 implies user wants data by 4 hour : get the data from 4 hour MV */
118: /* g_time_range = 5 implies user wants data by day : get the data from day MV */
119: IF (g_time_range = 1) THEN
120: g_sqlstmt := g_sqlstmt || 'FROM bix_dm_agent_call_sum a, cct_classifications b ';
121: ELSIF (g_time_range = 2) THEN
122: g_sqlstmt := g_sqlstmt || 'FROM bix_dm_agent_sum1_mv a, cct_classifications b ';
123: ELSIF (g_time_range = 3) THEN
124: g_sqlstmt := g_sqlstmt || 'FROM bix_dm_agent_sum2_mv a, cct_classifications b ';

Line 231: FROM bix_dm_agent_call_sum;

227: IF (g_period_ind IS NULL) THEN
228: /* If the period indicator is NULL then report on the maximum date for which data has been collected */
229: SELECT MAX(period_start_date)
230: INTO l_temp_date
231: FROM bix_dm_agent_call_sum;
232:
233: g_from_date := to_date(to_char(l_temp_date, 'dd/mm/yyyy') || ' 00:00:00','dd/mm/yyyy hh24:mi:ss');
234: g_to_date := to_date(to_char(l_temp_date, 'dd/mm/yyyy') || ' 23:59:59','dd/mm/yyyy hh24:mi:ss');
235: