DBA Data[Home] [Help]

APPS.CN_TRANSACTION_LOAD_PKG dependencies on CN_COMMISSION_HEADERS_S

Line 1418: SELECT cn_commission_headers_s.NEXTVAL

1414: l_skip_credit_flag := NVL(fnd_profile.VALUE('CN_SKIP_CREDIT_ALLOCATION'), 'Y');
1415: END IF;
1416:
1417: -- this is used to make it more restrict for handling reversal trx later on
1418: SELECT cn_commission_headers_s.NEXTVAL
1419: INTO l_init_commission_header_id
1420: FROM DUAL;
1421:
1422: FOR batch IN batches LOOP

Line 1611: (SELECT cn_commission_headers_s.NEXTVAL

1607: , split_pct
1608: , split_status
1609: , org_id
1610: ) -- vensrini transaction load fix
1611: (SELECT cn_commission_headers_s.NEXTVAL
1612: , batch.salesrep_id
1613: , TRUNC(api.processed_date)
1614: , batch.period_id
1615: , TRUNC(api.rollup_date)

Line 1955: (SELECT cn_commission_headers_s.NEXTVAL

1951: , split_pct
1952: , split_status
1953: , org_id
1954: ) -- vensrini transaction load fix
1955: (SELECT cn_commission_headers_s.NEXTVAL
1956: , batch.salesrep_id
1957: , TRUNC(api.processed_date)
1958: , batch.period_id
1959: , TRUNC(api.rollup_date)