DBA Data[Home] [Help]

APPS.PN_VAR_RENTS_PKG dependencies on PN_PAYMENT_SCHEDULES_ALL

Line 899: FROM pn_payment_schedules_all ps,

895: FROM pn_var_rents_all vrent
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