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 3926: pn_var_periods_all

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

Line 3943: pn_var_periods_all

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

Line 3949: FROM pn_var_periods_all

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

Line 3964: pn_var_periods_all

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

Line 3970: FROM pn_var_periods_all

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

Line 3980: FROM pn_var_periods_all pvp, pn_var_rents_all pvr

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

Line 3988: FROM pn_var_periods_all

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

Line 5060: pn_var_periods_all

5056: CURSOR period_num_c ( p_vr_id IN NUMBER) IS
5057: SELECT
5058: count(period_id) perion_num
5059: FROM
5060: pn_var_periods_all
5061: WHERE
5062: var_rent_id = p_vr_id AND
5063: NVL(status, 'A') <> pn_var_rent_calc_pkg.G_PERIOD_REVERSED_STATUS;
5064:

Line 5071: pn_var_periods_all prd,

5067: SELECT
5068: prd.period_id
5069: ,prd.partial_period
5070: FROM
5071: pn_var_periods_all prd,
5072: pn_var_rents_all var
5073: WHERE
5074: prd.var_rent_id = p_vr_id AND
5075: prd.var_rent_id = var.var_rent_id AND

Line 5084: pn_var_periods_all prd,

5080: SELECT
5081: prd.period_id
5082: ,prd.partial_period
5083: FROM
5084: pn_var_periods_all prd,
5085: pn_var_rents_all var
5086: WHERE
5087: prd.var_rent_id = p_vr_id AND
5088: prd.var_rent_id = var.var_rent_id AND

Line 5629: FROM pn_var_periods_all

5625: AND inv_start_date = p_inv_start_date;
5626:
5627: CURSOR period_cur IS
5628: SELECT period_id, end_date
5629: FROM pn_var_periods_all
5630: WHERE var_rent_id = vr_id
5631: AND partial_period = 'Y'
5632: AND period_num = 1;
5633:

Line 5638: FROM pn_var_periods_all

5634: CURSOR last_period_cur IS
5635: SELECT period_id,
5636: end_date,
5637: decode(status,'REVERSED','Y','N') status
5638: FROM pn_var_periods_all
5639: WHERE var_rent_id = vr_id
5640: AND period_id = p_period_id;
5641:
5642: BEGIN

Line 5718: FROM pn_var_periods_all

5714:
5715:
5716: CURSOR period_cur IS
5717: SELECT period_id, start_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 5725: FROM pn_var_periods_all

5721: AND period_num = 1;
5722:
5723: CURSOR period_last_cur IS
5724: SELECT period_id, start_date
5725: FROM pn_var_periods_all
5726: WHERE var_rent_id = vr_id
5727: AND partial_period = 'Y';
5728:
5729:

Line 5813: FROM pn_var_periods_all

5809:
5810: CURSOR last_period_cur IS
5811: SELECT period_id,
5812: decode(status,'REVERSED','Y','N') status
5813: FROM pn_var_periods_all
5814: WHERE var_rent_id = vr_id
5815: AND period_id = p_period_id;
5816:
5817: CURSOR period_cur IS

Line 5819: FROM pn_var_periods_all

5815: AND period_id = p_period_id;
5816:
5817: CURSOR period_cur IS
5818: SELECT period_id, start_date
5819: FROM pn_var_periods_all
5820: WHERE var_rent_id = vr_id
5821: AND partial_period = 'Y'
5822: AND period_num = 1;
5823:

Line 6103: ,pn_var_periods_all prd

6099: ,grp.invoice_date
6100: ,grp.org_id
6101: FROM
6102: pn_var_grp_dates_all grp
6103: ,pn_var_periods_all prd
6104: WHERE
6105: prd.var_rent_id = p_vr_id AND
6106: prd.period_id = p_prd_id AND
6107: grp.period_id = prd.period_id AND

Line 6453: FROM pn_var_periods_all

6449: SELECT period_id,
6450: period_num,
6451: start_date,
6452: end_date
6453: FROM pn_var_periods_all
6454: WHERE var_rent_id = ip_var_rent_id
6455: AND period_id = NVL(p_period_id,period_id)
6456: AND start_date <= NVL(fnd_date.canonical_to_date(p_period_date),TO_DATE('12/31/4712','mm/dd/yyyy'))
6457: AND period_num >= NVL(p_period_num_from,period_num)

