[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;
4897: IF (inv_rec.total_forecasted_rent) <> l_curr_inv_rent_for
4898: THEN
4899:
4900: DELETE
4901: pn_payment_terms_all
4902: WHERE
4903: var_rent_inv_id = l_var_rent_inv_id AND
4904: status <> pn_var_rent_calc_pkg.G_TERM_STATUS_APPROVED AND
4905: var_rent_type = pn_var_rent_calc_pkg.G_INV_ON_FORECASTED;
5049:
5050: ELSIF l_var_rent_inv_id IS NOT NULL AND l_var_rent_inv_id <> -1 THEN
5051:
5052: DELETE
5053: pn_payment_terms_all
5054: WHERE
5055: var_rent_inv_id = l_var_rent_inv_id AND
5056: status <> pn_var_rent_calc_pkg.G_TERM_STATUS_APPROVED AND
5057: var_rent_type = pn_var_rent_calc_pkg.G_INV_ON_VARIANCE; --bug#12702776
8978:
8979: /*Cursor to get all pmt terms for a particular invoice*/
8980: CURSOR get_all_pmt_terms(p_inv_id IN NUMBER) IS
8981: SELECT distinct pterm.payment_term_id payment_term_id
8982: FROM pn_payment_terms_all pterm,
8983: pn_var_rents_all vrent,
8984: pn_var_rent_inv_all vinv
8985: WHERE vrent.lease_id = pterm.lease_id
8986: AND vrent.var_rent_id = vinv.var_rent_id
9342:
9343: /*Cursor to get all pmt terms for a particular invoice*/
9344: CURSOR get_all_pmt_terms(p_inv_id IN NUMBER) IS
9345: SELECT distinct pterm.payment_term_id payment_term_id
9346: FROM pn_payment_terms_all pterm,
9347: pn_var_rents_all vrent,
9348: pn_var_rent_inv_all vinv
9349: WHERE vrent.lease_id = pterm.lease_id
9350: AND vrent.var_rent_id = vinv.var_rent_id
9512: CURSOR get_rent_incr_cur(p_term_id IN NUMBER,p_inv_id IN NUMBER) IS
9513:
9514: SELECT ppt.payment_term_id rent_incr_term_id
9515: FROM pn_index_lease_terms_all pilt,
9516: pn_payment_terms_all ppt ,
9517: pn_index_leases_all pil,
9518: pn_var_rent_inv_all vinv
9519: WHERE pilt.index_lease_id = pil.index_lease_id
9520: AND pil.lease_id = ppt.lease_id
9639: CURSOR get_rent_incr_cur(p_term_id IN NUMBER,p_inv_id IN NUMBER) IS
9640:
9641: SELECT ppt.payment_term_id rent_incr_term_id
9642: FROM pn_index_lease_terms_all pilt,
9643: pn_payment_terms_all ppt ,
9644: pn_index_leases_all pil,
9645: pn_var_rent_inv_all vinv
9646: WHERE pilt.index_lease_id = pil.index_lease_id
9647: AND pil.lease_id = ppt.lease_id
10417: var_rent_id = p_vr_id AND
10418: period_id = p_prd_id AND
10419: invoice_date = p_inv_dt AND
10420: EXISTS (SELECT term.payment_term_id
10421: FROM pn_payment_terms_all term
10422: WHERE term.var_rent_inv_id = inv.var_rent_inv_id
10423: AND status = 'DRAFT'
10424: AND (start_date <> p_inv_sch_date OR
10425: term_template_id <> p_term_template_id));
10427: /* get invoice dates for a period */
10428: /*CURSOR payment_cur (p_inv_sch_date DATE,
10429: p_term_template_id NUMBER) IS
10430: SELECT payment_term_id, var_rent_inv_id
10431: FROM pn_payment_terms_all
10432: WHERE var_rent_inv_id IN (SELECT var_rent_inv_id
10433: FROM pn_var_rent_inv_all
10434: WHERE var_rent_id = p_var_rent_id)
10435: AND status = 'DRAFT'
10463: , l_payment_start_date
10464: , l_term_template_id) LOOP
10465:
10466: DELETE
10467: pn_payment_terms_all
10468: WHERE
10469: var_rent_inv_id = rec.var_rent_inv_id
10470: AND status = 'DRAFT'
10471: AND (start_date <> l_payment_start_date OR