APPS.CN_PREPOST_PVT dependencies on CN_PAYRUNS

Line 737: cn_payruns pr,

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
741: and pr.pay_period_id = pp.period_id

Line 761: from cn_payruns pr,

757: -- Cursor used to pick up payruns and update their posting statuses STATUS to
758: -- POSTED if all the corresponding payment worksheets are posted successfully
759: cursor get_posted_payruns is
760: select pr.payrun_id
761: from cn_payruns pr,
762: cn_period_statuses ps,
763: cn_posting_batches pb
764: where pr.pay_period_id = ps.period_id
765: and (pr.status = 'PAID' or pr.status = 'PAID_WITH_RETURNS')

Line 1006: -- declare cursor to select from cn_payruns

1002: -- if so update the posting status of the pay run.
1003: -- You may want to make this independent of the l_pay_ws_rec loop
1004: -- and select pay runs based on the batch start and end dates.
1005:
1006: -- declare cursor to select from cn_payruns
1007: -- where pr.pay_period_id = pp.pay_period_id
1008: -- and pp.start_date between pb.start_date and pb.end_date
1009: -- (DON'T FORGET TO MAKE SAME CHANGE FOR l_pay_ws_rec)
1010:

Line 1023: cn_payruns_pkg.update_record(x_payrun_id => l_posted_payrun.payrun_id,

1019:
1020: for l_posted_payrun in get_posted_payruns loop
1021: null;
1022: /*
1023: cn_payruns_pkg.update_record(x_payrun_id => l_posted_payrun.payrun_id,
1024: x_status => C_POSTED,
1025: x_last_updated_by => FND_GLOBAL.USER_ID,
1026: x_last_update_date => SYSDATE,
1027: x_last_update_login => FND_GLOBAL.LOGIN_ID);