APPS.BIX_SUMMARY_PUB dependencies on BIX_SUM_AGT_CLS

Line 56: DELETE FROM bix_sum_agt_cls

52:
53: DELETE FROM bix_sum_grp_cls
54: WHERE hour BETWEEN g_start_date AND g_end_date;
55:
56: DELETE FROM bix_sum_agt_cls
57: WHERE hour BETWEEN g_start_date AND g_end_date;
58:
59:
60: FOR call IN POP_BIX_SUM_GRP_CLS LOOP

Line 118: INSERT INTO BIX_SUM_AGT_CLS

114: call.resolution_time_internal,
115: call.number_of_interactions
116: );
117:
118: INSERT INTO BIX_SUM_AGT_CLS
119: (
120: sum_agt_cls_id,
121: campaign_id,
122: interaction_classification,

Line 149: BIX_SUM_AGT_CLS_S.nextval,

145: number_of_interactions
146: )
147: VALUES
148: (
149: BIX_SUM_AGT_CLS_S.nextval,
150: call.campaign_id,
151: call.interaction_classification,
152: call.media_item_type,
153: call.interaction_center_id,