DBA Data[Home] [Help]

APPS.PN_VAR_RENT_PKG dependencies on PN_VAR_ABATEMENTS_ALL

Line 2780: DELETE FROM pn_var_abatements_all abat

2776:
2777: DELETE FROM pn_var_abat_defaults_all
2778: where var_rent_id = p_var_rent_id;
2779:
2780: DELETE FROM pn_var_abatements_all abat
2781: where abat.var_rent_id=p_var_rent_id;
2782:
2783: DELETE FROM pn_var_bkdt_defaults_all
2784: WHERE var_rent_id = p_var_rent_id;

Line 5226: DELETE FROM pn_var_abatements_all

5222: IF SQL%NOTFOUND THEN
5223: NULL;
5224: END IF;
5225:
5226: DELETE FROM pn_var_abatements_all
5227: WHERE var_rent_inv_id IN
5228: (SELECT var_rent_inv_id
5229: FROM pn_var_rent_inv_all
5230: WHERE var_rent_id = p_var_rent_id);