DBA Data[Home] [Help]

APPS.CN_TRANSACTION_LOAD_PKG dependencies on CN_COMMISSION_HEADERS_S

Line 1406: SELECT cn_commission_headers_s.NEXTVAL

1402: l_skip_credit_flag := NVL(fnd_profile.VALUE('CN_SKIP_CREDIT_ALLOCATION'), 'Y');
1403: END IF;
1404:
1405: -- this is used to make it more restrict for handling reversal trx later on
1406: SELECT cn_commission_headers_s.NEXTVAL
1407: INTO l_init_commission_header_id
1408: FROM DUAL;
1409:
1410: FOR batch IN batches LOOP

Line 1599: (SELECT cn_commission_headers_s.NEXTVAL

1595: , split_pct
1596: , split_status
1597: , org_id
1598: ) -- vensrini transaction load fix
1599: (SELECT cn_commission_headers_s.NEXTVAL
1600: , batch.salesrep_id
1601: , TRUNC(api.processed_date)
1602: , batch.period_id
1603: , TRUNC(api.rollup_date)

Line 1943: (SELECT cn_commission_headers_s.NEXTVAL

1939: , split_pct
1940: , split_status
1941: , org_id
1942: ) -- vensrini transaction load fix
1943: (SELECT cn_commission_headers_s.NEXTVAL
1944: , batch.salesrep_id
1945: , TRUNC(api.processed_date)
1946: , batch.period_id
1947: , TRUNC(api.rollup_date)