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_PERIODS_ALL

Line 9: period_id pn_var_periods_all.period_id%TYPE,

5: ------------------------------------------------------------------------- */
6: TYPE NUM_T IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
7: TYPE inv_date_rec IS RECORD(
8: inv_date pn_var_grp_dates_all.invoice_date%TYPE,
9: period_id pn_var_periods_all.period_id%TYPE,
10: inv_flag VARCHAR2(1));
11:
12: TYPE inv_date_type IS
13: TABLE OF inv_date_rec

Line 92: pn_var_periods_all

88: period_id
89: ,start_date
90: ,end_date
91: FROM
92: pn_var_periods_all
93: WHERE
94: var_rent_id = p_vr_id AND
95: start_date = p_st_dt AND
96: partial_period = 'Y';

Line 156: pn_var_periods_all

152: period_id
153: ,start_date
154: ,end_date
155: FROM
156: pn_var_periods_all
157: WHERE
158: var_rent_id = p_vr_id AND
159: end_date = p_end_dt AND
160: partial_period = 'Y';

Line 342: pn_var_periods_all

338: CURSOR periods_c(p_vr_id IN NUMBER) IS
339: SELECT
340: period_id
341: FROM
342: pn_var_periods_all
343: WHERE
344: var_rent_id = p_vr_id
345: ORDER BY
346: start_date;

Line 479: pn_var_periods_all

475: WHERE
476: period_id IN (SELECT
477: period_id
478: FROM
479: pn_var_periods_all
480: WHERE
481: var_rent_id = p_vr_id AND
482: start_date = p_vr_comm_date);
483:

Line 533: pn_var_periods_all

529: WHERE
530: period_id IN (SELECT
531: period_id
532: FROM
533: pn_var_periods_all
534: WHERE
535: var_rent_id = p_vr_id AND
536: end_date = p_vr_term_date);
537:

Line 552: pn_var_periods_all

548: CURSOR period_num_c ( p_vr_id IN NUMBER) IS
549: SELECT
550: count(period_id) perion_num
551: FROM
552: pn_var_periods_all
553: WHERE
554: var_rent_id = p_vr_id AND
555: NVL(status, 'A') <> pn_var_rent_calc_pkg.G_PERIOD_REVERSED_STATUS;
556:

Line 563: pn_var_periods_all prd,

559: SELECT
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

Line 576: pn_var_periods_all prd,

572: SELECT
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

Line 1629: FROM pn_var_periods_all

1625:
1626: -- Get the details of
1627: CURSOR first_period_cur IS
1628: SELECT period_id
1629: FROM pn_var_periods_all
1630: WHERE var_rent_id = p_var_rent_id
1631: AND period_num = 1;
1632:
1633: l_period_id NUMBER;

Line 1849: FROM pn_var_periods_all

1845:
1846: -- Get the details of
1847: CURSOR first_period_cur(p_vr_id IN NUMBER) IS
1848: SELECT period_id
1849: FROM pn_var_periods_all
1850: WHERE var_rent_id = p_vr_id
1851: AND period_num = 1;
1852:
1853: l_org_id NUMBER;

Line 2221: FROM pn_var_periods_all

2217: calc_prd_end_date >= (ADD_MONTHS(p_vr_term_date, -12) + 1);
2218:
2219: CURSOR last_period_cur(p_vr_id IN NUMBER, p_termination_date DATE) IS
2220: SELECT period_id
2221: FROM pn_var_periods_all
2222: WHERE var_rent_id = p_vr_id
2223: AND end_date = p_termination_date
2224: AND partial_period='Y'; -- bug # 5937807
2225:

Line 2593: FROM pn_var_periods_all per, pn_var_constraints_all cons

