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_RENTS_ALL

Line 80: pn_var_rents_all

76: CURSOR vr_start_date_c(p_vr_id IN NUMBER) IS
77: SELECT
78: commencement_date
79: FROM
80: pn_var_rents_all
81: WHERE
82: var_rent_id = p_vr_id;
83:
84: /* get first period details */

Line 144: pn_var_rents_all

140: CURSOR vr_end_date_c(p_vr_id IN NUMBER) IS
141: SELECT
142: termination_date
143: FROM
144: pn_var_rents_all
145: WHERE
146: var_rent_id = p_vr_id;
147:
148: /* get last period details */

Line 564: pn_var_rents_all var

560: prd.period_id
561: ,prd.partial_period
562: FROM
563: pn_var_periods_all prd,
564: pn_var_rents_all var
565: WHERE
566: prd.var_rent_id = p_vr_id AND
567: prd.var_rent_id = var.var_rent_id AND
568: prd.end_date = var.termination_date;

Line 577: pn_var_rents_all var

573: prd.period_id
574: ,prd.partial_period
575: FROM
576: pn_var_periods_all prd,
577: pn_var_rents_all var
578: WHERE
579: prd.var_rent_id = p_vr_id AND
580: prd.var_rent_id = var.var_rent_id AND
581: prd.start_date = var.commencement_date;

Line 1831: FROM pn_var_rents_all

1827:
1828: /* get ORG ID */
1829: CURSOR org_c(p_vr_id IN NUMBER) IS
1830: SELECT org_id, commencement_date
1831: FROM pn_var_rents_all
1832: WHERE var_rent_id = p_vr_id;
1833:
1834:
1835: /* get FY sales */

Line 2205: FROM pn_var_rents_all

2201:
2202: /* get ORG ID */
2203: CURSOR org_c(p_vr_id IN NUMBER) IS
2204: SELECT org_id, termination_date
2205: FROM pn_var_rents_all
2206: WHERE var_rent_id = p_vr_id;
2207:
2208: /* get LY sales */
2209: CURSOR ly_sales_c( p_vr_id IN NUMBER

Line 2661: FROM PN_VAR_RENTS_ALL abat

2657: IS
2658: -- Allowances first ot abatements?
2659: CURSOR order_c(ip_var_rent_id NUMBER) IS
2660: SELECT ORDER_OF_APPL_CODE, invoice_on, termination_date
2661: FROM PN_VAR_RENTS_ALL abat
2662: WHERE abat.var_rent_id = ip_var_rent_id;
2663:
2664: -- Get the details of
2665: CURSOR inv_c( ip_var_rent_id NUMBER,

Line 2715: FROM pn_var_rents_all vr,

2711: G_INV_ON_ACTUAL, actual_exp_code,
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:

Line 2939: FROM pn_var_rents_all

2935: AND inv1.invoice_date = inv.invoice_date);
2936: CURSOR csr_get_abt(ip_var_rent_id NUMBER)
2937: IS
2938: SELECT negative_rent
2939: FROM pn_var_rents_all
2940: WHERE var_rent_id = ip_var_rent_id;
2941: -- Get the details of
2942: CURSOR temp_c(ip_var_rent_inv_id NUMBER
2943: ) IS

Line 3101: FROM pn_var_rents_all

3097: AND inv1.invoice_date = inv.invoice_date);
3098: CURSOR csr_get_abt(ip_var_rent_id NUMBER)
3099: IS
3100: SELECT negative_rent
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;

Line 3227: FROM pn_var_rents_all

3223:
3224: CURSOR csr_get_abt(ip_var_rent_id NUMBER)
3225: IS
3226: SELECT negative_rent
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;

Line 3332: FROM PN_VAR_RENTS_ALL ABAT

