APPS.CN_TRANSACTION_LOAD_PKG dependencies on CN_COMMISSION_HEADERS_ALL

Line 1773: FROM cn_commission_headers_all cmh

1769: AND api.salesrep_id = batch.salesrep_id
1770: AND api.processed_date >= TRUNC(batch.start_date)
1771: AND api.processed_date <(TRUNC(batch.end_date) + 1)
1772: AND NOT EXISTS(SELECT 'this transaction has already been loaded'
1773: FROM cn_commission_headers_all cmh
1774: WHERE cmh.comm_lines_api_id = api.comm_lines_api_id));
1775: ELSE
1776: INSERT INTO cn_commission_headers
1777: (

Line 2118: FROM cn_commission_headers_all cmh

2114: AND api.processed_date >= TRUNC(batch.start_date)
2115: AND api.processed_date <(TRUNC(batch.end_date) + 1)
2116: AND (api.terr_id IS NOT NULL OR api.preserve_credit_override_flag = 'Y')
2117: AND NOT EXISTS(SELECT 'this transaction has already been loaded'
2118: FROM cn_commission_headers_all cmh
2119: WHERE cmh.comm_lines_api_id = api.comm_lines_api_id));
2120: END IF; /* end if l_skip_credit_flag */
2121:
2122: debugmsg('Loader : number of loaded trx = ' || TO_CHAR(SQL%ROWCOUNT));