[Home] [Help]
8570:
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