3328: AND type_code = pn_var_rent_calc_pkg.G_ABAT_TYPE_CODE_ABAT;
3329: -- Get the details of
3330: CURSOR EXCESS_ABAT_C(ip_var_rent_id NUMBER) IS
3331: SELECT EXCESS_ABAT_CODE
3332: FROM PN_VAR_RENTS_ALL ABAT
3333: WHERE abat.var_rent_id = ip_var_rent_id;
3334: -- Get the details of inv_start, end_date
3335: CURSOR invoice_dates_c(ip_var_rent_id NUMBER,
3336: ip_invoice_date DATE

Line 3377: FROM pn_var_rents_all

3373: -- Get the details of negative_rent
3374: CURSOR neg_rent_c(ip_var_rent_id NUMBER
3375: ) IS
3376: SELECT negative_rent
3377: FROM pn_var_rents_all
3378: WHERE var_rent_id = ip_var_rent_id;
3379: -- Get the proration type
3380: CURSOR proration_type_c(ip_var_rent_id NUMBER
3381: ) IS

Line 3383: FROM pn_var_rents_all

3379: -- Get the proration type
3380: CURSOR proration_type_c(ip_var_rent_id NUMBER
3381: ) IS
3382: SELECT proration_rule
3383: FROM pn_var_rents_all
3384: WHERE var_rent_id = ip_var_rent_id;
3385:
3386: -- Get the number of inv which should exist for a period
3387: CURSOR num_inv_c(ip_var_rent_inv_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 3402: FROM pn_var_rents_all vr,

3398: ) IS
3399: SELECT inv.invoice_date,
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

Line 3638: FROM pn_var_rents_all

3634: -- Get the proration type
3635: CURSOR proration_type_c(ip_var_rent_id NUMBER
3636: ) IS
3637: SELECT proration_rule
3638: FROM pn_var_rents_all
3639: WHERE var_rent_id = ip_var_rent_id;
3640:
3641:
3642:

Line 3793: FROM pn_var_rents_all

3789: -- Get the proration type
3790: CURSOR proration_type_c(ip_var_rent_id NUMBER
3791: ) IS
3792: SELECT proration_rule
3793: FROM pn_var_rents_all
3794: WHERE var_rent_id = ip_var_rent_id;
3795:
3796:
3797: l_min_grp_date DATE;

Line 3982: FROM pn_var_periods_all pvp, pn_var_rents_all pvr

3978:
3979: -- Get the details of
3980: CURSOR first_period_cur (p_var_rent_id NUMBER) IS
3981: SELECT pvp.period_id, pvp.partial_period
3982: FROM pn_var_periods_all pvp, pn_var_rents_all pvr
3983: WHERE pvr.var_rent_id = p_var_rent_id
3984: AND pvp.var_rent_id = pvr.var_rent_id
3985: AND pvp.start_date = pvr.commencement_date;
3986:

Line 4753: FROM pn_var_rents_all

4749:
4750: /* get ORG ID */
4751: CURSOR org_c(p_vr_id IN NUMBER) IS
4752: SELECT org_id
4753: FROM pn_var_rents_all
4754: WHERE var_rent_id = p_vr_id;
4755:
4756: l_org_id NUMBER;
4757: l_precision NUMBER;

Line 5161: pn_var_rents_all var

5157: prd.period_id
5158: ,prd.partial_period
5159: FROM
5160: pn_var_periods_all prd,
5161: pn_var_rents_all var
5162: WHERE
5163: prd.var_rent_id = p_vr_id AND
5164: prd.var_rent_id = var.var_rent_id AND
5165: prd.end_date = var.termination_date;

Line 5174: pn_var_rents_all var

5170: prd.period_id
5171: ,prd.partial_period
5172: FROM
5173: pn_var_periods_all prd,
5174: pn_var_rents_all var
5175: WHERE
5176: prd.var_rent_id = p_vr_id AND
5177: prd.var_rent_id = var.var_rent_id AND
5178: prd.start_date = var.commencement_date;

Line 5705: FROM PN_VAR_RENTS_ALL var, PN_VAR_RENT_DATES_ALL dates

5701: ,'SA' ,6
5702: ,'YR' ,12
5703: ,NULL) invg_freq_code,
5704: var.proration_rule
5705: FROM PN_VAR_RENTS_ALL var, PN_VAR_RENT_DATES_ALL dates
5706: WHERE var.var_rent_id = vr_id
5707: AND dates.var_rent_id = var.var_rent_id;
5708:
5709:

