DBA Data[Home] [Help]

APPS.PN_VAR_ABATEMENT_AMOUNT_PKG dependencies on PN_PAYMENT_TERMS_ALL

Line 339: DELETE FROM pn_payment_terms_all

335:
336: l_abt_amt := NVL(calc_abatement(p_var_rent_inv_id,p_min_grp_dt,p_max_grp_dt),0);
337:
338: IF NVL(p_term_exists,'N') = 'Y' THEN
339: DELETE FROM pn_payment_terms_all
340: WHERE var_rent_inv_id=p_var_rent_inv_id
341: and var_rent_type = p_var_rent_type
342: and NVL(status,'DRAFT')='DRAFT';
343: END IF;