2780:
2781: DELETE FROM pn_var_abat_defaults_all
2782: where var_rent_id = p_var_rent_id;
2783:
2784: DELETE FROM pn_var_abatements_all abat
2785: where abat.var_rent_id=p_var_rent_id;
2786:
2787: DELETE FROM pn_var_bkdt_defaults_all
2788: WHERE var_rent_id = p_var_rent_id;
5226: IF SQL%NOTFOUND THEN
5227: NULL;
5228: END IF;
5229:
5230: DELETE FROM pn_var_abatements_all
5231: WHERE var_rent_inv_id IN
5232: (SELECT var_rent_inv_id
5233: FROM pn_var_rent_inv_all
5234: WHERE var_rent_id = p_var_rent_id);