DBA Data[Home] [Help]

APPS.CN_CALC_ROLLUP_PVT dependencies on CN_COMMISSION_HEADERS_S

Line 124: VALUES ( cn_commission_headers_s.NEXTVAL, rep_ids( i ), processed_dates( i ), period_ids( i )

120: INSERT INTO cn_commission_headers_all
121: ( commission_header_id, direct_salesrep_id, processed_date, processed_period_id
122: , trx_type, status, rollup_date, comp_group_id, revenue_class_id, transaction_amount
123: , quantity, pre_processed_code, parent_header_id, creation_date, created_by, org_id )
124: VALUES ( cn_commission_headers_s.NEXTVAL, rep_ids( i ), processed_dates( i ), period_ids( i )
125: , trx_types( i ), 'CLS_SUM', rollup_dates( i ), group_ids( i ), rev_class_ids( i ), amounts( i )
126: , units( i ), 'CRPC', -1, SYSDATE, g_created_by, g_org_id )
127: RETURNING commission_header_id
128: BULK COLLECT INTO header_ids;