Line 5801: FROM PN_VAR_RENTS_ALL var

5797: CURSOR inv_start_date_cur IS
5798: SELECT var.proration_rule,
5799: var.commencement_date,
5800: var.termination_date
5801: FROM PN_VAR_RENTS_ALL var
5802: WHERE var.var_rent_id = vr_id;
5803:
5804:
5805: CURSOR period_cur IS

Line 5895: FROM PN_VAR_RENTS_ALL var, PN_VAR_RENT_DATES_ALL dates

5891: ,'QTR',3
5892: ,'SA' ,6
5893: ,'YR' ,12
5894: ,NULL) invg_freq_code
5895: FROM PN_VAR_RENTS_ALL var, PN_VAR_RENT_DATES_ALL dates
5896: WHERE var.var_rent_id = vr_id
5897: AND dates.var_rent_id = var.var_rent_id;
5898:
5899: CURSOR last_period_cur IS

Line 6417: pn_var_rents_all pvr,

6413: pvr.rent_num,
6414: pl.org_id
6415: FROM pn_leases pl,
6416: pn_lease_details_all pld,
6417: pn_var_rents_all pvr,
6418: pn_locations_all ploc
6419: WHERE pl.lease_id = pvr.lease_id
6420: AND pld.lease_id = pvr.lease_id
6421: AND ploc.location_id = pvr.location_id

Line 6453: pn_var_rents_all pvr,

6449: pvr.rent_num,
6450: pl.org_id
6451: FROM pn_leases pl,
6452: pn_lease_details_all pld,
6453: pn_var_rents_all pvr,
6454: pn_locations_all ploc
6455: WHERE pl.lease_id = pvr.lease_id
6456: AND pld.lease_id = pvr.lease_id
6457: AND ploc.location_id = pvr.location_id

Line 6475: FROM pn_var_rents_all pvr,

6471: pvr.invoice_on,
6472: pvr.cumulative_vol,
6473: pvr.rent_num,
6474: pl.org_id
6475: FROM pn_var_rents_all pvr,
6476: pn_leases pl,
6477: pn_lease_details_all pld
6478: WHERE pl.lease_id = pvr.lease_id
6479: AND pld.lease_id = pvr.lease_id

Line 6880: FROM pn_var_periods_all pvp, pn_var_rents_all pvr

6876:
6877: -- Get the details of
6878: CURSOR first_period_cur (p_var_rent_id NUMBER, p_period_id NUMBER) IS
6879: SELECT pvp.period_id, pvr.commencement_date
6880: FROM pn_var_periods_all pvp, pn_var_rents_all pvr
6881: WHERE pvr.var_rent_id = p_var_rent_id
6882: AND pvp.period_id = p_period_id
6883: AND pvp.partial_period = 'Y'
6884: AND pvp.start_date = pvr.commencement_date;

Line 6890: FROM pn_var_periods_all pvp, pn_var_rents_all pvr

6886:
6887: -- Get the details of
6888: CURSOR last_period_cur (p_var_rent_id NUMBER, p_period_id NUMBER) IS
6889: SELECT pvp.period_id, pvr.termination_date
6890: FROM pn_var_periods_all pvp, pn_var_rents_all pvr
6891: WHERE pvr.var_rent_id = p_var_rent_id
6892: AND pvp.period_id = p_period_id
6893: AND pvp.partial_period = 'Y'
6894: AND pvp.end_date = pvr.termination_date;

Line 6984: FROM pn_var_periods_all pvp, pn_var_rents_all pvr

6980:
6981: -- Get the details of
6982: CURSOR first_period_cur (p_var_rent_id NUMBER, p_period_id NUMBER) IS
6983: SELECT pvp.period_id, pvr.commencement_date
6984: FROM pn_var_periods_all pvp, pn_var_rents_all pvr
6985: WHERE pvr.var_rent_id = p_var_rent_id
6986: AND pvp.period_id = p_period_id
6987: AND pvp.partial_period = 'Y'
6988: AND pvp.start_date = pvr.commencement_date;