Line 6825: FROM pn_var_periods_all pvp, pn_var_rents_all pvr

6821:
6822: -- Get the details of
6823: CURSOR first_period_cur (p_var_rent_id NUMBER, p_period_id NUMBER) IS
6824: SELECT pvp.period_id, pvr.commencement_date
6825: FROM pn_var_periods_all pvp, pn_var_rents_all pvr
6826: WHERE pvr.var_rent_id = p_var_rent_id
6827: AND pvp.period_id = p_period_id
6828: AND pvp.partial_period = 'Y'
6829: AND pvp.start_date = pvr.commencement_date;

Line 6835: FROM pn_var_periods_all pvp, pn_var_rents_all pvr

6831:
6832: -- Get the details of
6833: CURSOR last_period_cur (p_var_rent_id NUMBER, p_period_id NUMBER) IS
6834: SELECT pvp.period_id, pvr.termination_date
6835: FROM pn_var_periods_all pvp, pn_var_rents_all pvr
6836: WHERE pvr.var_rent_id = p_var_rent_id
6837: AND pvp.period_id = p_period_id
6838: AND pvp.partial_period = 'Y'
6839: AND pvp.end_date = pvr.termination_date;

Line 6929: FROM pn_var_periods_all pvp, pn_var_rents_all pvr

6925:
6926: -- Get the details of
6927: CURSOR first_period_cur (p_var_rent_id NUMBER, p_period_id NUMBER) IS
6928: SELECT pvp.period_id, pvr.commencement_date
6929: FROM pn_var_periods_all pvp, pn_var_rents_all pvr
6930: WHERE pvr.var_rent_id = p_var_rent_id
6931: AND pvp.period_id = p_period_id
6932: AND pvp.partial_period = 'Y'
6933: AND pvp.start_date = pvr.commencement_date;

Line 6939: FROM pn_var_periods_all pvp, pn_var_rents_all pvr

6935:
6936: -- Get the details of
6937: CURSOR last_period_cur (p_var_rent_id NUMBER, p_period_id NUMBER) IS
6938: SELECT pvp.period_id, pvr.termination_date
6939: FROM pn_var_periods_all pvp, pn_var_rents_all pvr
6940: WHERE pvr.var_rent_id = p_var_rent_id
6941: AND pvp.period_id = p_period_id
6942: AND pvp.partial_period = 'Y'
6943: AND pvp.end_date = pvr.termination_date;

Line 7051: FROM pn_var_periods_all pvp, pn_var_rents_all pvr

7047:
7048: -- Get the details of
7049: CURSOR first_period_cur (p_var_rent_id NUMBER, p_period_id NUMBER) IS
7050: SELECT pvp.period_id, pvr.commencement_date
7051: FROM pn_var_periods_all pvp, pn_var_rents_all pvr
7052: WHERE pvr.var_rent_id = p_var_rent_id
7053: AND pvp.period_id = p_period_id
7054: AND pvp.partial_period = 'Y'
7055: AND pvp.start_date = pvr.commencement_date;

Line 7061: FROM pn_var_periods_all pvp, pn_var_rents_all pvr

7057:
7058: -- Get the details of
7059: CURSOR last_period_cur (p_var_rent_id NUMBER, p_period_id NUMBER) IS
7060: SELECT pvp.period_id, pvr.termination_date
7061: FROM pn_var_periods_all pvp, pn_var_rents_all pvr
7062: WHERE pvr.var_rent_id = p_var_rent_id
7063: AND pvp.period_id = p_period_id
7064: AND pvp.partial_period = 'Y'
7065: AND pvp.end_date = pvr.termination_date;

Line 7312: FROM pn_var_periods_all pvp, pn_var_rents_all pvr

7308:
7309: -- Get the details of
7310: CURSOR first_period_cur (p_var_rent_id NUMBER, p_period_id NUMBER) IS
7311: SELECT pvp.period_id, pvr.commencement_date
7312: FROM pn_var_periods_all pvp, pn_var_rents_all pvr
7313: WHERE pvr.var_rent_id = p_var_rent_id
7314: AND pvp.period_id = p_period_id
7315: AND pvp.partial_period = 'Y'
7316: AND pvp.start_date = pvr.commencement_date;

