APPS.CN_SCA_TRX_PROC_PVT dependencies on CN_COMMISSION_HEADERS

Line 3275: FROM cn_commission_headers CCH, cn_salesreps CS

3271: CCH.OBJECT_VERSION_NUMBER,
3272: CCH.SPLIT_PCT,
3273: CCH.SPLIT_status,
3274: cch.org_id
3275: FROM cn_commission_headers CCH, cn_salesreps CS
3276: WHERE CCH.adj_comm_lines_api_id = sca_rollback_lines(j)
3277: AND CS.salesrep_id = CCH.direct_salesrep_id
3278: AND ((CCH.adjust_status IS NULL) or (CCH.adjust_status <> 'FROZEN')));
3279:

Line 3284: UPDATE cn_commission_headers CSH

3280: debugmsg('Check_comm_lines_api_adjusted : Creating reversals for loaded transactions that have been created for previous SCA results');
3281:
3282: FORALL j IN 1..sca_rollback_lines.COUNT
3283:
3284: UPDATE cn_commission_headers CSH
3285: SET adjust_status = 'FROZEN',
3286: reversal_header_id = CSH.commission_header_id,
3287: reversal_flag = 'Y',
3288: adjust_date = sysdate,

Line 3831: FROM cn_commission_headers CCH, cn_salesreps CS

3827: CCH.OBJECT_VERSION_NUMBER,
3828: CCH.SPLIT_PCT,
3829: CCH.SPLIT_status,
3830: cch.org_id
3831: FROM cn_commission_headers CCH, cn_salesreps CS
3832: WHERE CCH.adj_comm_lines_api_id = sca_lines_rollback(j)
3833: AND CS.salesrep_id = CCH.direct_salesrep_id
3834: AND ((CCH.adjust_status IS NULL) or (CCH.adjust_status <> 'FROZEN')));
3835:

Line 3840: UPDATE cn_commission_headers CSH

3836: debugmsg('Allocation Transfer : Rerun : Obsoleting loaded transactions that have been created for previous SCA results');
3837:
3838: FORALL j IN 1..sca_lines_rollback.COUNT
3839:
3840: UPDATE cn_commission_headers CSH
3841: SET adjust_status = 'FROZEN',
3842: reversal_header_id = CSH.commission_header_id,
3843: reversal_flag = 'Y',
3844: adjust_date = sysdate,