APPS.PN_VAR_RENTS_PKG dependencies on PN_PAYMENT_ITEMS_ALL

Line 900: pn_payment_items_all pi,

896: WHERE lease_id = p1_lease_id
897: AND commencement_date > p1_termination_dt
898: AND NOT EXISTS ( SELECT NULL
899: FROM pn_payment_schedules_all ps,
900: pn_payment_items_all pi,
901: pn_payment_terms_all pterm
902: WHERE pi.PAYMENT_SCHEDULE_ID = ps.PAYMENT_SCHEDULE_ID
903: AND pi.PAYMENT_TERM_ID = pterm.PAYMENT_TERM_ID
904: AND pterm.var_rent_inv_id IN (SELECT var_rent_inv_id FROM pn_var_rent_inv_all