Line 7322: FROM pn_var_periods_all pvp, pn_var_rents_all pvr

7318:
7319: -- Get the details of
7320: CURSOR last_period_cur (p_var_rent_id NUMBER, p_period_id NUMBER) IS
7321: SELECT pvp.period_id, pvr.termination_date
7322: FROM pn_var_periods_all pvp, pn_var_rents_all pvr
7323: WHERE pvr.var_rent_id = p_var_rent_id
7324: AND pvp.period_id = p_period_id
7325: AND pvp.partial_period = 'Y'
7326: AND pvp.end_date = pvr.termination_date;

Line 7446: FROM pn_var_periods_all pvp, pn_var_rents_all pvr

7442:
7443: -- Get the details of
7444: CURSOR first_period_cur (p_var_rent_id NUMBER, p_period_id NUMBER) IS
7445: SELECT pvp.period_id, pvr.commencement_date
7446: FROM pn_var_periods_all pvp, pn_var_rents_all pvr
7447: WHERE pvr.var_rent_id = p_var_rent_id
7448: AND pvp.period_id = p_period_id
7449: AND pvp.partial_period = 'Y'
7450: AND pvp.start_date = pvr.commencement_date;

Line 7456: FROM pn_var_periods_all pvp, pn_var_rents_all pvr

7452:
7453: -- Get the details of
7454: CURSOR last_period_cur (p_var_rent_id NUMBER, p_period_id NUMBER) IS
7455: SELECT pvp.period_id, pvr.termination_date
7456: FROM pn_var_periods_all pvp, pn_var_rents_all pvr
7457: WHERE pvr.var_rent_id = p_var_rent_id
7458: AND pvp.period_id = p_period_id
7459: AND pvp.partial_period = 'Y'
7460: AND pvp.end_date = pvr.termination_date;

Line 7555: FROM pn_var_periods_all pvp, pn_var_rents_all pvr

7551:
7552: -- Get the details of
7553: CURSOR first_period_cur (p_var_rent_id NUMBER, p_period_id NUMBER) IS
7554: SELECT pvp.period_id, pvr.commencement_date
7555: FROM pn_var_periods_all pvp, pn_var_rents_all pvr
7556: WHERE pvr.var_rent_id = p_var_rent_id
7557: AND pvp.period_id = p_period_id
7558: AND pvp.partial_period = 'Y'
7559: AND pvp.start_date = pvr.commencement_date;

Line 7565: FROM pn_var_periods_all pvp, pn_var_rents_all pvr

7561:
7562: -- Get the details of
7563: CURSOR last_period_cur (p_var_rent_id NUMBER, p_period_id NUMBER) IS
7564: SELECT pvp.period_id, pvr.termination_date
7565: FROM pn_var_periods_all pvp, pn_var_rents_all pvr
7566: WHERE pvr.var_rent_id = p_var_rent_id
7567: AND pvp.period_id = p_period_id
7568: AND pvp.partial_period = 'Y'
7569: AND pvp.end_date = pvr.termination_date;

Line 7688: FROM pn_var_periods_all pvp, pn_var_rents_all pvr

7684:
7685: -- Get the details of
7686: CURSOR first_period_cur (p_var_rent_id NUMBER, p_period_id NUMBER) IS
7687: SELECT pvp.period_id, pvr.commencement_date
7688: FROM pn_var_periods_all pvp, pn_var_rents_all pvr
7689: WHERE pvr.var_rent_id = p_var_rent_id
7690: AND pvp.period_id = p_period_id
7691: AND pvp.partial_period = 'Y'
7692: AND pvp.start_date = pvr.commencement_date;

Line 7698: FROM pn_var_periods_all pvp, pn_var_rents_all pvr

