eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PN_VAR_RENT_CALC_PKG dependencies on PN_VAR_RENT_INV

Line 1790: pn_var_rent_inv_all

1786: ,actual_invoiced_amount
1787: ,constr_actual_rent
1788: ,rec_abatement_override
1789: FROM
1790: pn_var_rent_inv_all
1791: WHERE
1792: var_rent_id = p_vr_id AND
1793: period_id = p_prd_id AND
1794: invoice_date = p_inv_dt AND

Line 1807: pn_var_rent_inv_all

1803: ,p_inv_dt IN DATE) IS
1804: SELECT
1805: NVL(SUM(actual_invoiced_amount), 0) AS prev_invoiced_amt
1806: FROM
1807: pn_var_rent_inv_all
1808: WHERE
1809: var_rent_id = p_vr_id AND
1810: period_id = p_prd_id AND
1811: invoice_date = p_inv_dt AND

Line 1935: pn_var_rent_inv_pkg.insert_row

1931: p_actual_rent => inv_rec.total_actual_rent);
1932:
1933: pnp_debug_pkg.log('inserting the row ...');
1934: /* first time for this invoice date - create invoice */
1935: pn_var_rent_inv_pkg.insert_row
1936: ( x_rowid => l_row_id,
1937: x_var_rent_inv_id => l_var_rent_inv_id,
1938: x_adjust_num => l_max_adjust_num,
1939: x_invoice_date => inv_rec.invoice_date,

Line 2006: pn_var_rent_inv_pkg.insert_row

2002: OR round(l_constr_rent, l_precision) <> round(l_constr_prev_rent, l_precision)
2003: THEN
2004:
2005: /* create new invoice for difference amt */
2006: pn_var_rent_inv_pkg.insert_row
2007: ( x_rowid => l_row_id,
2008: x_var_rent_inv_id => l_var_rent_inv_id,
2009: x_adjust_num => l_max_adjust_num,
2010: x_invoice_date => inv_rec.invoice_date,

Line 2069: pn_var_rent_inv_all

2065: var_rent_type = pn_var_rent_calc_pkg.G_INV_ON_ACTUAL;
2066:
2067: /* update the invoice */
2068: UPDATE
2069: pn_var_rent_inv_all
2070: SET
2071: act_per_rent = ROUND(inv_rec.total_actual_rent, g_precision)
2072: ,constr_actual_rent = ROUND(l_constr_rent, g_precision)
2073: ,actual_invoiced_amount = ROUND((l_constr_rent - l_prev_inv_exp_rent), g_precision)

Line 2149: pn_var_rent_inv_all

2145: ,actual_invoiced_amount
2146: ,constr_actual_rent
2147: ,rec_abatement_override
2148: FROM
2149: pn_var_rent_inv_all
2150: WHERE
2151: var_rent_id = p_vr_id AND
2152: period_id = p_prd_id AND
2153: invoice_date = p_inv_dt AND

Line 2166: pn_var_rent_inv_all

2162: ,p_inv_dt IN DATE) IS
2163: SELECT
2164: NVL(SUM(actual_invoiced_amount), 0) AS prev_invoiced_amt
2165: FROM
2166: pn_var_rent_inv_all
2167: WHERE
2168: var_rent_id = p_vr_id AND
2169: period_id = p_prd_id AND
2170: invoice_date = p_inv_dt AND

Line 2336: pn_var_rent_inv_pkg.insert_row

2332: p_invoice_date => inv_rec.invoice_date,
2333: p_actual_rent => inv_rec.total_actual_rent);
2334:
2335: /* first time for this invoice date - create invoice */
2336: pn_var_rent_inv_pkg.insert_row
2337: ( x_rowid => l_row_id,
2338: x_var_rent_inv_id => l_var_rent_inv_id,
2339: x_adjust_num => l_max_adjust_num,
2340: x_invoice_date => inv_rec.invoice_date,

Line 2412: pn_var_rent_inv_pkg.insert_row

2408: OR round(l_constr_rent, l_precision) <> round(l_constr_prev_rent, l_precision)
2409: THEN
2410:
2411: /* create new invoice for difference amt */
2412: pn_var_rent_inv_pkg.insert_row
2413: ( x_rowid => l_row_id,
2414: x_var_rent_inv_id => l_var_rent_inv_id,
2415: x_adjust_num => l_max_adjust_num,
2416: x_invoice_date => inv_rec.invoice_date,

Line 2476: pn_var_rent_inv_all

2472: var_rent_type = pn_var_rent_calc_pkg.G_INV_ON_ACTUAL;
2473:
2474: /* update the invoice */
2475: UPDATE
2476: pn_var_rent_inv_all
2477: SET
2478: act_per_rent = ROUND(inv_rec.total_actual_rent, g_precision)
2479: ,constr_actual_rent = ROUND(l_constr_rent, g_precision)
2480: ,actual_invoiced_amount = ROUND((l_constr_rent - l_prev_inv_exp_rent), g_precision)

Line 2671: FROM pn_var_rent_inv_all inv1

2667: p_new_termn_date DATE
2668: ) IS
2669: SELECT var_rent_inv_id, invoice_date, variance_exp_code,
2670: actual_exp_code, constr_actual_rent
2671: FROM pn_var_rent_inv_all inv1
2672: WHERE inv1.var_rent_id = ip_var_rent_id
2673: AND inv1.period_id = ip_period_id
2674: AND inv1.invoice_date <= p_new_termn_date
2675: AND inv1.adjust_num= (

Line 2676: SELECT MAX(adjust_num) from pn_var_rent_inv_all inv2

2672: WHERE inv1.var_rent_id = ip_var_rent_id
2673: AND inv1.period_id = ip_period_id
2674: AND inv1.invoice_date <= p_new_termn_date
2675: AND inv1.adjust_num= (
2676: SELECT MAX(adjust_num) from pn_var_rent_inv_all inv2
2677: where inv1.var_rent_id = inv2.var_rent_id
2678: AND inv1.invoice_date = inv2.invoice_date)
2679: ORDER BY invoice_date;
2680:

Line 2685: FROM pn_var_rent_inv_all

2681: -- Get all the details of a specific invoice.
2682: CURSOR inv_all_c(ip_vr_inv_id NUMBER
2683: ) IS
2684: SELECT *
2685: FROM pn_var_rent_inv_all
2686: WHERE var_rent_inv_id = ip_vr_inv_id;
2687:
2688:
2689: /* get prev invoiced amount. */

Line 2696: pn_var_rent_inv_all

2692: ,p_inv_dt IN DATE) IS
2693: SELECT
2694: NVL(SUM(actual_invoiced_amount), 0) AS prev_invoiced_amt
2695: FROM
2696: pn_var_rent_inv_all
2697: WHERE
2698: var_rent_id = p_vr_id AND
2699: period_id = p_prd_id AND
2700: invoice_date = p_inv_dt AND

Line 2716: pn_var_rent_inv_all inv

2712: G_INV_ON_FORECASTED, variance_exp_code) AS
2713: exp_code,
2714: inv.actual_invoiced_amount
2715: FROM pn_var_rents_all vr,
2716: pn_var_rent_inv_all inv
2717: WHERE vr.var_rent_id = inv.var_rent_id
2718: AND inv.var_rent_inv_id = ip_var_rent_inv_id;
2719:
2720: l_is_inv_exp VARCHAR(30);

