DBA Data[Home] [Help]

APPS.CN_TRANSACTION_LOAD_PUB dependencies on CN_COMMISSION_HEADERS_S

Line 126: SELECT cn_commission_headers_s.NEXTVAL

122: l_skip_credit_flag := NVL(Fnd_Profile.VALUE('CN_SKIP_CREDIT_ALLOCATION'), 'Y');
123: END IF;
124:
125: -- this is used to make it more restrict for handling reversal trx later on
126: SELECT cn_commission_headers_s.NEXTVAL
127: INTO l_init_commission_header_id FROM dual;
128:
129: FOR batch IN batches LOOP
130:

Line 311: cn_commission_headers_s.nextval,

307: split_pct,
308: split_status,
309: org_id)
310: (SELECT
311: cn_commission_headers_s.nextval,
312: batch.salesrep_id,
313: Trunc(api.processed_date),
314: batch.period_id,
315: Trunc(api.rollup_date),

Line 655: cn_commission_headers_s.nextval,

651: split_pct,
652: split_status,
653: org_id)
654: (SELECT
655: cn_commission_headers_s.nextval,
656: batch.salesrep_id,
657: Trunc(api.processed_date),
658: batch.period_id,
659: Trunc(api.rollup_date),