Line 6994: FROM pn_var_periods_all pvp, pn_var_rents_all pvr

6990:
6991: -- Get the details of
6992: CURSOR last_period_cur (p_var_rent_id NUMBER, p_period_id NUMBER) IS
6993: SELECT pvp.period_id, pvr.termination_date
6994: FROM pn_var_periods_all pvp, pn_var_rents_all pvr
6995: WHERE pvr.var_rent_id = p_var_rent_id
6996: AND pvp.period_id = p_period_id
6997: AND pvp.partial_period = 'Y'
6998: AND pvp.end_date = pvr.termination_date;

Line 7106: FROM pn_var_periods_all pvp, pn_var_rents_all pvr

7102:
7103: -- Get the details of
7104: CURSOR first_period_cur (p_var_rent_id NUMBER, p_period_id NUMBER) IS
7105: SELECT pvp.period_id, pvr.commencement_date
7106: FROM pn_var_periods_all pvp, pn_var_rents_all pvr
7107: WHERE pvr.var_rent_id = p_var_rent_id
7108: AND pvp.period_id = p_period_id
7109: AND pvp.partial_period = 'Y'
7110: AND pvp.start_date = pvr.commencement_date;

Line 7116: FROM pn_var_periods_all pvp, pn_var_rents_all pvr

7112:
7113: -- Get the details of
7114: CURSOR last_period_cur (p_var_rent_id NUMBER, p_period_id NUMBER) IS
7115: SELECT pvp.period_id, pvr.termination_date
7116: FROM pn_var_periods_all pvp, pn_var_rents_all pvr
7117: WHERE pvr.var_rent_id = p_var_rent_id
7118: AND pvp.period_id = p_period_id
7119: AND pvp.partial_period = 'Y'
7120: AND pvp.end_date = pvr.termination_date;

Line 7367: FROM pn_var_periods_all pvp, pn_var_rents_all pvr

7363:
7364: -- Get the details of
7365: CURSOR first_period_cur (p_var_rent_id NUMBER, p_period_id NUMBER) IS
7366: SELECT pvp.period_id, pvr.commencement_date
7367: FROM pn_var_periods_all pvp, pn_var_rents_all pvr
7368: WHERE pvr.var_rent_id = p_var_rent_id
7369: AND pvp.period_id = p_period_id
7370: AND pvp.partial_period = 'Y'
7371: AND pvp.start_date = pvr.commencement_date;

Line 7377: FROM pn_var_periods_all pvp, pn_var_rents_all pvr

7373:
7374: -- Get the details of
7375: CURSOR last_period_cur (p_var_rent_id NUMBER, p_period_id NUMBER) IS
7376: SELECT pvp.period_id, pvr.termination_date
7377: FROM pn_var_periods_all pvp, pn_var_rents_all pvr
7378: WHERE pvr.var_rent_id = p_var_rent_id
7379: AND pvp.period_id = p_period_id
7380: AND pvp.partial_period = 'Y'
7381: AND pvp.end_date = pvr.termination_date;

Line 7501: FROM pn_var_periods_all pvp, pn_var_rents_all pvr

7497:
7498: -- Get the details of
7499: CURSOR first_period_cur (p_var_rent_id NUMBER, p_period_id NUMBER) IS
7500: SELECT pvp.period_id, pvr.commencement_date
7501: FROM pn_var_periods_all pvp, pn_var_rents_all pvr
7502: WHERE pvr.var_rent_id = p_var_rent_id
7503: AND pvp.period_id = p_period_id
7504: AND pvp.partial_period = 'Y'
7505: AND pvp.start_date = pvr.commencement_date;

Line 7511: FROM pn_var_periods_all pvp, pn_var_rents_all pvr

