APPS.PN_REC_CALC_PKG dependencies on PN_PAYMENT_SCHEDULES_ALL

Line 3210: ,pn_payment_schedules_all psched

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
3214: to_date(to_char( p_calc_period_start_date,'mm/yyyy'),'mm/yyyy')