eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CN_PREPOST_PVT dependencies on CN_PERIOD_STATUSES

Line 739: cn_period_statuses pp

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
743: AND ( pr.status = 'PAID'

Line 762: cn_period_statuses ps,

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')
766: and pb.load_status = C_UNLOADED