7507:
7508: -- Get the details of
7509: CURSOR last_period_cur (p_var_rent_id NUMBER, p_period_id NUMBER) IS
7510: SELECT pvp.period_id, pvr.termination_date
7511: FROM pn_var_periods_all pvp, pn_var_rents_all pvr
7512: WHERE pvr.var_rent_id = p_var_rent_id
7513: AND pvp.period_id = p_period_id
7514: AND pvp.partial_period = 'Y'
7515: AND pvp.end_date = pvr.termination_date;

Line 7610: FROM pn_var_periods_all pvp, pn_var_rents_all pvr

7606:
7607: -- Get the details of
7608: CURSOR first_period_cur (p_var_rent_id NUMBER, p_period_id NUMBER) IS
7609: SELECT pvp.period_id, pvr.commencement_date
7610: FROM pn_var_periods_all pvp, pn_var_rents_all pvr
7611: WHERE pvr.var_rent_id = p_var_rent_id
7612: AND pvp.period_id = p_period_id
7613: AND pvp.partial_period = 'Y'
7614: AND pvp.start_date = pvr.commencement_date;

Line 7620: FROM pn_var_periods_all pvp, pn_var_rents_all pvr

7616:
7617: -- Get the details of
7618: CURSOR last_period_cur (p_var_rent_id NUMBER, p_period_id NUMBER) IS
7619: SELECT pvp.period_id, pvr.termination_date
7620: FROM pn_var_periods_all pvp, pn_var_rents_all pvr
7621: WHERE pvr.var_rent_id = p_var_rent_id
7622: AND pvp.period_id = p_period_id
7623: AND pvp.partial_period = 'Y'
7624: AND pvp.end_date = pvr.termination_date;

Line 7743: FROM pn_var_periods_all pvp, pn_var_rents_all pvr

7739:
7740: -- Get the details of
7741: CURSOR first_period_cur (p_var_rent_id NUMBER, p_period_id NUMBER) IS
7742: SELECT pvp.period_id, pvr.commencement_date
7743: FROM pn_var_periods_all pvp, pn_var_rents_all pvr
7744: WHERE pvr.var_rent_id = p_var_rent_id
7745: AND pvp.period_id = p_period_id
7746: AND pvp.partial_period = 'Y'
7747: AND pvp.start_date = pvr.commencement_date;

Line 7753: FROM pn_var_periods_all pvp, pn_var_rents_all pvr

7749:
7750: -- Get the details of
7751: CURSOR last_period_cur (p_var_rent_id NUMBER, p_period_id NUMBER) IS
7752: SELECT pvp.period_id, pvr.termination_date
7753: FROM pn_var_periods_all pvp, pn_var_rents_all pvr
7754: WHERE pvr.var_rent_id = p_var_rent_id
7755: AND pvp.period_id = p_period_id
7756: AND pvp.partial_period = 'Y'
7757: AND pvp.end_date = pvr.termination_date;

Line 7867: FROM pn_var_periods_all pvp, pn_var_rents_all pvr

7863:
7864: -- Get the details of
7865: CURSOR first_period_cur (p_var_rent_id NUMBER, p_period_id NUMBER) IS
7866: SELECT pvp.period_id, pvr.commencement_date
7867: FROM pn_var_periods_all pvp, pn_var_rents_all pvr
7868: WHERE pvr.var_rent_id = p_var_rent_id
7869: AND pvp.period_id = p_period_id
7870: AND pvp.partial_period = 'Y'
7871: AND pvp.start_date = pvr.commencement_date;

Line 7877: FROM pn_var_periods_all pvp, pn_var_rents_all pvr

7873:
7874: -- Get the details of
7875: CURSOR last_period_cur (p_var_rent_id NUMBER, p_period_id NUMBER) IS
7876: SELECT pvp.period_id, pvr.termination_date
7877: FROM pn_var_periods_all pvp, pn_var_rents_all pvr
7878: WHERE pvr.var_rent_id = p_var_rent_id
7879: AND pvp.period_id = p_period_id
7880: AND pvp.partial_period = 'Y'
7881: AND pvp.end_date = pvr.termination_date;

