APPS.CN_TRANSACTION_LOAD_PKG dependencies on CN_COMMISSION_HEADERS_ALL

Line 1785: FROM cn_commission_headers_all cmh

1781: AND api.salesrep_id = batch.salesrep_id
1782: AND api.processed_date >= TRUNC(batch.start_date)
1783: AND api.processed_date <(TRUNC(batch.end_date) + 1)
1784: AND NOT EXISTS(SELECT 'this transaction has already been loaded'
1785: FROM cn_commission_headers_all cmh
1786: WHERE cmh.comm_lines_api_id = api.comm_lines_api_id));
1787: ELSE
1788: INSERT INTO cn_commission_headers
1789: (

Line 2130: FROM cn_commission_headers_all cmh

2126: AND api.processed_date >= TRUNC(batch.start_date)
2127: AND api.processed_date <(TRUNC(batch.end_date) + 1)
2128: AND (api.terr_id IS NOT NULL OR api.preserve_credit_override_flag = 'Y')
2129: AND NOT EXISTS(SELECT 'this transaction has already been loaded'
2130: FROM cn_commission_headers_all cmh
2131: WHERE cmh.comm_lines_api_id = api.comm_lines_api_id));
2132: END IF; /* end if l_skip_credit_flag */
2133:
2134: debugmsg('Loader : number of loaded trx = ' || TO_CHAR(SQL%ROWCOUNT));