7694:
7695: -- Get the details of
7696: CURSOR last_period_cur (p_var_rent_id NUMBER, p_period_id NUMBER) IS
7697: SELECT pvp.period_id, pvr.termination_date
7698: FROM pn_var_periods_all pvp, pn_var_rents_all pvr
7699: WHERE pvr.var_rent_id = p_var_rent_id
7700: AND pvp.period_id = p_period_id
7701: AND pvp.partial_period = 'Y'
7702: AND pvp.end_date = pvr.termination_date;

Line 7812: FROM pn_var_periods_all pvp, pn_var_rents_all pvr

7808:
7809: -- Get the details of
7810: CURSOR first_period_cur (p_var_rent_id NUMBER, p_period_id NUMBER) IS
7811: SELECT pvp.period_id, pvr.commencement_date
7812: FROM pn_var_periods_all pvp, pn_var_rents_all pvr
7813: WHERE pvr.var_rent_id = p_var_rent_id
7814: AND pvp.period_id = p_period_id
7815: AND pvp.partial_period = 'Y'
7816: AND pvp.start_date = pvr.commencement_date;

Line 7822: FROM pn_var_periods_all pvp, pn_var_rents_all pvr

7818:
7819: -- Get the details of
7820: CURSOR last_period_cur (p_var_rent_id NUMBER, p_period_id NUMBER) IS
7821: SELECT pvp.period_id, pvr.termination_date
7822: FROM pn_var_periods_all pvp, pn_var_rents_all pvr
7823: WHERE pvr.var_rent_id = p_var_rent_id
7824: AND pvp.period_id = p_period_id
7825: AND pvp.partial_period = 'Y'
7826: AND pvp.end_date = pvr.termination_date;

Line 7955: FROM pn_var_periods_all pvp, pn_var_rents_all pvr

7951:
7952: -- Get the details of
7953: CURSOR first_period_cur (p_var_rent_id NUMBER, p_period_id NUMBER) IS
7954: SELECT pvp.period_id, pvr.commencement_date
7955: FROM pn_var_periods_all pvp, pn_var_rents_all pvr
7956: WHERE pvr.var_rent_id = p_var_rent_id
7957: AND pvp.period_id = p_period_id
7958: AND pvp.partial_period = 'Y'
7959: AND pvp.start_date = pvr.commencement_date;

Line 7965: FROM pn_var_periods_all pvp, pn_var_rents_all pvr

7961:
7962: -- Get the details of
7963: CURSOR last_period_cur (p_var_rent_id NUMBER, p_period_id NUMBER) IS
7964: SELECT pvp.period_id, pvr.termination_date
7965: FROM pn_var_periods_all pvp, pn_var_rents_all pvr
7966: WHERE pvr.var_rent_id = p_var_rent_id
7967: AND pvp.period_id = p_period_id
7968: AND pvp.partial_period = 'Y'
7969: AND pvp.end_date = pvr.termination_date;

Line 8101: FROM pn_var_periods_all pvp, pn_var_rents_all pvr

8097:
8098: -- Get the details of
8099: CURSOR first_period_cur (p_var_rent_id NUMBER, p_period_id NUMBER) IS
8100: SELECT pvp.period_id, pvr.commencement_date
8101: FROM pn_var_periods_all pvp, pn_var_rents_all pvr
8102: WHERE pvr.var_rent_id = p_var_rent_id
8103: AND pvp.period_id = p_period_id
8104: AND pvp.partial_period = 'Y'
8105: AND pvp.start_date = pvr.commencement_date;

Line 8111: FROM pn_var_periods_all pvp, pn_var_rents_all pvr

8107:
8108: -- Get the details of
8109: CURSOR last_period_cur (p_var_rent_id NUMBER, p_period_id NUMBER) IS
8110: SELECT pvp.period_id, pvr.termination_date
8111: FROM pn_var_periods_all pvp, pn_var_rents_all pvr
8112: WHERE pvr.var_rent_id = p_var_rent_id
8113: AND pvp.period_id = p_period_id
8114: AND pvp.partial_period = 'Y'
8115: AND pvp.end_date = pvr.termination_date;

Line 8209: FROM pn_var_periods_all pvp, pn_var_rents_all pvr