Line 8010: FROM pn_var_periods_all pvp, pn_var_rents_all pvr

8006:
8007: -- Get the details of
8008: CURSOR first_period_cur (p_var_rent_id NUMBER, p_period_id NUMBER) IS
8009: SELECT pvp.period_id, pvr.commencement_date
8010: FROM pn_var_periods_all pvp, pn_var_rents_all pvr
8011: WHERE pvr.var_rent_id = p_var_rent_id
8012: AND pvp.period_id = p_period_id
8013: AND pvp.partial_period = 'Y'
8014: AND pvp.start_date = pvr.commencement_date;

Line 8020: FROM pn_var_periods_all pvp, pn_var_rents_all pvr

8016:
8017: -- Get the details of
8018: CURSOR last_period_cur (p_var_rent_id NUMBER, p_period_id NUMBER) IS
8019: SELECT pvp.period_id, pvr.termination_date
8020: FROM pn_var_periods_all pvp, pn_var_rents_all pvr
8021: WHERE pvr.var_rent_id = p_var_rent_id
8022: AND pvp.period_id = p_period_id
8023: AND pvp.partial_period = 'Y'
8024: AND pvp.end_date = pvr.termination_date;

Line 8156: FROM pn_var_periods_all pvp, pn_var_rents_all pvr

8152:
8153: -- Get the details of
8154: CURSOR first_period_cur (p_var_rent_id NUMBER, p_period_id NUMBER) IS
8155: SELECT pvp.period_id, pvr.commencement_date
8156: FROM pn_var_periods_all pvp, pn_var_rents_all pvr
8157: WHERE pvr.var_rent_id = p_var_rent_id
8158: AND pvp.period_id = p_period_id
8159: AND pvp.partial_period = 'Y'
8160: AND pvp.start_date = pvr.commencement_date;

Line 8166: FROM pn_var_periods_all pvp, pn_var_rents_all pvr

8162:
8163: -- Get the details of
8164: CURSOR last_period_cur (p_var_rent_id NUMBER, p_period_id NUMBER) IS
8165: SELECT pvp.period_id, pvr.termination_date
8166: FROM pn_var_periods_all pvp, pn_var_rents_all pvr
8167: WHERE pvr.var_rent_id = p_var_rent_id
8168: AND pvp.period_id = p_period_id
8169: AND pvp.partial_period = 'Y'
8170: AND pvp.end_date = pvr.termination_date;

Line 8264: FROM pn_var_periods_all pvp, pn_var_rents_all pvr

8260:
8261: -- Get the details of
8262: CURSOR first_period_cur (p_var_rent_id NUMBER, p_period_id NUMBER) IS
8263: SELECT pvp.period_id, pvr.commencement_date
8264: FROM pn_var_periods_all pvp, pn_var_rents_all pvr
8265: WHERE pvr.var_rent_id = p_var_rent_id
8266: AND pvp.period_id = p_period_id
8267: AND pvp.partial_period = 'Y'
8268: AND pvp.start_date = pvr.commencement_date;

Line 8274: FROM pn_var_periods_all pvp, pn_var_rents_all pvr

8270:
8271: -- Get the details of
8272: CURSOR last_period_cur (p_var_rent_id NUMBER, p_period_id NUMBER) IS
8273: SELECT pvp.period_id, pvr.termination_date
8274: FROM pn_var_periods_all pvp, pn_var_rents_all pvr
8275: WHERE pvr.var_rent_id = p_var_rent_id
8276: AND pvp.period_id = p_period_id
8277: AND pvp.partial_period = 'Y'
8278: AND pvp.end_date = pvr.termination_date;

Line 8372: FROM pn_var_periods_all pvp, pn_var_rents_all pvr

8368:
8369: -- Get the details of
8370: CURSOR first_period_cur (p_var_rent_id NUMBER, p_period_id NUMBER) IS
8371: SELECT pvp.period_id, pvr.commencement_date
8372: FROM pn_var_periods_all pvp, pn_var_rents_all pvr
8373: WHERE pvr.var_rent_id = p_var_rent_id
8374: AND pvp.period_id = p_period_id
8375: AND pvp.partial_period = 'Y'
8376: AND pvp.start_date = pvr.commencement_date;

