DBA Data[Home] [Help]

APPS.CN_PREPOST_PVT dependencies on CN_POSTING_BATCHES

Line 738: cn_posting_batches pb,

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

Line 763: cn_posting_batches pb

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