DBA Data[Home] [Help]

APPS.PN_VAR_RENTS_PKG dependencies on PN_PAYMENT_TERMS_ALL

Line 901: pn_payment_terms_all pterm

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
905: WHERE var_rent_id= vrent.var_rent_id