Line 8381: FROM pn_var_periods_all pvp, pn_var_rents_all pvr

8377:
8378: -- Get the details of
8379: CURSOR last_period_cur (p_var_rent_id NUMBER, p_period_id NUMBER) IS
8380: SELECT pvp.period_id, pvr.termination_date
8381: FROM pn_var_periods_all pvp, pn_var_rents_all pvr
8382: WHERE pvr.var_rent_id = p_var_rent_id
8383: AND pvp.period_id = p_period_id
8384: AND pvp.partial_period = 'Y'
8385: AND pvp.end_date = pvr.termination_date;

Line 8472: FROM pn_var_periods_all pvp, pn_var_rents_all pvr

8468:
8469: -- Get the details of
8470: CURSOR first_period_cur (p_var_rent_id NUMBER, p_period_id NUMBER) IS
8471: SELECT pvp.period_id, pvr.commencement_date
8472: FROM pn_var_periods_all pvp, pn_var_rents_all pvr
8473: WHERE pvr.var_rent_id = p_var_rent_id
8474: AND pvp.period_id = p_period_id
8475: AND pvp.partial_period = 'Y'
8476: AND pvp.start_date = pvr.commencement_date;

Line 8481: FROM pn_var_periods_all pvp, pn_var_rents_all pvr

8477:
8478: -- Get the details of
8479: CURSOR last_period_cur (p_var_rent_id NUMBER, p_period_id NUMBER) IS
8480: SELECT pvp.period_id, pvr.termination_date
8481: FROM pn_var_periods_all pvp, pn_var_rents_all pvr
8482: WHERE pvr.var_rent_id = p_var_rent_id
8483: AND pvp.period_id = p_period_id
8484: AND pvp.partial_period = 'Y'
8485: AND pvp.end_date = pvr.termination_date;

Line 8583: pn_var_rents_all pvr

8579:
8580: CURSOR line_item_cur IS
8581: SELECT trx.line_item_group_id, pvr.commencement_date
8582: FROM pn_var_trx_headers_all trx,
8583: pn_var_rents_all pvr
8584: WHERE trx.var_rent_id = p_var_rent_id
8585: AND trx.var_rent_id = pvr.var_rent_id
8586: AND trx.line_item_id = p_line_item_id;
8587:

Line 8638: pn_var_rents_all pvr

8634:
8635: CURSOR line_item_cur IS
8636: SELECT trx.line_item_group_id, pvr.commencement_date
8637: FROM pn_var_trx_headers_all trx,
8638: pn_var_rents_all pvr
8639: WHERE trx.var_rent_id = p_var_rent_id
8640: AND trx.var_rent_id = pvr.var_rent_id
8641: AND trx.line_item_id = p_line_item_id;
8642:

Line 8693: pn_var_rents_all pvr

8689:
8690: CURSOR line_item_cur IS
8691: SELECT trx.line_item_group_id, pvr.commencement_date
8692: FROM pn_var_trx_headers_all trx,
8693: pn_var_rents_all pvr
8694: WHERE trx.var_rent_id = p_var_rent_id
8695: AND trx.var_rent_id = pvr.var_rent_id
8696: AND trx.line_item_id = p_line_item_id;
8697:

Line 8976: FROM pn_var_rents_all

8972: l_fst_inv_id NUMBER := NULL;
8973:
8974: CURSOR org_cur(p_var_rent_id IN NUMBER) IS
8975: SELECT org_id
8976: FROM pn_var_rents_all
8977: WHERE var_rent_id =p_var_rent_id;
8978:
8979: /*Cursor to get all pmt terms for a particular invoice*/
8980: CURSOR get_all_pmt_terms(p_inv_id IN NUMBER) IS

Line 8983: pn_var_rents_all vrent,

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
8987: AND pterm.start_date <=

