APPS.CN_SCA_TRX_PROC_PVT dependencies on CN_COMMISSION_HEADERS

Line 3277: FROM cn_commission_headers CCH, cn_salesreps CS

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

Line 3287: UPDATE cn_commission_headers CSH

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

Line 3835: FROM cn_commission_headers CCH, cn_salesreps CS

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

Line 3845: UPDATE cn_commission_headers CSH

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