2589: Cursor csr_get_constr(p_period_id NUMBER) is
2590: SELECT TYPE_code,
2591: amount,
2592: cons.constr_start_date const
2593: FROM pn_var_periods_all per, pn_var_constraints_all cons
2594: WHERE per.var_rent_id = (select var_rent_id from pn_var_periods_all where period_id=p_period_id)
2595: AND per.period_id = cons.period_id
2596: AND cons.constr_start_date=(select
2597: MAX(const1.constr_start_date) from pn_var_constraints_all const1

Line 2594: WHERE per.var_rent_id = (select var_rent_id from pn_var_periods_all where period_id=p_period_id)

2590: SELECT TYPE_code,
2591: amount,
2592: cons.constr_start_date const
2593: FROM pn_var_periods_all per, pn_var_constraints_all cons
2594: WHERE per.var_rent_id = (select var_rent_id from pn_var_periods_all where period_id=p_period_id)
2595: AND per.period_id = cons.period_id
2596: AND cons.constr_start_date=(select
2597: MAX(const1.constr_start_date) from pn_var_constraints_all const1
2598: where const1.period_id = cons.period_id)

Line 3072: FROM pn_var_periods_all

3068: SELECT MAX(invoice_date) inv_date
3069: FROM pn_var_grp_dates_all
3070: WHERE var_rent_id = p_var_rent_id
3071: AND period_id = (SELECT max(period_id)
3072: FROM pn_var_periods_all
3073: WHERE var_rent_id = p_var_rent_id
3074: AND NVL(status, pn_var_rent_calc_pkg.G_PERIOD_ACTIVE_STATUS)
3075: <> pn_var_rent_calc_pkg.G_PERIOD_REVERSED_STATUS);
3076:

Line 3219: FROM pn_var_periods_all

3215: SELECT MAX(invoice_date) inv_date
3216: FROM pn_var_grp_dates_all
3217: WHERE var_rent_id = p_var_rent_id
3218: AND period_id = (SELECT max(period_id)
3219: FROM pn_var_periods_all
3220: WHERE var_rent_id = p_var_rent_id
3221: AND NVL(status, pn_var_rent_calc_pkg.G_PERIOD_ACTIVE_STATUS)
3222: <> pn_var_rent_calc_pkg.G_PERIOD_REVERSED_STATUS);
3223:

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 3358: AND per.start_date = (SELECT MIN(start_date) from pn_var_periods_all

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);
3360: -- Get the id of last invoice created.
3361: -- This has meaning only if proration is LY/FLY
3362: CURSOR get_ly_inv_c(ip_var_rent_id NUMBER

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 3368: AND per.start_date = (SELECT MAX(start_date) from pn_var_periods_all

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)
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:

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 3403: pn_var_periods_all per,

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
3407: AND per.start_date = (select max(start_date) from pn_var_periods_all per1

Line 3407: AND per.start_date = (select max(start_date) from pn_var_periods_all per1

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)
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;

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 3619: AND per.start_date = (SELECT MIN(start_date) from pn_var_periods_all

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);
3621: -- Get the id of last invoice created.
3622: -- This has meaning only if proration is LY/FLY
3623: CURSOR get_ly_inv_c(ip_var_rent_id NUMBER

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 3629: AND per.start_date = (SELECT MAX(start_date) from pn_var_periods_all

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)
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:

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 3777: AND per.start_date = (SELECT MIN(start_date) from pn_var_periods_all

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);
3779: -- Get the id of last invoice created.
3780: -- This has meaning only if proration is LY/FLY
3781: CURSOR get_ly_inv_c(ip_var_rent_id NUMBER

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 3787: AND per.start_date = (SELECT MAX(start_date) from pn_var_periods_all

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);
3789: -- Get the proration type
3790: CURSOR proration_type_c(ip_var_rent_id NUMBER
3791: ) IS

Line 3928: pn_var_periods_all

3924: ,start_date
3925: ,end_date
3926: ,partial_period
3927: FROM
3928: pn_var_periods_all
3929: WHERE
3930: var_rent_id = p_vr_id AND
3931: NVL(status, pn_var_rent_calc_pkg.G_PERIOD_ACTIVE_STATUS)
3932: <> pn_var_rent_calc_pkg.G_PERIOD_REVERSED_STATUS

Line 3945: pn_var_periods_all

3941: ,start_date
3942: ,end_date
3943: ,partial_period
3944: FROM
3945: pn_var_periods_all
3946: WHERE
3947: var_rent_id = p_vr_id AND
3948: period_id = p_prd_id
3949: /*Bug#6849764

Line 3951: FROM pn_var_periods_all

3947: var_rent_id = p_vr_id AND
3948: period_id = p_prd_id
3949: /*Bug#6849764
3950: start_date >= (SELECT start_date
3951: FROM pn_var_periods_all
3952: WHERE period_id = p_prd_id)
3953: Bug#6849764*/
3954: ORDER BY
3955: start_date;

Line 3966: pn_var_periods_all

3962: ,start_date
3963: ,end_date
3964: ,partial_period
3965: FROM
3966: pn_var_periods_all
3967: WHERE
3968: var_rent_id = p_vr_id AND
3969: NVL(status, pn_var_rent_calc_pkg.G_PERIOD_ACTIVE_STATUS)
3970: <> pn_var_rent_calc_pkg.G_PERIOD_REVERSED_STATUS AND

Line 3972: FROM pn_var_periods_all

3968: var_rent_id = p_vr_id AND
3969: NVL(status, pn_var_rent_calc_pkg.G_PERIOD_ACTIVE_STATUS)
3970: <> pn_var_rent_calc_pkg.G_PERIOD_REVERSED_STATUS AND
3971: start_date < (SELECT start_date
3972: FROM pn_var_periods_all
3973: WHERE period_id = p_prd_id)
3974: ORDER BY
3975: start_date;
3976:

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 3990: FROM pn_var_periods_all

3986:
3987: -- Get first partial period id
3988: CURSOR check_fst_partial_prd(p_var_rent_id IN NUMBER) IS
3989: SELECT period_id
3990: FROM pn_var_periods_all
3991: WHERE var_rent_id=p_var_rent_id
3992: AND period_num=1
3993: AND partial_period='Y';
3994:

Line 5149: pn_var_periods_all

5145: CURSOR period_num_c ( p_vr_id IN NUMBER) IS
5146: SELECT
5147: count(period_id) perion_num
5148: FROM
5149: pn_var_periods_all
5150: WHERE
5151: var_rent_id = p_vr_id AND
5152: NVL(status, 'A') <> pn_var_rent_calc_pkg.G_PERIOD_REVERSED_STATUS;
5153:

Line 5160: pn_var_periods_all prd,

5156: SELECT
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

Line 5173: pn_var_periods_all prd,

5169: SELECT
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

Line 5718: FROM pn_var_periods_all

5714: AND inv_start_date = p_inv_start_date;
5715:
5716: CURSOR period_cur IS
5717: SELECT period_id, end_date
5718: FROM pn_var_periods_all
5719: WHERE var_rent_id = vr_id
5720: AND partial_period = 'Y'
5721: AND period_num = 1;
5722:

Line 5727: FROM pn_var_periods_all

5723: CURSOR last_period_cur IS
5724: SELECT period_id,
5725: end_date,
5726: decode(status,'REVERSED','Y','N') status
5727: FROM pn_var_periods_all
5728: WHERE var_rent_id = vr_id
5729: AND period_id = p_period_id;
5730:
5731: BEGIN

Line 5807: FROM pn_var_periods_all

5803:
5804:
5805: CURSOR period_cur IS
5806: SELECT period_id, start_date
5807: FROM pn_var_periods_all
5808: WHERE var_rent_id = vr_id
5809: AND partial_period = 'Y'
5810: AND period_num = 1;
5811:

Line 5814: FROM pn_var_periods_all

5810: AND period_num = 1;
5811:
5812: CURSOR period_last_cur IS
5813: SELECT period_id, start_date
5814: FROM pn_var_periods_all
5815: WHERE var_rent_id = vr_id
5816: AND partial_period = 'Y';
5817:
5818:

Line 5902: FROM pn_var_periods_all

5898:
5899: CURSOR last_period_cur IS
5900: SELECT period_id,
5901: decode(status,'REVERSED','Y','N') status
5902: FROM pn_var_periods_all
5903: WHERE var_rent_id = vr_id
5904: AND period_id = p_period_id;
5905:
5906: CURSOR period_cur IS

Line 5908: FROM pn_var_periods_all

5904: AND period_id = p_period_id;
5905:
5906: CURSOR period_cur IS
5907: SELECT period_id, start_date
5908: FROM pn_var_periods_all
5909: WHERE var_rent_id = vr_id
5910: AND partial_period = 'Y'
5911: AND period_num = 1;
5912:

Line 6192: ,pn_var_periods_all prd

6188: ,grp.invoice_date
6189: ,grp.org_id
6190: FROM
6191: pn_var_grp_dates_all grp
6192: ,pn_var_periods_all prd
6193: WHERE
6194: prd.var_rent_id = p_vr_id AND
6195: prd.period_id = p_prd_id AND
6196: grp.period_id = prd.period_id AND

Line 6495: FROM pn_var_periods_all

6491: SELECT period_id,
6492: period_num,
6493: start_date,
6494: end_date
6495: FROM pn_var_periods_all
6496: WHERE var_rent_id = ip_var_rent_id
6497: AND period_id = NVL(p_period_id,period_id)
6498: AND start_date <= NVL(fnd_date.canonical_to_date(p_period_date),TO_DATE('12/31/4712','mm/dd/yyyy'))
6499: AND period_num >= NVL(p_period_num_from,period_num)

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 8890: (SELECT period_id FROM pn_var_periods_all vp

8886: CURSOR get_fst_prd_flag(p_vrent_id IN NUMBER,p_status IN VARCHAR2) IS
8887: SELECT 'Y' fst_prd_flag
8888: FROM dual
8889: WHERE EXISTS
8890: (SELECT period_id FROM pn_var_periods_all vp
8891: WHERE period_num=1
8892: AND var_rent_id=p_vrent_id
8893: AND partial_period='Y'
8894: AND EXISTS (select NULL from pn_var_vol_hist_all vol

Line 8910: pn_var_periods_all vp,

8906: CURSOR get_partial_prd_inv_dates(p_vrent_id IN NUMBER,p_status IN VARCHAR2)
8907: IS
8908: SELECT distinct gd1.invoice_date ,gd1.period_id, decode(temp.inv_dt,NULL,'N','Y')
8909: FROM pn_var_grp_dates_all gd1,
8910: pn_var_periods_all vp,
8911: (SELECT gd.invoice_date inv_dt
8912: FROM pn_var_grp_dates_all gd
8913: WHERE EXISTS(select NULL from pn_var_vol_hist_all vol
8914: where vol_hist_status_code = p_status

Line 9032: FROM pn_var_periods_all

9028: SELECT var_rent_inv_id
9029: FROM pn_var_rent_inv_all
9030: WHERE var_rent_id=p_var_rent_id
9031: AND period_id IN (SELECT period_id
9032: FROM pn_var_periods_all
9033: WHERE period_num=1
9034: AND var_rent_id=p_var_rent_id
9035: AND partial_period='Y'
9036: )

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 9554: FROM pn_var_periods_all

9550: SELECT var_rent_inv_id
9551: FROM pn_var_rent_inv_all
9552: WHERE var_rent_id=p_var_rent_id
9553: AND period_id IN (SELECT period_id
9554: FROM pn_var_periods_all
9555: WHERE period_num=1
9556: AND var_rent_id=p_var_rent_id
9557: AND partial_period='Y')
9558: AND adjust_num=0;

Line 9789: ,pn_var_periods_all prd

9785: ,grp.invoice_date
9786: ,grp.org_id
9787: FROM
9788: pn_var_grp_dates_all grp
9789: ,pn_var_periods_all prd
9790: WHERE
9791: prd.var_rent_id = p_vr_id AND
9792: prd.period_id = p_prd_id AND
9793: grp.period_id = prd.period_id AND

Line 10193: FROM pn_var_periods_all

10189: AND gd.grp_date_id = p_grp_dt_id;
10190:
10191: CURSOR period_cur(vr_id IN NUMBER) IS
10192: SELECT period_id, start_date
10193: FROM pn_var_periods_all
10194: WHERE var_rent_id = vr_id
10195: AND partial_period = 'Y'
10196: AND period_num = 1;
10197:

Line 10284: FROM pn_var_periods_all

10280:
10281: CURSOR period_cur(vr_id IN NUMBER)
10282: IS
10283: SELECT period_id, start_date
10284: FROM pn_var_periods_all
10285: WHERE var_rent_id = vr_id
10286: AND partial_period = 'Y'
10287: AND period_num = 1;
10288:

Line 10600: FROM pn_var_periods_all

10596:
10597: /* get the number of periods */
10598: CURSOR period_num_c ( p_vr_id IN NUMBER, term_date DATE) IS
10599: SELECT count(*) period_num
10600: FROM pn_var_periods_all
10601: WHERE var_rent_id = p_vr_id
10602: AND term_date > start_date;
10603:
10604: /* verify if last period for variable rent agreement is partial */

Line 10607: FROM pn_var_periods_all

10603:
10604: /* verify if last period for variable rent agreement is partial */
10605: CURSOR last_period_c (p_vr_id NUMBER, p_new_term_date DATE) IS
10606: SELECT period_id
10607: FROM pn_var_periods_all
10608: WHERE var_rent_id = p_vr_id
10609: AND p_new_term_date BETWEEN start_date AND end_date
10610: AND partial_period = 'Y';
10611:

Line 10618: pn_var_periods_all prd,

10614: SELECT
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

Line 10782: FROM pn_var_periods_all

10778: IS
10779:
10780: CURSOR get_period_dtls_csr IS
10781: SELECT period_num,var_rent_id
10782: FROM pn_var_periods_all
10783: WHERE period_id = p_period_id;
10784:
10785: CURSOR get_blended_bkpt_csr(p_var_rent_id IN NUMBER) IS
10786: SELECT sum(pr_grp_blended_vol_start) bkpt_start,