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.PN_REC_CALC_PKG dependencies on PN_PAYMENT_ITEMS_ALL

Line 3209: FROM pn_payment_items_all pitem

3205:
3206:
3207: SELECT nvl(SUM(pitem.actual_amount),0)
3208: INTO l_billed_recovery
3209: FROM pn_payment_items_all pitem
3210: ,pn_payment_schedules_all psched
3211: ,pn_payment_terms_all ppt
3212: WHERE psched.payment_status_lookup_code = 'APPROVED'
3213: AND to_date(to_char(psched.schedule_date,'mm/yyyy'),'mm/yyyy') between