Line 2797: pn_var_rent_inv_all

2793:
2794: -- Update the current invoice
2795: pnp_debug_pkg.log('Abatements - updating');
2796: UPDATE
2797: pn_var_rent_inv_all
2798: SET
2799: actual_invoiced_amount = ROUND((l_abated_rent - l_prev_inv_exp), g_precision)
2800: ,actual_term_status = 'N'
2801: ,last_update_date = SYSDATE

Line 2817: pn_var_rent_inv_pkg.insert_row

2813: pnp_debug_pkg.log('l_abated_rent:'||l_abated_rent);
2814: pnp_debug_pkg.log('Abatements - inserting');
2815: l_row_id := NULL;
2816: l_var_rent_inv_id := NULL;
2817: pn_var_rent_inv_pkg.insert_row
2818: ( x_rowid => l_row_id,
2819: x_var_rent_inv_id => l_var_rent_inv_id,
2820: x_adjust_num => inv_all_rec.adjust_num+1,
2821: x_invoice_date => inv_all_rec.invoice_date,

Line 2899: FROM pn_var_rent_inv_all inv1

2895: ,actual_invoiced_amount
2896: ,negative_rent
2897: ,invoice_date
2898: ,var_rent_inv_id
2899: FROM pn_var_rent_inv_all inv1
2900: WHERE inv1.var_rent_id = ip_var_rent_id
2901: AND inv1.period_id = ip_period_id
2902: AND var_rent_inv_id = ip_inv_id
2903: AND inv1.adjust_num= (

Line 2904: SELECT MAX(adjust_num) from pn_var_rent_inv_all inv2

2900: WHERE inv1.var_rent_id = ip_var_rent_id
2901: AND inv1.period_id = ip_period_id
2902: AND var_rent_inv_id = ip_inv_id
2903: AND inv1.adjust_num= (
2904: SELECT MAX(adjust_num) from pn_var_rent_inv_all inv2
2905: where inv1.var_rent_id = inv2.var_rent_id
2906: AND inv1.invoice_date = inv2.invoice_date);
2907:
2908: CURSOR csr_last_inv(p_var_rent_id NUMBER)

Line 2917: FROM pn_var_rent_inv_all inv

2913:
2914: CURSOR csr_neg_avail (ip_var_rent_id NUMBER,
2915: ip_invoice_date DATE) IS
2916: SELECT ABS(NVL(SUM(constr_actual_rent),0)) negative_available
2917: FROM pn_var_rent_inv_all inv
2918: WHERE inv.var_rent_id = ip_var_rent_id
2919: AND inv.invoice_date < ip_invoice_date
2920: AND inv.adjust_num = (select MAX(inv1.adjust_num)
2921: from pn_var_rent_inv_all inv1

Line 2921: from pn_var_rent_inv_all inv1

2917: FROM pn_var_rent_inv_all inv
2918: WHERE inv.var_rent_id = ip_var_rent_id
2919: AND inv.invoice_date < ip_invoice_date
2920: AND inv.adjust_num = (select MAX(inv1.adjust_num)
2921: from pn_var_rent_inv_all inv1
2922: where inv1.var_rent_id = inv.var_rent_id
2923: AND inv1.invoice_date = inv.invoice_date)
2924: AND inv.constr_actual_rent < 0;
2925:

Line 2929: FROM pn_var_rent_inv_all inv

2925:
2926: CURSOR csr_neg_appl (ip_var_rent_id NUMBER,
2927: ip_invoice_date DATE) IS
2928: SELECT NVL(SUM(negative_rent),0) negative_applied
2929: FROM pn_var_rent_inv_all inv
2930: WHERE inv.var_rent_id = ip_var_rent_id
2931: AND inv.invoice_date < ip_invoice_date
2932: AND inv.adjust_num = (select MAX(inv1.adjust_num)
2933: from pn_var_rent_inv_all inv1

Line 2933: from pn_var_rent_inv_all inv1

2929: FROM pn_var_rent_inv_all inv
2930: WHERE inv.var_rent_id = ip_var_rent_id
2931: AND inv.invoice_date < ip_invoice_date
2932: AND inv.adjust_num = (select MAX(inv1.adjust_num)
2933: from pn_var_rent_inv_all inv1
2934: where inv1.var_rent_id = inv.var_rent_id
2935: AND inv1.invoice_date = inv.invoice_date);
2936: CURSOR csr_get_abt(ip_var_rent_id NUMBER)
2937: IS

Line 2946: FROM pn_var_rent_inv_all

2942: CURSOR temp_c(ip_var_rent_inv_id NUMBER
2943: ) IS
2944: SELECT abated_rent,
2945: negative_rent
2946: FROM pn_var_rent_inv_all
2947: WHERE var_rent_inv_id = ip_var_rent_inv_id;
2948:
2949:
2950: l_negative_rent pn_var_rent_inv.negative_rent%TYPE := 0;

Line 2950: l_negative_rent pn_var_rent_inv.negative_rent%TYPE := 0;

2946: FROM pn_var_rent_inv_all
2947: WHERE var_rent_inv_id = ip_var_rent_inv_id;
2948:
2949:
2950: l_negative_rent pn_var_rent_inv.negative_rent%TYPE := 0;
2951: l_negative_available NUMBER := 0;
2952: l_negative_applied NUMBER := 0;
2953: l_negative_remaining NUMBER;
2954: l_abated_rent NUMBER;

Line 3015: UPDATE pn_var_rent_inv_all

3011: pnp_debug_pkg.log('l_abated_rent:'||l_abated_rent);
3012: pnp_debug_pkg.log('l_negative_rent:'||l_negative_rent);
3013: pnp_debug_pkg.log('inv_rec.var_rent_inv_id:'||inv_rec.var_rent_inv_id);
3014:
3015: UPDATE pn_var_rent_inv_all
3016: SET abated_rent = l_abated_rent,
3017: negative_rent = L_negative_rent
3018: WHERE var_rent_inv_id = inv_rec.var_rent_inv_id;
3019: END LOOP;

Line 3057: FROM pn_var_rent_inv_all inv1

3053: ,actual_invoiced_amount
3054: ,negative_rent
3055: ,invoice_date
3056: ,var_rent_inv_id
3057: FROM pn_var_rent_inv_all inv1
3058: WHERE inv1.var_rent_id = ip_var_rent_id
3059: AND inv1.period_id = ip_period_id
3060: AND var_rent_inv_id = ip_inv_id
3061: AND inv1.adjust_num= (

Line 3062: SELECT MAX(adjust_num) from pn_var_rent_inv_all inv2

3058: WHERE inv1.var_rent_id = ip_var_rent_id
3059: AND inv1.period_id = ip_period_id
3060: AND var_rent_inv_id = ip_inv_id
3061: AND inv1.adjust_num= (
3062: SELECT MAX(adjust_num) from pn_var_rent_inv_all inv2
3063: where inv1.var_rent_id = inv2.var_rent_id
3064: AND inv1.invoice_date = inv2.invoice_date);
3065:
3066: CURSOR csr_last_inv(p_var_rent_id NUMBER)

Line 3080: FROM pn_var_rent_inv_all inv

3076:
3077: CURSOR csr_neg_avail (ip_var_rent_id NUMBER,
3078: ip_invoice_date DATE) IS
3079: SELECT ABS(NVL(SUM(def_neg_rent),0)) negative_available
3080: FROM pn_var_rent_inv_all inv
3081: WHERE inv.var_rent_id = ip_var_rent_id
3082: AND inv.invoice_date < ip_invoice_date
3083: AND inv.adjust_num = (select MAX(inv1.adjust_num)
3084: from pn_var_rent_inv_all inv1

Line 3084: from pn_var_rent_inv_all inv1

3080: FROM pn_var_rent_inv_all inv
3081: WHERE inv.var_rent_id = ip_var_rent_id
3082: AND inv.invoice_date < ip_invoice_date
3083: AND inv.adjust_num = (select MAX(inv1.adjust_num)
3084: from pn_var_rent_inv_all inv1
3085: where inv1.var_rent_id = inv.var_rent_id
3086: AND inv1.invoice_date = inv.invoice_date);
3087:
3088: CURSOR csr_neg_appl (ip_var_rent_id NUMBER,

Line 3091: FROM pn_var_rent_inv_all inv

3087:
3088: CURSOR csr_neg_appl (ip_var_rent_id NUMBER,
3089: ip_invoice_date DATE) IS
3090: SELECT NVL(SUM(negative_rent),0) negative_applied
3091: FROM pn_var_rent_inv_all inv
3092: WHERE inv.var_rent_id = ip_var_rent_id
3093: AND inv.invoice_date < ip_invoice_date
3094: AND inv.adjust_num = (select MAX(inv1.adjust_num)
3095: from pn_var_rent_inv_all inv1

Line 3095: from pn_var_rent_inv_all inv1

3091: FROM pn_var_rent_inv_all inv
3092: WHERE inv.var_rent_id = ip_var_rent_id
3093: AND inv.invoice_date < ip_invoice_date
3094: AND inv.adjust_num = (select MAX(inv1.adjust_num)
3095: from pn_var_rent_inv_all inv1
3096: where inv1.var_rent_id = inv.var_rent_id
3097: AND inv1.invoice_date = inv.invoice_date);
3098: CURSOR csr_get_abt(ip_var_rent_id NUMBER)
3099: IS

Line 3105: l_negative_rent pn_var_rent_inv.negative_rent%TYPE := 0;

3101: FROM pn_var_rents_all
3102: WHERE var_rent_id = ip_var_rent_id;
3103:
3104:
3105: l_negative_rent pn_var_rent_inv.negative_rent%TYPE := 0;
3106: l_negative_available NUMBER := 0;
3107: l_negative_applied NUMBER := 0;
3108: l_negative_remaining NUMBER;
3109: l_abated_rent NUMBER;

Line 3167: UPDATE pn_var_rent_inv_all

3163: pnp_debug_pkg.log('l_abated_rent:'||l_abated_rent);
3164: pnp_debug_pkg.log('l_negative_rent:'||l_negative_rent);
3165: pnp_debug_pkg.log('inv_rec.var_rent_inv_id:'||inv_rec.var_rent_inv_id);
3166:
3167: UPDATE pn_var_rent_inv_all
3168: SET negative_rent = ROUND(l_negative_rent, g_precision)
3169: WHERE var_rent_inv_id = inv_rec.var_rent_inv_id;
3170: x_abated_rent := l_abated_rent;
3171: END LOOP;

Line 3204: FROM pn_var_rent_inv_all inv1

3200: CURSOR invoices_c(ip_var_rent_id NUMBER, ip_period_id NUMBER, ip_inv_id NUMBER
3201: ) IS
3202: SELECT invoice_date
3203: ,var_rent_inv_id
3204: FROM pn_var_rent_inv_all inv1
3205: WHERE inv1.var_rent_id = ip_var_rent_id
3206: AND inv1.period_id = ip_period_id
3207: AND var_rent_inv_id = ip_inv_id
3208: AND inv1.adjust_num= (

Line 3209: SELECT MAX(adjust_num) from pn_var_rent_inv_all inv2

3205: WHERE inv1.var_rent_id = ip_var_rent_id
3206: AND inv1.period_id = ip_period_id
3207: AND var_rent_inv_id = ip_inv_id
3208: AND inv1.adjust_num= (
3209: SELECT MAX(adjust_num) from pn_var_rent_inv_all inv2
3210: where inv1.var_rent_id = inv2.var_rent_id
3211: AND inv1.invoice_date = inv2.invoice_date);
3212:
3213: CURSOR csr_last_inv(p_var_rent_id NUMBER)

Line 3231: l_negative_rent pn_var_rent_inv.negative_rent%TYPE := 0;

3227: FROM pn_var_rents_all
3228: WHERE var_rent_id = ip_var_rent_id;
3229:
3230: l_neg_rent_def NUMBER;
3231: l_negative_rent pn_var_rent_inv.negative_rent%TYPE := 0;
3232: l_negative_available NUMBER := 0;
3233: l_negative_applied NUMBER := 0;
3234: l_negative_remaining NUMBER;
3235: l_abated_rent NUMBER;

Line 3268: UPDATE pn_var_rent_inv_all

3264: l_abated_rent := x_abated_rent;
3265: END IF;
3266: pnp_debug_pkg.log('l_abated_rent:'||l_abated_rent);
3267: pnp_debug_pkg.log('l_neg_rent_def*:'||l_neg_rent_def);
3268: UPDATE pn_var_rent_inv_all
3269: SET def_neg_rent = ROUND(l_neg_rent_def, g_precision)
3270: WHERE var_rent_inv_id = inv_rec.var_rent_inv_id;
3271: x_abated_rent := l_abated_rent;
3272: END LOOP;

Line 3311: FROM pn_var_rent_inv_all inv1

3307: ,invoice_date
3308: ,NVL(rec_abatement,0) rec_abatement
3309: ,rec_abatement_override
3310: ,var_rent_inv_id
3311: FROM pn_var_rent_inv_all inv1
3312: WHERE inv1.var_rent_id = ip_var_rent_id
3313: AND inv1.period_id = ip_period_id
3314: AND inv1.var_rent_inv_id = ip_inv_id
3315: AND inv1.adjust_num= (

Line 3316: SELECT MAX(adjust_num) from pn_var_rent_inv_all inv2

3312: WHERE inv1.var_rent_id = ip_var_rent_id
3313: AND inv1.period_id = ip_period_id
3314: AND inv1.var_rent_inv_id = ip_inv_id
3315: AND inv1.adjust_num= (
3316: SELECT MAX(adjust_num) from pn_var_rent_inv_all inv2
3317: where inv1.var_rent_id = inv2.var_rent_id
3318: AND inv1.invoice_date = inv2.invoice_date);
3319: -- Get the details of fixed abatements
3320: CURSOR fixed_abat_c(ip_var_rent_id NUMBER,

Line 3346: FROM pn_var_rent_inv_all inv, pn_var_periods_all per

3342: -- Get the details of actual start and end date for FY/LY/FLY
3343: CURSOR invoice_dates_fyly_c(ip_var_rent_inv_id NUMBER
3344: ) IS
3345: SELECT per.start_date, per.end_date
3346: FROM pn_var_rent_inv_all inv, pn_var_periods_all per
3347: WHERE per.period_id = inv.period_id
3348: AND inv.var_rent_inv_id = ip_var_rent_inv_id;
3349:
3350: -- Get the id of invoice created for first year.

Line 3355: FROM pn_var_rent_inv_all inv, pn_var_periods_all per

3351: -- This has meaning only if proration is FY/FLY
3352: CURSOR get_fy_inv_c(ip_var_rent_id NUMBER
3353: ) IS
3354: SELECT inv.var_rent_inv_id
3355: FROM pn_var_rent_inv_all inv, pn_var_periods_all per
3356: WHERE per.period_id = inv.period_id
3357: AND inv.var_rent_id = ip_var_rent_id
3358: AND per.start_date = (SELECT MIN(start_date) from pn_var_periods_all
3359: WHERE var_rent_id = ip_var_rent_id);

Line 3365: FROM pn_var_rent_inv_all inv, pn_var_periods_all per

3361: -- This has meaning only if proration is LY/FLY
3362: CURSOR get_ly_inv_c(ip_var_rent_id NUMBER
3363: ) IS
3364: SELECT inv.var_rent_inv_id
3365: FROM pn_var_rent_inv_all inv, pn_var_periods_all per
3366: WHERE per.period_id = inv.period_id
3367: AND inv.var_rent_id = ip_var_rent_id
3368: AND per.start_date = (SELECT MAX(start_date) from pn_var_periods_all
3369: WHERE var_rent_id = ip_var_rent_id)

Line 3370: AND inv.invoice_date = (SELECT MAX(invoice_date) FROM pn_var_rent_inv_all

3366: WHERE per.period_id = inv.period_id
3367: AND inv.var_rent_id = ip_var_rent_id
3368: AND per.start_date = (SELECT MAX(start_date) from pn_var_periods_all
3369: WHERE var_rent_id = ip_var_rent_id)
3370: AND inv.invoice_date = (SELECT MAX(invoice_date) FROM pn_var_rent_inv_all
3371: WHERE var_rent_id = ip_var_rent_id);
3372:
3373: -- Get the details of negative_rent
3374: CURSOR neg_rent_c(ip_var_rent_id NUMBER

Line 3390: FROM pn_var_rent_inv_all inv, pn_var_periods_all per, pn_var_rents_all vr, pn_var_rent_dates_all vrd

3386: -- Get the number of inv which should exist for a period
3387: CURSOR num_inv_c(ip_var_rent_inv_id NUMBER
3388: ) IS
3389: SELECT ceil(months_between(per.end_date, per.start_date)/decode(vrd.invg_freq_code,'YR', 12, 'SA', 6, 'QTR', 3, 'MON', 1, 1)) num_inv
3390: FROM pn_var_rent_inv_all inv, pn_var_periods_all per, pn_var_rents_all vr, pn_var_rent_dates_all vrd
3391: WHERE per.period_id = inv.period_id
3392: AND inv.var_rent_inv_id = ip_var_rent_inv_id
3393: AND per.var_rent_id = vr.var_rent_id
3394: AND vrd.var_rent_id = vr.var_rent_id;

Line 3404: pn_var_rent_inv_all inv

3400: inv.var_rent_inv_id,
3401: inv.period_id
3402: FROM pn_var_rents_all vr,
3403: pn_var_periods_all per,
3404: pn_var_rent_inv_all inv
3405: WHERE per.var_rent_id = vr.var_rent_id
3406: AND inv.period_id = per.period_id
3407: AND per.start_date = (select max(start_date) from pn_var_periods_all per1
3408: where per1.var_rent_id = vr.var_rent_id)

Line 3409: AND inv.invoice_date = (select max(invoice_date) from pn_var_rent_inv_all inv1

3405: WHERE per.var_rent_id = vr.var_rent_id
3406: AND inv.period_id = per.period_id
3407: AND per.start_date = (select max(start_date) from pn_var_periods_all per1
3408: where per1.var_rent_id = vr.var_rent_id)
3409: AND inv.invoice_date = (select max(invoice_date) from pn_var_rent_inv_all inv1
3410: where inv1.period_id = per.period_id)
3411: AND vr.var_rent_id = ip_vr_id;
3412:
3413: l_fixed_abat NUMBER := 0;

Line 3534: UPDATE pn_var_rent_inv_all

3530: pnp_debug_pkg.log('l_abated_rent:'||l_abated_rent);
3531: x_abated_rent := l_abated_rent;
3532: l_total_abat := l_unabated_rent - l_abated_rent;
3533: pnp_debug_pkg.log('total_abat_applied:'||l_total_abat);
3534: UPDATE pn_var_rent_inv_all
3535: SET rec_abatement = ROUND(l_total_abat, g_precision)
3536: WHERE var_rent_inv_id = inv_rec.var_rent_inv_id;
3537:
3538: END LOOP;

Line 3575: FROM pn_var_rent_inv_all inv1

3571: ) IS
3572: SELECT inv1.abatement_appl
3573: ,inv1.invoice_date
3574: ,inv1.var_rent_inv_id
3575: FROM pn_var_rent_inv_all inv1
3576: WHERE var_rent_id = ip_var_rent_id
3577: AND period_id = ip_period_id
3578: AND var_rent_inv_id = ip_inv_id
3579: AND inv1.adjust_num= (

Line 3580: SELECT MAX(adjust_num) from pn_var_rent_inv_all inv2

3576: WHERE var_rent_id = ip_var_rent_id
3577: AND period_id = ip_period_id
3578: AND var_rent_inv_id = ip_inv_id
3579: AND inv1.adjust_num= (
3580: SELECT MAX(adjust_num) from pn_var_rent_inv_all inv2
3581: where inv1.var_rent_id = inv2.var_rent_id
3582: AND inv1.invoice_date = inv2.invoice_date);
3583: -- Get the details of rolling allowance
3584: CURSOR rolling_allow_c(ip_var_rent_id NUMBER,

Line 3608: FROM pn_var_rent_inv_all inv, pn_var_periods_all per

3604: -- Get the details of actual start and end date for FY/LY/FLY
3605: CURSOR invoice_dates_fyly_c(ip_var_rent_inv_id NUMBER
3606: ) IS
3607: SELECT per.start_date, per.end_date
3608: FROM pn_var_rent_inv_all inv, pn_var_periods_all per
3609: WHERE per.period_id = inv.period_id
3610: AND inv.var_rent_inv_id = ip_var_rent_inv_id;
3611: -- Get the id of invoice created for first year.
3612: -- This has meaning only if proration is FY/FLY

Line 3616: FROM pn_var_rent_inv_all inv, pn_var_periods_all per

3612: -- This has meaning only if proration is FY/FLY
3613: CURSOR get_fy_inv_c(ip_var_rent_id NUMBER
3614: ) IS
3615: SELECT inv.var_rent_inv_id
3616: FROM pn_var_rent_inv_all inv, pn_var_periods_all per
3617: WHERE per.period_id = inv.period_id
3618: AND inv.var_rent_id = ip_var_rent_id
3619: AND per.start_date = (SELECT MIN(start_date) from pn_var_periods_all
3620: WHERE var_rent_id = ip_var_rent_id);

Line 3626: FROM pn_var_rent_inv_all inv, pn_var_periods_all per

3622: -- This has meaning only if proration is LY/FLY
3623: CURSOR get_ly_inv_c(ip_var_rent_id NUMBER
3624: ) IS
3625: SELECT inv.var_rent_inv_id
3626: FROM pn_var_rent_inv_all inv, pn_var_periods_all per
3627: WHERE per.period_id = inv.period_id
3628: AND inv.var_rent_id = ip_var_rent_id
3629: AND per.start_date = (SELECT MAX(start_date) from pn_var_periods_all
3630: WHERE var_rent_id = ip_var_rent_id)

Line 3631: AND inv.invoice_date = (SELECT MAX(invoice_date) from pn_var_rent_inv_all

3627: WHERE per.period_id = inv.period_id
3628: AND inv.var_rent_id = ip_var_rent_id
3629: AND per.start_date = (SELECT MAX(start_date) from pn_var_periods_all
3630: WHERE var_rent_id = ip_var_rent_id)
3631: AND inv.invoice_date = (SELECT MAX(invoice_date) from pn_var_rent_inv_all
3632: WHERE var_rent_id = ip_var_rent_id);
3633:
3634: -- Get the proration type
3635: CURSOR proration_type_c(ip_var_rent_id NUMBER

Line 3717: UPDATE pn_var_rent_inv_all

3713: WHERE abatement_id = allow_rec.abatement_id;
3714: END IF;
3715: END LOOP;
3716: pnp_debug_pkg.log('l_cur_abt_rent:'||l_cur_abt_rent);
3717: UPDATE pn_var_rent_inv_all
3718: SET abatement_appl = ROUND(l_allow_applied_inv, g_precision)
3719: WHERE var_rent_inv_id = inv_rec.var_rent_inv_id;
3720: x_abated_rent := l_cur_abt_rent;
3721: pnp_debug_pkg.log('inv_rec.var_rent_inv_id:'||inv_rec.var_rent_inv_id);

Line 3733: -- pn_var_rent_inv_all.rec_abatement.

3729:
3730: --------------------------------------------------------------------------------
3731: -- NAME : populate_abat
3732: -- DESCRIPTION : Populates the recurring abatements to abte in
3733: -- pn_var_rent_inv_all.rec_abatement.
3734: -- PURPOSE :
3735: -- INVOKED FROM : apply_abatements()
3736: -- ARGUMENTS : p_var_rent_id: Vr to apply abatements for.
3737: -- p_period_id: Period to calculate for.

Line 3754: FROM pn_var_rent_inv_all inv1

3750: ip_inv_id NUMBER
3751: ) IS
3752: SELECT invoice_date
3753: ,var_rent_inv_id
3754: FROM pn_var_rent_inv_all inv1
3755: WHERE inv1.var_rent_id = ip_var_rent_id
3756: AND inv1.period_id = ip_period_id
3757: AND var_rent_inv_id = ip_inv_id
3758: AND inv1.adjust_num= (

Line 3759: SELECT MAX(adjust_num) from pn_var_rent_inv_all inv2

3755: WHERE inv1.var_rent_id = ip_var_rent_id
3756: AND inv1.period_id = ip_period_id
3757: AND var_rent_inv_id = ip_inv_id
3758: AND inv1.adjust_num= (
3759: SELECT MAX(adjust_num) from pn_var_rent_inv_all inv2
3760: where inv1.var_rent_id = inv2.var_rent_id
3761: AND inv1.invoice_date = inv2.invoice_date);
3762: -- Get the details of actual start and end date for FY/LY/FLY
3763: CURSOR invoice_dates_fyly_c(ip_var_rent_inv_id NUMBER

Line 3766: FROM pn_var_rent_inv_all inv, pn_var_periods_all per

3762: -- Get the details of actual start and end date for FY/LY/FLY
3763: CURSOR invoice_dates_fyly_c(ip_var_rent_inv_id NUMBER
3764: ) IS
3765: SELECT per.start_date, per.end_date
3766: FROM pn_var_rent_inv_all inv, pn_var_periods_all per
3767: WHERE per.period_id = inv.period_id
3768: AND inv.var_rent_inv_id = ip_var_rent_inv_id;
3769: -- Get the id of invoice created for first year.
3770: -- This has meaning only if proration is FY/FLY

Line 3774: FROM pn_var_rent_inv_all inv, pn_var_periods_all per

3770: -- This has meaning only if proration is FY/FLY
3771: CURSOR get_fy_inv_c(ip_var_rent_id NUMBER
3772: ) IS
3773: SELECT inv.var_rent_inv_id
3774: FROM pn_var_rent_inv_all inv, pn_var_periods_all per
3775: WHERE per.period_id = inv.period_id
3776: AND inv.var_rent_id = ip_var_rent_id
3777: AND per.start_date = (SELECT MIN(start_date) from pn_var_periods_all
3778: WHERE var_rent_id = ip_var_rent_id);

Line 3784: FROM pn_var_rent_inv_all inv, pn_var_periods_all per

3780: -- This has meaning only if proration is LY/FLY
3781: CURSOR get_ly_inv_c(ip_var_rent_id NUMBER
3782: ) IS
3783: SELECT inv.var_rent_inv_id
3784: FROM pn_var_rent_inv_all inv, pn_var_periods_all per
3785: WHERE per.period_id = inv.period_id
3786: AND inv.var_rent_id = ip_var_rent_id
3787: AND per.start_date = (SELECT MAX(start_date) from pn_var_periods_all
3788: WHERE var_rent_id = ip_var_rent_id);

Line 3849: UPDATE pn_var_rent_inv_all

3845: inv_rec.var_rent_inv_id
3846: ,l_min_grp_date
3847: ,l_max_grp_date);
3848: g_precision := nvl(pn_var_rent_calc_pkg.get_currency_precision(g_org_id),4);
3849: UPDATE pn_var_rent_inv_all
3850: SET rec_abatement = ROUND(l_rec_abatement, g_precision)
3851: WHERE var_rent_inv_id = inv_rec.var_rent_inv_id;
3852:
3853: END LOOP;

Line 3884: UPDATE pn_var_rent_inv_all

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
3886: WHERE var_rent_id = p_var_rent_id;
3887: pnp_debug_pkg.log('Reset_abatement end(-)');
3888:

Line 4605: pn_var_rent_inv_all

4601: ,actual_invoiced_amount
4602: ,constr_actual_rent
4603: ,rec_abatement_override
4604: FROM
4605: pn_var_rent_inv_all
4606: WHERE
4607: var_rent_id = p_vr_id AND
4608: period_id = p_prd_id AND
4609: invoice_date = p_inv_dt

Line 4623: pn_var_rent_inv_all

4619: ,p_inv_dt IN DATE) IS
4620: SELECT
4621: NVL(SUM(actual_invoiced_amount), 0) AS prev_invoiced_amt
4622: FROM
4623: pn_var_rent_inv_all
4624: WHERE
4625: var_rent_id = p_vr_id AND
4626: period_id = p_prd_id AND
4627: invoice_date = p_inv_dt AND

Line 4749: pn_var_rent_inv_pkg.insert_row

4745: inv_rec.invoice_date
4746: ) LOOP
4747:
4748: pnp_debug_pkg.log('inv_rec.total_forecasted_rent'||inv_rec.total_forecasted_rent);
4749: pn_var_rent_inv_pkg.insert_row
4750: ( x_rowid => l_row_id,
4751: x_var_rent_inv_id => l_var_rent_inv_id,
4752: x_adjust_num => 0,
4753: x_invoice_date => inv_rec.invoice_date,

Line 4822: pn_var_rent_inv_all

4818:
4819: /* update the invoice */
4820: /*Since forcasted rents are not yet exported, we can update them.*/
4821: UPDATE
4822: pn_var_rent_inv_all
4823: SET
4824: for_per_rent = ROUND(inv_rec.total_forecasted_rent, g_precision)
4825: ,forecasted_term_status = 'N'
4826: ,credit_flag = 'N' -- bug # 5937807

Line 4914: pn_var_rent_inv_pkg.insert_row

4910: THEN
4911:
4912: /* create new invoice for difference amt */
4913: /* Forecasted rent is not updated in invoices. So always set it to prev invoiced forcasted ammount*/
4914: pn_var_rent_inv_pkg.insert_row
4915: ( x_rowid => l_row_id,
4916: x_var_rent_inv_id => l_var_rent_inv_id,
4917: x_adjust_num => l_max_adjust_num,
4918: x_invoice_date => inv_rec.invoice_date,

Line 4973: pn_var_rent_inv_all

4969: var_rent_type = pn_var_rent_calc_pkg.G_INV_ON_FORECASTED;
4970:
4971: /* update the invoice */
4972: UPDATE
4973: pn_var_rent_inv_all
4974: SET
4975: act_per_rent = ROUND(inv_rec.total_actual_rent, g_precision)
4976: ,constr_actual_rent = ROUND(l_constr_rent, g_precision)
4977: ,actual_invoiced_amount = ROUND((l_constr_rent - l_prev_inv_exp_rent), g_precision)

Line 6635: FROM pn_var_rent_inv_all

6631: RETURN NUMBER IS
6632:
6633: CURSOR inv_cur IS
6634: SELECT true_up_amt, actual_invoiced_amount, act_per_rent, for_per_rent, adjust_num
6635: FROM pn_var_rent_inv_all
6636: WHERE var_rent_inv_id = p_var_rent_inv_id;
6637:
6638: CURSOR inv_actual IS
6639: SELECT SUM(actual_invoiced_amount) actual

Line 6640: FROM pn_var_rent_inv_all

6636: WHERE var_rent_inv_id = p_var_rent_inv_id;
6637:
6638: CURSOR inv_actual IS
6639: SELECT SUM(actual_invoiced_amount) actual
6640: FROM pn_var_rent_inv_all
6641: WHERE invoice_date = p_invoice_date
6642: AND period_id = p_period_id
6643: AND var_rent_inv_id <= p_var_rent_inv_id;
6644:

Line 6647: FROM pn_var_rent_inv_all rent_inv

6643: AND var_rent_inv_id <= p_var_rent_inv_id;
6644:
6645: CURSOR prev_inv_amt_cur(p_adjust_num NUMBER) IS
6646: SELECT sum(actual_invoiced_amount) prev_amt
6647: FROM pn_var_rent_inv_all rent_inv
6648: WHERE var_rent_inv_id < p_var_rent_inv_id
6649: AND (true_up_amt IS NULL
6650: OR (true_up_amt IS NOT NULL))
6651: AND period_id = p_period_id;

Line 8796: NOT EXISTS (SELECT NULL from pn_var_rent_inv_all vinv

8792: AND vol.period_id = gd.period_id
8793: AND vol.invoicing_date= gd.invoice_date
8794: )
8795: AND
8796: NOT EXISTS (SELECT NULL from pn_var_rent_inv_all vinv
8797: WHERE vinv.invoice_date=gd.invoice_date
8798: AND vinv.period_id=gd.period_id
8799: )
8800: AND gd.var_rent_id=p_vrent_id

Line 8844: AND NOT EXISTS (select NULL from pn_var_rent_inv_all vinv

8840: where vol_hist_status_code = p_status
8841: and vol.period_id = vp.period_id
8842: and var_rent_id=p_vrent_id
8843: )
8844: AND NOT EXISTS (select NULL from pn_var_rent_inv_all vinv
8845: where vinv.var_rent_id = p_vrent_id
8846: and vinv.period_id = vp.period_id
8847: )
8848: );

Line 8863: AND NOT EXISTS (select NULL from pn_var_rent_inv_all vinv

8859: where vol_hist_status_code = p_status
8860: and vol.period_id = gd.period_id
8861: and vol.invoicing_date= gd.invoice_date
8862: )
8863: AND NOT EXISTS (select NULL from pn_var_rent_inv_all vinv
8864: where vinv.invoice_date=gd.invoice_date
8865: and vinv.period_id=gd.period_id
8866: )
8867: AND gd.var_rent_id=p_vrent_id

Line 8929: pn_var_rent_inv_all vinv

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
8932: AND pterm.start_date <=
8933: (SELECT MAX(gd.grp_end_date)

Line 8965: FROM pn_var_rent_inv_all

8961:
8962: -- Get the invoice id for a given period_id and invoice_date
8963: CURSOR check_inv_exists(p_var_rent_id IN NUMBER,p_inv_dt IN DATE,p_prd_id IN NUMBER) IS
8964: SELECT var_rent_inv_id inv_id
8965: FROM pn_var_rent_inv_all
8966: WHERE invoice_date= p_inv_dt
8967: AND var_rent_id = p_var_rent_id
8968: AND period_id = p_prd_id
8969: AND adjust_num = 0;

Line 8974: FROM pn_var_rent_inv_all

8970:
8971: -- Get the details of invoice for 1st partial period
8972: CURSOR get_fst_inv_id(p_var_rent_id IN NUMBER) IS
8973: SELECT var_rent_inv_id
8974: FROM pn_var_rent_inv_all
8975: WHERE var_rent_id=p_var_rent_id
8976: AND period_id IN (SELECT period_id
8977: FROM pn_var_periods_all
8978: WHERE period_num=1

Line 9114: FROM pn_var_rent_inv_all

9110: ,p_inv_dt IN DATE
9111: )
9112: IS
9113: SELECT var_rent_inv_id
9114: FROM pn_var_rent_inv_all
9115: WHERE var_rent_id=p_var_rent_id
9116: AND period_id=p_prd_id
9117: AND invoice_date=p_inv_dt
9118: AND adjust_num=0;

Line 9126: FROM pn_var_rent_inv_all

9122: ,p_prd_id IN NUMBER
9123: ,p_inv_id IN NUMBER)
9124: IS
9125: SELECT var_rent_inv_id
9126: FROM pn_var_rent_inv_all
9127: WHERE var_rent_id=p_var_rent_id
9128: AND period_id=p_prd_id
9129: AND var_rent_inv_id <> p_inv_id
9130: AND adjust_num=0;

Line 9293: pn_var_rent_inv_all vinv

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
9296: AND pterm.start_date <=
9297: (SELECT MAX(gd.grp_end_date)

Line 9328: FROM pn_var_rent_inv_all

9324:
9325: -- Get the invoice id for combination of a given invoice_date and period_id
9326: CURSOR check_inv_exists(p_var_rent_id IN NUMBER,p_inv_dt IN DATE,p_prd_id IN NUMBER) IS
9327: SELECT var_rent_inv_id inv_id
9328: FROM pn_var_rent_inv_all
9329: WHERE invoice_date=p_inv_dt
9330: AND var_rent_id =p_var_rent_id
9331: AND period_id =p_prd_id
9332: AND adjust_num=0;

Line 9463: pn_var_rent_inv_all vinv

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
9466: AND pilt.index_period_id = ppt.index_period_id
9467: AND pilt.rent_increase_term_id = ppt.payment_term_id

Line 9496: FROM pn_var_rent_inv_all

9492: WHERE var_rent_id =p_var_rent_id;
9493: --Get invoice id of the 1st partial period
9494: CURSOR get_fst_inv_id(p_var_rent_id IN NUMBER) IS
9495: SELECT var_rent_inv_id
9496: FROM pn_var_rent_inv_all
9497: WHERE var_rent_id=p_var_rent_id
9498: AND period_id IN (SELECT period_id
9499: FROM pn_var_periods_all
9500: WHERE period_num=1

Line 9590: pn_var_rent_inv_all vinv

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
9593: AND pilt.index_period_id = ppt.index_period_id
9594: AND pilt.rent_increase_term_id = ppt.payment_term_id

Line 9620: FROM pn_var_rent_inv_all

9616: AND var_rent_inv_id=invoice_id);
9617:
9618: CURSOR check_inv_exists(p_var_rent_id IN NUMBER,p_inv_dt IN DATE,p_prd_id IN NUMBER) IS
9619: SELECT var_rent_inv_id inv_id
9620: FROM pn_var_rent_inv_all
9621: WHERE invoice_date=p_inv_dt
9622: AND period_id= p_prd_id
9623: AND var_rent_id= p_var_rent_id
9624: AND adjust_num=0;

Line 9963: FROM pn_var_rent_inv_all

9959:
9960: CURSOR var_for_rent ( l_period_id IN NUMBER ) IS
9961: SELECT sum(decode(adjust_num,0,
9962: FOR_PER_RENT,0)) for_var_rent
9963: FROM pn_var_rent_inv_all
9964: WHERE period_id = l_period_id;
9965:
9966: l_for_rent NUMBER := NULL;
9967:

Line 10148: FROM pn_var_rent_inv_all rent_inv

10144: p_inv_dt IN DATE
10145: )
10146: IS
10147: SELECT SUM(rent_inv.ACTUAL_INVOICED_AMOUNT) act_inv_amt
10148: FROM pn_var_rent_inv_all rent_inv
10149: WHERE rent_inv.period_id = p_prd_id
10150: AND (rent_inv.invoice_date = p_inv_dt OR p_inv_dt IS NULL);
10151:
10152: l_vr_id NUMBER :=NULL;

Line 10239: FROM pn_var_rent_inv_all rent_inv

10235: p_inv_dt IN DATE
10236: )
10237: IS
10238: SELECT SUM(rent_inv.ACTUAL_INVOICED_AMOUNT) act_inv_amt
10239: FROM pn_var_rent_inv_all rent_inv
10240: WHERE rent_inv.period_id = p_prd_id
10241: AND (rent_inv.invoice_date <= p_inv_dt OR p_inv_dt IS NULL);
10242:
10243: l_vr_id NUMBER :=NULL;

Line 10304: FROM pn_var_rent_inv_all vinv

10300: IS
10301: SELECT 'y' AS include_flag
10302: FROM DUAL
10303: WHERE NOT EXISTS (SELECT NULL
10304: FROM pn_var_rent_inv_all vinv
10305: WHERE vinv.ACTUAL_INVOICED_AMOUNT <> 0
10306: AND vinv.period_id = p_prd_id
10307: );
10308: l_include VARCHAR2(1):= 'n';

Line 10360: pn_var_rent_inv_all inv

10356: ,p_inv_sch_date DATE
10357: ,p_term_template_id NUMBER) IS
10358: SELECT inv.var_rent_inv_id
10359: FROM
10360: pn_var_rent_inv_all inv
10361: WHERE
10362: var_rent_id = p_vr_id AND
10363: period_id = p_prd_id AND
10364: invoice_date = p_inv_dt AND

Line 10378: FROM pn_var_rent_inv_all

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'
10381: AND (start_date <> p_inv_sch_date OR
10382: term_template_id <> p_term_template_id);*/

Line 10424: pn_var_rent_inv_all

10420:
10421: /* update the invoice */
10422: /*Since forcasted rents are not yet exported, we can update them.*/
10423: UPDATE
10424: pn_var_rent_inv_all
10425: SET
10426: actual_term_status = 'N'
10427: ,last_update_date = SYSDATE
10428: ,last_updated_by = NVL(fnd_global.user_id,0)

Line 10438: pn_var_rent_inv_all

10434:
10435: /* update the invoice */
10436: /*Since forcasted rents are not yet exported, we can update them.*/
10437: UPDATE
10438: pn_var_rent_inv_all
10439: SET
10440: forecasted_term_status = 'N'
10441: ,last_update_date = SYSDATE
10442: ,last_updated_by = NVL(fnd_global.user_id,0)

Line 10452: pn_var_rent_inv_all

10448:
10449: /* update the invoice */
10450: /*Since forcasted rents are not yet exported, we can update them.*/
10451: UPDATE
10452: pn_var_rent_inv_all
10453: SET
10454: actual_term_status = 'N'
10455: ,last_update_date = SYSDATE
10456: ,last_updated_by = NVL(fnd_global.user_id,0)

Line 10484: FROM pn_var_rent_inv_all

10480: RETURN NUMBER IS
10481:
10482: CURSOR csr_get_inv IS
10483: SELECT sum(actual_invoiced_amount) AS actual_rent
10484: FROM pn_var_rent_inv_all
10485: WHERE period_id = p_period_id
10486: AND invoice_date = p_invoice_date
10487: AND var_rent_inv_id <= p_var_rent_inv_id
10488: AND true_up_amt IS NULL;

Line 10492: FROM pn_var_rent_inv_all

10488: AND true_up_amt IS NULL;
10489:
10490: CURSOR csr_get_true IS
10491: SELECT constr_actual_rent
10492: FROM pn_var_rent_inv_all
10493: WHERE invoice_date = p_invoice_date
10494: AND true_up_amt IS NOT NULL
10495: AND var_rent_inv_id = p_var_rent_inv_id;
10496:

Line 10784: FROM pn_var_rent_inv_all

10780: IS
10781:
10782: CURSOR inv_details_cur IS
10783: SELECT variance_exp_code, actual_exp_code, adjust_num, actual_invoiced_amount, for_per_rent
10784: FROM pn_var_rent_inv_all
10785: WHERE period_id = p_period_id
10786: AND var_rent_inv_id = p_var_rent_inv_id;
10787:
10788: BEGIN