APPS.BIX_AGT_COLLECT dependencies on BIX_SUM_AGENT

Line 87: DELETE from BIX_SUM_AGENT

83:
84: BEGIN
85: -- delete the existing data for the selected date range
86:
87: DELETE from BIX_SUM_AGENT
88: WHERE day between p_start_date and p_end_date;
89:
90: OPEN get_login_time;
91: FETCH get_login_time

Line 148: INSERT INTO BIX_SUM_AGENT

144: v_center_id := center_data.center_id;
145: end LOOP;
146: END IF;
147:
148: INSERT INTO BIX_SUM_AGENT
149: (
150: INTERACTION_CENTER_ID,
151: RESOURCE_ID,
152: TALK_TIME,