APPS.PN_REC_CALC_PKG dependencies on PN_PAYMENT_SCHEDULES_ALL

Line 3125: ,pn_payment_schedules_all psched

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