Line 9150: FROM pn_var_rents_all

9146: IS
9147: --- Get org_id
9148: CURSOR org_cur(p_var_rent_id IN NUMBER) IS
9149: SELECT org_id
9150: FROM pn_var_rents_all
9151: WHERE var_rent_id =p_var_rent_id;
9152:
9153: -- Get the last partial period id
9154: CURSOR get_last_partial_prd(p_var_rent_id IN NUMBER) IS

Line 9156: FROM pn_var_periods_all prd ,pn_var_rents_all vrent

9152:
9153: -- Get the last partial period id
9154: CURSOR get_last_partial_prd(p_var_rent_id IN NUMBER) IS
9155: SELECT prd.period_id
9156: FROM pn_var_periods_all prd ,pn_var_rents_all vrent
9157: WHERE prd.var_rent_id=p_var_rent_id
9158: AND vrent.var_rent_id = prd.var_rent_id
9159: AND prd.end_date = vrent.termination_date
9160: AND partial_period='Y';

Line 9347: pn_var_rents_all vrent,

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
9351: AND pterm.start_date <=

Line 9391: FROM pn_var_rents_all

9387: AND adjust_num=0;
9388:
9389: CURSOR org_cur(p_var_rent_id IN NUMBER) IS
9390: SELECT org_id
9391: FROM pn_var_rents_all
9392: WHERE var_rent_id =p_var_rent_id;
9393:
9394: BEGIN
9395: /* Get 1st invoice */

Line 9546: FROM pn_var_rents_all

9542: AND var_rent_inv_id=invoice_id);
9543:
9544: CURSOR org_cur(p_var_rent_id IN NUMBER) IS
9545: SELECT org_id
9546: FROM pn_var_rents_all
9547: WHERE var_rent_id =p_var_rent_id;
9548: --Get invoice id of the 1st partial period
9549: CURSOR get_fst_inv_id(p_var_rent_id IN NUMBER) IS
9550: SELECT var_rent_inv_id

Line 9683: FROM pn_var_rents_all

9679: AND adjust_num=0;
9680:
9681: CURSOR org_cur(p_var_rent_id IN NUMBER) IS
9682: SELECT org_id
9683: FROM pn_var_rents_all
9684: WHERE var_rent_id =p_var_rent_id;
9685:
9686: l_abtmt_exists VARCHAR2(1) := NULL;
9687: l_inv_id NUMBER := NULL;

Line 10010: FROM pn_var_rents_all

10006: RETURN NUMBER IS
10007:
10008: CURSOR var_rent_type ( l_var_rent_id IN NUMBER ) IS
10009: SELECT invoice_on
10010: FROM pn_var_rents_all
10011: WHERE var_rent_id = l_var_rent_id
10012: AND invoice_on = 'FORECASTED';
10013:
10014:

Line 10391: FROM pn_var_rents_all

10387:
10388: /* get term template id for variable rent */
10389: CURSOR template_cur IS
10390: SELECT term_template_id
10391: FROM pn_var_rents_all
10392: WHERE var_rent_id = p_var_rent_id;
10393:
10394: /* get invoice dates for variable rent */
10395: CURSOR invoice_cur( p_vr_id IN NUMBER) IS

Line 10592: FROM pn_var_rents_all

10588:
10589: /* verifying if agreement's length is less than 24 */
10590: CURSOR vr_length IS
10591: SELECT var_rent_id, proration_rule, termination_date
10592: FROM pn_var_rents_all
10593: WHERE var_rent_id = p_varRentId
10594: AND proration_rule = 'FLY'
10595: AND MONTHS_BETWEEN(commencement_date, termination_date) < 24;
10596:

Line 10619: pn_var_rents_all var

10615: prd.period_id
10616: ,prd.partial_period
10617: FROM
10618: pn_var_periods_all prd,
10619: pn_var_rents_all var
10620: WHERE
10621: prd.var_rent_id = p_vr_id AND
10622: prd.var_rent_id = var.var_rent_id AND
10623: prd.start_date = var.commencement_date AND