[Home] [Help]
2057: OR round(l_constr_rent, l_precision) <> round(l_constr_prev_rent, l_precision)
2058: THEN
2059:
2060: DELETE
2061: pn_payment_terms_all
2062: WHERE
2063: var_rent_inv_id = l_var_rent_inv_id AND
2064: status <> pn_var_rent_calc_pkg.G_TERM_STATUS_APPROVED AND
2065: var_rent_type = pn_var_rent_calc_pkg.G_INV_ON_ACTUAL;
2464: OR round(l_constr_rent, l_precision) <> round(l_constr_prev_rent, l_precision)
2465: THEN
2466:
2467: DELETE
2468: pn_payment_terms_all
2469: WHERE
2470: var_rent_inv_id = l_var_rent_inv_id AND
2471: status <> pn_var_rent_calc_pkg.G_TERM_STATUS_APPROVED AND
2472: var_rent_type = pn_var_rent_calc_pkg.G_INV_ON_ACTUAL;
2784: IF (l_is_inv_exp = 'N' ) AND
2785: ((l_abated_rent - l_prev_inv_exp)<> NVL(l_actual_invoiced_amount, 0)) THEN
2786:
2787: DELETE
2788: pn_payment_terms_all
2789: WHERE
2790: var_rent_inv_id = inv_rec.var_rent_inv_id AND
2791: status <> pn_var_rent_calc_pkg.G_TERM_STATUS_APPROVED AND
2792: var_rent_type = pn_var_rent_calc_pkg.G_INV_ON_ACTUAL;
4809: IF (inv_rec.total_forecasted_rent) <> l_curr_inv_rent_for
4810: THEN
4811:
4812: DELETE
4813: pn_payment_terms_all
4814: WHERE
4815: var_rent_inv_id = l_var_rent_inv_id AND
4816: status <> pn_var_rent_calc_pkg.G_TERM_STATUS_APPROVED AND
4817: var_rent_type = pn_var_rent_calc_pkg.G_INV_ON_FORECASTED;
4961:
4962: ELSIF l_var_rent_inv_id IS NOT NULL AND l_var_rent_inv_id <> -1 THEN
4963:
4964: DELETE
4965: pn_payment_terms_all
4966: WHERE
4967: var_rent_inv_id = l_var_rent_inv_id AND
4968: status <> pn_var_rent_calc_pkg.G_TERM_STATUS_APPROVED AND
4969: var_rent_type = pn_var_rent_calc_pkg.G_INV_ON_FORECASTED;
8923:
8924: /*Cursor to get all pmt terms for a particular invoice*/
8925: CURSOR get_all_pmt_terms(p_inv_id IN NUMBER) IS
8926: SELECT distinct pterm.payment_term_id payment_term_id
8927: FROM pn_payment_terms_all pterm,
8928: pn_var_rents_all vrent,
8929: pn_var_rent_inv_all vinv
8930: WHERE vrent.lease_id = pterm.lease_id
8931: AND vrent.var_rent_id = vinv.var_rent_id
9287:
9288: /*Cursor to get all pmt terms for a particular invoice*/
9289: CURSOR get_all_pmt_terms(p_inv_id IN NUMBER) IS
9290: SELECT distinct pterm.payment_term_id payment_term_id
9291: FROM pn_payment_terms_all pterm,
9292: pn_var_rents_all vrent,
9293: pn_var_rent_inv_all vinv
9294: WHERE vrent.lease_id = pterm.lease_id
9295: AND vrent.var_rent_id = vinv.var_rent_id
9457: CURSOR get_rent_incr_cur(p_term_id IN NUMBER,p_inv_id IN NUMBER) IS
9458:
9459: SELECT ppt.payment_term_id rent_incr_term_id
9460: FROM pn_index_lease_terms_all pilt,
9461: pn_payment_terms_all ppt ,
9462: pn_index_leases_all pil,
9463: pn_var_rent_inv_all vinv
9464: WHERE pilt.index_lease_id = pil.index_lease_id
9465: AND pil.lease_id = ppt.lease_id
9584: CURSOR get_rent_incr_cur(p_term_id IN NUMBER,p_inv_id IN NUMBER) IS
9585:
9586: SELECT ppt.payment_term_id rent_incr_term_id
9587: FROM pn_index_lease_terms_all pilt,
9588: pn_payment_terms_all ppt ,
9589: pn_index_leases_all pil,
9590: pn_var_rent_inv_all vinv
9591: WHERE pilt.index_lease_id = pil.index_lease_id
9592: AND pil.lease_id = ppt.lease_id
10362: var_rent_id = p_vr_id AND
10363: period_id = p_prd_id AND
10364: invoice_date = p_inv_dt AND
10365: EXISTS (SELECT term.payment_term_id
10366: FROM pn_payment_terms_all term
10367: WHERE term.var_rent_inv_id = inv.var_rent_inv_id
10368: AND status = 'DRAFT'
10369: AND (start_date <> p_inv_sch_date OR
10370: term_template_id <> p_term_template_id));
10372: /* get invoice dates for a period */
10373: /*CURSOR payment_cur (p_inv_sch_date DATE,
10374: p_term_template_id NUMBER) IS
10375: SELECT payment_term_id, var_rent_inv_id
10376: FROM pn_payment_terms_all
10377: WHERE var_rent_inv_id IN (SELECT var_rent_inv_id
10378: FROM pn_var_rent_inv_all
10379: WHERE var_rent_id = p_var_rent_id)
10380: AND status = 'DRAFT'
10408: , l_payment_start_date
10409: , l_term_template_id) LOOP
10410:
10411: DELETE
10412: pn_payment_terms_all
10413: WHERE
10414: var_rent_inv_id = rec.var_rent_inv_id
10415: AND status = 'DRAFT'
10416: AND (start_date <> l_payment_start_date OR