DBA Data[Home] [Help]

APPS.PN_VAR_RENT_PKG dependencies on PN_VAR_ABATEMENTS_ALL

Line 2784: DELETE FROM pn_var_abatements_all abat

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;

Line 5230: DELETE FROM pn_var_abatements_all

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);