8205:
8206: -- Get the details of
8207: CURSOR first_period_cur (p_var_rent_id NUMBER, p_period_id NUMBER) IS
8208: SELECT pvp.period_id, pvr.commencement_date
8209: FROM pn_var_periods_all pvp, pn_var_rents_all pvr
8210: WHERE pvr.var_rent_id = p_var_rent_id
8211: AND pvp.period_id = p_period_id
8212: AND pvp.partial_period = 'Y'
8213: AND pvp.start_date = pvr.commencement_date;

Line 8219: FROM pn_var_periods_all pvp, pn_var_rents_all pvr

8215:
8216: -- Get the details of
8217: CURSOR last_period_cur (p_var_rent_id NUMBER, p_period_id NUMBER) IS
8218: SELECT pvp.period_id, pvr.termination_date
8219: FROM pn_var_periods_all pvp, pn_var_rents_all pvr
8220: WHERE pvr.var_rent_id = p_var_rent_id
8221: AND pvp.period_id = p_period_id
8222: AND pvp.partial_period = 'Y'
8223: AND pvp.end_date = pvr.termination_date;

Line 8317: FROM pn_var_periods_all pvp, pn_var_rents_all pvr

8313:
8314: -- Get the details of
8315: CURSOR first_period_cur (p_var_rent_id NUMBER, p_period_id NUMBER) IS
8316: SELECT pvp.period_id, pvr.commencement_date
8317: FROM pn_var_periods_all pvp, pn_var_rents_all pvr
8318: WHERE pvr.var_rent_id = p_var_rent_id
8319: AND pvp.period_id = p_period_id
8320: AND pvp.partial_period = 'Y'
8321: AND pvp.start_date = pvr.commencement_date;

Line 8326: FROM pn_var_periods_all pvp, pn_var_rents_all pvr

8322:
8323: -- Get the details of
8324: CURSOR last_period_cur (p_var_rent_id NUMBER, p_period_id NUMBER) IS
8325: SELECT pvp.period_id, pvr.termination_date
8326: FROM pn_var_periods_all pvp, pn_var_rents_all pvr
8327: WHERE pvr.var_rent_id = p_var_rent_id
8328: AND pvp.period_id = p_period_id
8329: AND pvp.partial_period = 'Y'
8330: AND pvp.end_date = pvr.termination_date;

Line 8417: FROM pn_var_periods_all pvp, pn_var_rents_all pvr

8413:
8414: -- Get the details of
8415: CURSOR first_period_cur (p_var_rent_id NUMBER, p_period_id NUMBER) IS
8416: SELECT pvp.period_id, pvr.commencement_date
8417: FROM pn_var_periods_all pvp, pn_var_rents_all pvr
8418: WHERE pvr.var_rent_id = p_var_rent_id
8419: AND pvp.period_id = p_period_id
8420: AND pvp.partial_period = 'Y'
8421: AND pvp.start_date = pvr.commencement_date;

Line 8426: FROM pn_var_periods_all pvp, pn_var_rents_all pvr

8422:
8423: -- Get the details of
8424: CURSOR last_period_cur (p_var_rent_id NUMBER, p_period_id NUMBER) IS
8425: SELECT pvp.period_id, pvr.termination_date
8426: FROM pn_var_periods_all pvp, pn_var_rents_all pvr
8427: WHERE pvr.var_rent_id = p_var_rent_id
8428: AND pvp.period_id = p_period_id
8429: AND pvp.partial_period = 'Y'
8430: AND pvp.end_date = pvr.termination_date;

