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 3124: FROM pn_payment_items_all pitem

3120:
3121:
3122: SELECT nvl(SUM(pitem.actual_amount),0)
3123: INTO l_billed_recovery
3124: FROM pn_payment_items_all pitem
3125: ,pn_payment_schedules_all psched
3126: ,pn_payment_terms_all ppt
3127: WHERE psched.payment_status_lookup_code = 'APPROVED'
3128: AND to_date(to_char(psched.schedule_date,'mm/yyyy'),'mm/yyyy') between