DBA Data[Home] [Help]

APPS.PNP_UTIL_FUNC dependencies on PN_VAR_RENT_INV_ALL

Line 8575: pn_var_rent_inv_all pvri,

8571: /* Get all abatements lines that will go bad with the new term dates */
8572: CURSOR chk_abat_retro IS
8573: SELECT pvr.rent_num
8574: FROM pn_var_rents_all pvr,
8575: pn_var_rent_inv_all pvri,
8576: pn_var_abatements_all pva
8577: WHERE pva.payment_term_id = p_term_id
8578: AND pvri.var_rent_inv_id = pva.var_rent_inv_id
8579: AND pvri.invoice_date NOT BETWEEN p_new_start_date