APPS.PN_VAR_TRUEUP_PKG dependencies on PN_VAR_ABAT_DEFAULTS_ALL

Line 804: FROM PN_VAR_ABAT_DEFAULTS_ALL

800: ,allowance_applied allow_applied
801: ,start_date
802: ,end_date
803: ,abatement_id
804: FROM PN_VAR_ABAT_DEFAULTS_ALL
805: WHERE var_rent_id = ip_var_rent_id
806: AND type_code = pn_var_rent_calc_pkg.G_ABAT_TYPE_CODE_ALLO
807: ORDER BY start_date;
808:

Line 1503: FROM PN_VAR_ABAT_DEFAULTS_ALL

1499: CURSOR fixed_abat_c(ip_var_rent_id NUMBER,
1500: ip_inv_start_date DATE,
1501: ip_inv_end_date DATE) IS
1502: SELECT NVL(SUM(amount),0) fixed_abat
1503: FROM PN_VAR_ABAT_DEFAULTS_ALL
1504: WHERE var_rent_id = ip_var_rent_id
1505: AND start_date <= ip_inv_end_date
1506: AND NVL(end_date, ip_inv_end_date) >= ip_inv_start_date
1507: AND type_code = pn_var_rent_calc_pkg.G_ABAT_TYPE_CODE_ABAT;

Line 1908: FROM PN_VAR_ABAT_DEFAULTS_ALL

1904: ip_inv_end_date DATE) IS
1905: SELECT NVL(amount, 0) rolling_allow
1906: ,allowance_applied allow_applied
1907: ,abatement_id
1908: FROM PN_VAR_ABAT_DEFAULTS_ALL
1909: WHERE var_rent_id = ip_var_rent_id
1910: AND start_date <= ip_inv_start_date
1911: AND NVL(end_date, ip_inv_end_date) >= ip_inv_end_date
1912: AND type_code = pn_var_rent_calc_pkg.G_ABAT_TYPE_CODE_ALLO

Line 2045: UPDATE pn_var_abat_defaults_all

2041: l_prev_abt_rent := l_cur_abt_rent;
2042: pnp_debug_pkg.log('l_prev_abt_rent:'||l_prev_abt_rent);
2043: l_allow_applied_inv := l_allow_applied_inv + l_allow_applied;
2044: pnp_debug_pkg.log('l_allow_applied_inv:'||l_allow_applied_inv);
2045: UPDATE pn_var_abat_defaults_all
2046: SET allowance_applied = NVL(allowance_applied,0)+l_allow_applied
2047: WHERE abatement_id = allow_rec.abatement_id;
2048: END IF;
2049: END LOOP;

Line 2102: UPDATE pn_var_abat_defaults_all

2098: x_abated_rent := l_cur_abt_rent;
2099: --Whenever we have true up invoice, we need to reset allowances.
2100: --
2101: FOR i IN l_allow_tu_t.FIRST..l_allow_tu_t.LAST LOOP
2102: UPDATE pn_var_abat_defaults_all
2103: SET allowance_applied = l_allow_tu_t(i).allow_applied
2104: WHERE abatement_id = l_allow_tu_t(i).abatement_id;
2105: END LOOP;
2106:

Line 2280: UPDATE pn_var_abat_defaults_all

2276: PROCEDURE reset_abatements(p_var_rent_id IN NUMBER
2277: ) IS
2278: BEGIN
2279: pnp_debug_pkg.log('Reset_abatement start(+)');
2280: UPDATE pn_var_abat_defaults_all
2281: SET allowance_applied =0
2282: WHERE var_rent_id = p_var_rent_id;
2283: UPDATE pn_var_rent_inv_all
2284: SET abatement_appl =0