APPS.PN_VAR_RENT_CALC_PKG dependencies on PN_VAR_ABAT_DEFAULTS_ALL

Line 3324: FROM PN_VAR_ABAT_DEFAULTS_ALL

3320: CURSOR fixed_abat_c(ip_var_rent_id NUMBER,
3321: ip_inv_start_date DATE,
3322: ip_inv_end_date DATE) IS
3323: SELECT NVL(SUM(amount),0) fixed_abat
3324: FROM PN_VAR_ABAT_DEFAULTS_ALL
3325: WHERE var_rent_id = ip_var_rent_id
3326: AND start_date <= ip_inv_end_date
3327: AND NVL(end_date, ip_inv_end_date) >= ip_inv_start_date
3328: AND type_code = pn_var_rent_calc_pkg.G_ABAT_TYPE_CODE_ABAT;

Line 3590: FROM PN_VAR_ABAT_DEFAULTS_ALL

3586: ip_inv_end_date DATE) IS
3587: SELECT NVL(amount, 0) rolling_allow
3588: ,allowance_applied allow_applied
3589: ,abatement_id
3590: FROM PN_VAR_ABAT_DEFAULTS_ALL
3591: WHERE var_rent_id = ip_var_rent_id
3592: AND start_date <= ip_inv_end_date
3593: AND NVL(end_date, ip_inv_end_date) >= ip_inv_start_date
3594: AND type_code = pn_var_rent_calc_pkg.G_ABAT_TYPE_CODE_ALLO

Line 3711: UPDATE pn_var_abat_defaults_all

3707: l_prev_abt_rent := l_cur_abt_rent;
3708: pnp_debug_pkg.log('l_prev_abt_rent:'||l_prev_abt_rent);
3709: l_allow_applied_inv := l_allow_applied_inv + l_allow_applied;
3710: pnp_debug_pkg.log('l_allow_applied_inv:'||l_allow_applied_inv);
3711: UPDATE pn_var_abat_defaults_all
3712: SET allowance_applied = NVL(allowance_applied,0)+l_allow_applied
3713: WHERE abatement_id = allow_rec.abatement_id;
3714: END IF;
3715: END LOOP;

Line 3881: UPDATE pn_var_abat_defaults_all

3877: PROCEDURE reset_abatements(p_var_rent_id IN NUMBER
3878: ) IS
3879: BEGIN
3880: pnp_debug_pkg.log('Reset_abatement start(+)');
3881: UPDATE pn_var_abat_defaults_all
3882: SET allowance_applied =0
3883: WHERE var_rent_id = p_var_rent_id;
3884: UPDATE pn_var_rent_inv_all
3885: SET abatement_appl =0