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
742: AND pp.start_date BETWEEN pb.start_date AND pb.end_date
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')
766: and pb.load_status = C_UNLOADED
767: and pb.posting_batch_id = CN_PREPOSTBATCHES.G_BATCH_ID