Line 8835: (SELECT period_id FROM pn_var_periods_all vp

8831: CURSOR get_fst_prd_flag(p_vrent_id IN NUMBER,p_status IN VARCHAR2) IS
8832: SELECT 'Y' fst_prd_flag
8833: FROM dual
8834: WHERE EXISTS
8835: (SELECT period_id FROM pn_var_periods_all vp
8836: WHERE period_num=1
8837: AND var_rent_id=p_vrent_id
8838: AND partial_period='Y'
8839: AND EXISTS (select NULL from pn_var_vol_hist_all vol

Line 8855: pn_var_periods_all vp,

8851: CURSOR get_partial_prd_inv_dates(p_vrent_id IN NUMBER,p_status IN VARCHAR2)
8852: IS
8853: SELECT distinct gd1.invoice_date ,gd1.period_id, decode(temp.inv_dt,NULL,'N','Y')
8854: FROM pn_var_grp_dates_all gd1,
8855: pn_var_periods_all vp,
8856: (SELECT gd.invoice_date inv_dt
8857: FROM pn_var_grp_dates_all gd
8858: WHERE EXISTS(select NULL from pn_var_vol_hist_all vol
8859: where vol_hist_status_code = p_status

Line 8977: FROM pn_var_periods_all

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
8979: AND var_rent_id=p_var_rent_id
8980: AND partial_period='Y'
8981: )

Line 9101: FROM pn_var_periods_all prd ,pn_var_rents_all vrent

9097:
9098: -- Get the last partial period id
9099: CURSOR get_last_partial_prd(p_var_rent_id IN NUMBER) IS
9100: SELECT prd.period_id
9101: FROM pn_var_periods_all prd ,pn_var_rents_all vrent
9102: WHERE prd.var_rent_id=p_var_rent_id
9103: AND vrent.var_rent_id = prd.var_rent_id
9104: AND prd.end_date = vrent.termination_date
9105: AND partial_period='Y';

Line 9499: FROM pn_var_periods_all

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
9501: AND var_rent_id=p_var_rent_id
9502: AND partial_period='Y')
9503: AND adjust_num=0;

Line 9734: ,pn_var_periods_all prd

9730: ,grp.invoice_date
9731: ,grp.org_id
9732: FROM
9733: pn_var_grp_dates_all grp
9734: ,pn_var_periods_all prd
9735: WHERE
9736: prd.var_rent_id = p_vr_id AND
9737: prd.period_id = p_prd_id AND
9738: grp.period_id = prd.period_id AND

Line 10138: FROM pn_var_periods_all

10134: AND gd.grp_date_id = p_grp_dt_id;
10135:
10136: CURSOR period_cur(vr_id IN NUMBER) IS
10137: SELECT period_id, start_date
10138: FROM pn_var_periods_all
10139: WHERE var_rent_id = vr_id
10140: AND partial_period = 'Y'
10141: AND period_num = 1;
10142:

Line 10229: FROM pn_var_periods_all

10225:
10226: CURSOR period_cur(vr_id IN NUMBER)
10227: IS
10228: SELECT period_id, start_date
10229: FROM pn_var_periods_all
10230: WHERE var_rent_id = vr_id
10231: AND partial_period = 'Y'
10232: AND period_num = 1;
10233:

Line 10545: FROM pn_var_periods_all

10541:
10542: /* get the number of periods */
10543: CURSOR period_num_c ( p_vr_id IN NUMBER, term_date DATE) IS
10544: SELECT count(*) period_num
10545: FROM pn_var_periods_all
10546: WHERE var_rent_id = p_vr_id
10547: AND term_date > start_date;
10548:
10549: /* verify if last period for variable rent agreement is partial */

Line 10552: FROM pn_var_periods_all

10548:
10549: /* verify if last period for variable rent agreement is partial */
10550: CURSOR last_period_c (p_vr_id NUMBER, p_new_term_date DATE) IS
10551: SELECT period_id
10552: FROM pn_var_periods_all
10553: WHERE var_rent_id = p_vr_id
10554: AND p_new_term_date BETWEEN start_date AND end_date
10555: AND partial_period = 'Y';
10556:

Line 10563: pn_var_periods_all prd,

10559: SELECT
10560: prd.period_id
10561: ,prd.partial_period
10562: FROM
10563: pn_var_periods_all prd,
10564: pn_var_rents_all var
10565: WHERE
10566: prd.var_rent_id = p_vr_id AND
10567: prd.var_rent_id = var.var_rent_id AND

Line 10727: FROM pn_var_periods_all

10723: IS
10724:
10725: CURSOR get_period_dtls_csr IS
10726: SELECT period_num,var_rent_id
10727: FROM pn_var_periods_all
10728: WHERE period_id = p_period_id;
10729:
10730: CURSOR get_blended_bkpt_csr(p_var_rent_id IN NUMBER) IS
10731: SELECT sum(pr_grp_blended_vol_start) bkpt_start,