APPS.PN_VAR_RENTS_PKG dependencies on PN_VAR_RENT_INV_ALL

Line 904: AND pterm.var_rent_inv_id IN (SELECT var_rent_inv_id FROM pn_var_rent_inv_all

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
905: WHERE var_rent_id= vrent.var_rent_id
906: )
907: AND ps.PAYMENT_STATUS_LOOKUP_CODE='APPROVED'
908: );