APPS.CN_CALC_ROLLUP_PVT dependencies on CN_COMMISSION_LINES_S

Line 212: ( SELECT cn_commission_lines_s.NEXTVAL, commission_header_id, direct_salesrep_id, pre_processed_code

208: INSERT INTO cn_commission_lines_all
209: ( commission_line_id, commission_header_id, direct_salesrep_id, pre_processed_code, revenue_class_id
210: , credited_salesrep_id, credited_comp_group_id, pending_status, pending_date, created_during, status
211: , processed_date, processed_period_id, trx_type, created_by, creation_date, rollup_level, org_id )
212: ( SELECT cn_commission_lines_s.NEXTVAL, commission_header_id, direct_salesrep_id, pre_processed_code
213: , revenue_class_id, p_salesrep_id, p_credited_comp_group_id, l_pending_status
214: , DECODE( l_pending_status, 'Y', SYSDATE, NULL ), 'ROLL', 'ROLL', processed_date, processed_period_id
215: , trx_type, g_created_by, g_creation_date, p_rollup_level, org_id
216: FROM cn_commission_headers_all

Line 228: ( SELECT cn_commission_lines_s.NEXTVAL, commission_header_id, direct_salesrep_id, pre_processed_code

224: INSERT INTO cn_commission_lines_all
225: ( commission_line_id, commission_header_id, direct_salesrep_id, pre_processed_code, revenue_class_id
226: , credited_salesrep_id, credited_comp_group_id, pending_status, pending_date, created_during, status
227: , processed_date, processed_period_id, trx_type, created_by, creation_date, rollup_level, org_id )
228: ( SELECT cn_commission_lines_s.NEXTVAL, commission_header_id, direct_salesrep_id, pre_processed_code
229: , revenue_class_id, p_salesrep_id, p_credited_comp_group_id, l_pending_status
230: , DECODE( l_pending_status, 'Y', SYSDATE, NULL ), 'ROLL', 'ROLL', processed_date, processed_period_id
231: , trx_type, g_created_by, g_creation_date, p_rollup_level, org_id
232: FROM cn_commission_headers_all head