APPS.BIX_AGENT_CLASS_P dependencies on BIX_DM_AGENT_CALL_SUM

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

154: null ';
155:
156: /* Fetch the data from the appropiate MV depending on the time range */
157: IF (g_time_range = 1) THEN
158: g_sqlstmt := g_sqlstmt || 'FROM bix_dm_agent_call_sum a ';
159: ELSIF (g_time_range = 2) THEN
160: g_sqlstmt := g_sqlstmt || 'FROM bix_dm_agent_sum1_mv a ';
161: ELSIF (g_time_range = 3) THEN
162: g_sqlstmt := g_sqlstmt || 'FROM bix_dm_agent_sum2_mv a ';

Line 463: from bix_dm_agent_call_sum b, JTF_RS_GROUP_MEMBERS j

459: /* Form and execute the SQL statement to insert into the temp table */
460: /* the total row corresponding to the agent group user has chosen */
461:
462: select count( distinct(b.resource_id) ) into agentNum
463: from bix_dm_agent_call_sum b, JTF_RS_GROUP_MEMBERS j
464: where group_id = p_group_id
465: and b.resource_id = j.resource_id;
466:
467: if agentNum is null then agentNum :=0;

Line 556: FROM bix_dm_agent_call_sum;

552: IF (g_period_ind IS NULL) THEN
553:
554: SELECT MAX(period_start_date)
555: INTO v_temp_date
556: FROM bix_dm_agent_call_sum;
557:
558: g_from_date := to_date(to_char(v_temp_date, 'dd/mm/yyyy') || ' 00:00:00','dd/mm/yyyy hh24:mi:ss');
559: g_to_date := to_date(to_char(v_temp_date, 'dd/mm/yyyy') || ' 23:59:59','dd/mm/yyyy hh24:mi:ss');
560: