APPS.CN_PREPOST_PVT dependencies on CN_PAYMENT_WORKSHEETS

Line 736: FROM cn_payment_worksheets ws,

732: ws.COMM_DRAW COMM_TO_REC, -- to recov w pp
733: ws.REG_BONUS_REC BONUS_REC,
734: ws.REG_BONUS_TO_REC BONUS_TO_REC
735: -- ws.POSTING_STATUS
736: FROM cn_payment_worksheets ws,
737: cn_payruns pr,
738: cn_posting_batches pb,
739: cn_period_statuses pp
740: WHERE pr.payrun_id = ws.payrun_id

Line 770: from cn_payment_worksheets ws

766: and pb.load_status = C_UNLOADED
767: and pb.posting_batch_id = CN_PREPOSTBATCHES.G_BATCH_ID
768: and ps.start_date between pb.start_date and pb.end_date
769: and not exists ( select 1
770: from cn_payment_worksheets ws
771: where ws.payrun_id = pr.payrun_id
772: and ws.posting_status = C_UNPOSTED
773: );
774: BEGIN

Line 984: --UPDATE cn_payment_worksheets

980:
981: -- Update posting status of POSTED worksheet
982: -- Replace with table api
983:
984: --UPDATE cn_payment_worksheets
985: --SET posting_status = C_POSTED
986: --WHERE payment_worksheet_id = l_pay_ws_rec.payment_worksheet_id;
987:
988: cn_payment_worksheets_pkg.update_record

Line 988: cn_payment_worksheets_pkg.update_record

984: --UPDATE cn_payment_worksheets
985: --SET posting_status = C_POSTED
986: --WHERE payment_worksheet_id = l_pay_ws_rec.payment_worksheet_id;
987:
988: cn_payment_worksheets_pkg.update_record
989: (
990: x_payment_worksheet_id => l_pay_ws_rec.payment_worksheet_id,
991: x_posting_status => c_posted,
992: x_last_update_date => SYSDATE,