APPS.BIX_KPI_CLS_RPT_PKG dependencies on BIX_DM_AGENT_CALL_SUM

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

122:
123: /* Fetch the data from the appropiate MV depending on the time range */
124: IF (l_time_range = 1)
125: THEN
126: g_sqlstmt := g_sqlstmt || 'FROM bix_dm_agent_call_sum a ';
127: ELSIF (l_time_range = 2)
128: THEN
129: g_sqlstmt := g_sqlstmt || 'FROM bix_dm_agent_sum1_mv a ';
130: ELSIF (l_time_range = 3)

Line 325: FROM bix_dm_agent_call_sum;

321: IF (l_period_ind IS NULL)
322: THEN
323: SELECT MAX(period_start_date)
324: INTO v_temp_date
325: FROM bix_dm_agent_call_sum;
326:
327: p_start_date := to_date(to_char(v_temp_date, 'dd/mm/yyyy') ||
328: ' 00:00:00','dd/mm/yyyy hh24:mi:ss');
329: p_end_date := to_date(to_char(v_temp_date, 'dd/mm/yyyy') ||