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.

[Home] [Help]

APPS.PN_VAR_TRX_PKG dependencies on PN_VAR_RENTS_ALL

Line 79: FROM pn_var_rents_all

75: RETURN VARCHAR2 IS
76:
77: CURSOR proration_rule_vr_c IS
78: SELECT proration_rule
79: FROM pn_var_rents_all
80: WHERE var_rent_id = p_var_rent_id;
81:
82: CURSOR proration_rule_prd_c IS
83: SELECT proration_rule

Line 84: FROM pn_var_rents_all vr

80: WHERE var_rent_id = p_var_rent_id;
81:
82: CURSOR proration_rule_prd_c IS
83: SELECT proration_rule
84: FROM pn_var_rents_all vr
85: ,pn_var_periods_all prd
86: WHERE vr.var_rent_id = prd.var_rent_id
87: AND prd.period_id = p_period_id;
88:

Line 655: pn_var_rents_all vr

651: ,vr.commencement_date
652: ,vr.termination_date
653: ,vr.proration_rule
654: FROM
655: pn_var_rents_all vr
656: WHERE
657: vr.var_rent_id = p_vr_id;
658:
659: /* trx header containing LY start date */

Line 842: pn_var_rents_all vr

838: ,vr.commencement_date
839: ,vr.termination_date
840: ,vr.proration_rule
841: FROM
842: pn_var_rents_all vr
843: WHERE
844: vr.var_rent_id = p_vr_id;
845:
846: /* get rates for trx header containing FY end date */

Line 1033: pn_var_rents_all vr

1029: ,vr.commencement_date
1030: ,vr.termination_date
1031: ,vr.proration_rule
1032: FROM
1033: pn_var_rents_all vr
1034: WHERE
1035: vr.var_rent_id = p_vr_id;
1036:
1037: /* VR info */

Line 1498: pn_var_rents_all vr

1494: ,vr.termination_date
1495: ,vr.proration_rule
1496: ,vr.cumulative_vol
1497: FROM
1498: pn_var_rents_all vr
1499: WHERE
1500: vr.var_rent_id = p_vr_id;
1501:
1502: l_proration_rule pn_var_rents_all.proration_rule%TYPE;

Line 1502: l_proration_rule pn_var_rents_all.proration_rule%TYPE;

1498: pn_var_rents_all vr
1499: WHERE
1500: vr.var_rent_id = p_vr_id;
1501:
1502: l_proration_rule pn_var_rents_all.proration_rule%TYPE;
1503:
1504: /* get the period details - we use the first 2 periods */
1505: CURSOR periods_c(p_vr_id IN NUMBER) IS
1506: SELECT

Line 1678: from pn_var_rents_all v, pn_var_bkhd_defaults_all hd,

1674: ,hdr.calc_prd_start_date;
1675:
1676: CURSOR rent_no_c1(p_vr_ID IN NUMBER) IS /* 9609370 */
1677: select distinct v.var_rent_id
1678: from pn_var_rents_all v, pn_var_bkhd_defaults_all hd,
1679: pn_var_bkdt_defaults_all dd
1680: WHERE V.VAR_RENT_ID = HD.VAR_RENT_ID
1681: and v.var_rent_id = p_vr_ID
1682: and hd.bkhd_default_id = dd.bkhd_default_id

Line 1883: pn_var_rents_all vr

1879: ,vr.termination_date
1880: ,vr.proration_rule
1881: ,vr.cumulative_vol
1882: FROM
1883: pn_var_rents_all vr
1884: WHERE
1885: vr.var_rent_id = p_vr_id;
1886:
1887: l_proration_rule pn_var_rents_all.proration_rule%TYPE;

Line 1887: l_proration_rule pn_var_rents_all.proration_rule%TYPE;

1883: pn_var_rents_all vr
1884: WHERE
1885: vr.var_rent_id = p_vr_id;
1886:
1887: l_proration_rule pn_var_rents_all.proration_rule%TYPE;
1888: l_calculation_method pn_var_rents_all.cumulative_vol%TYPE;
1889:
1890: /* get the period details - we use the first 2 periods for CYP, CYNP */
1891: CURSOR periods_c(p_vr_id IN NUMBER) IS

Line 1888: l_calculation_method pn_var_rents_all.cumulative_vol%TYPE;

1884: WHERE
1885: vr.var_rent_id = p_vr_id;
1886:
1887: l_proration_rule pn_var_rents_all.proration_rule%TYPE;
1888: l_calculation_method pn_var_rents_all.cumulative_vol%TYPE;
1889:
1890: /* get the period details - we use the first 2 periods for CYP, CYNP */
1891: CURSOR periods_c(p_vr_id IN NUMBER) IS
1892: SELECT

Line 1959: pn_var_rents_all var

1955: prd.period_id
1956: ,prd.partial_period
1957: FROM
1958: pn_var_periods_all prd,
1959: pn_var_rents_all var
1960: WHERE
1961: prd.period_id = p_period_id AND
1962: prd.var_rent_id = var.var_rent_id AND
1963: prd.end_date = var.termination_date AND

Line 2186: pn_var_rents_all vr

2182: ,vr.termination_date
2183: ,vr.proration_rule
2184: ,vr.cumulative_vol
2185: FROM
2186: pn_var_rents_all vr
2187: WHERE
2188: vr.var_rent_id = p_vr_id;
2189:
2190: /* variables for vr_c */

Line 2191: l_org_id pn_var_rents_all.org_id%TYPE;

2187: WHERE
2188: vr.var_rent_id = p_vr_id;
2189:
2190: /* variables for vr_c */
2191: l_org_id pn_var_rents_all.org_id%TYPE;
2192: l_vr_commencement_date pn_var_rents_all.commencement_date%TYPE;
2193: l_vr_termination_date pn_var_rents_all.termination_date%TYPE;
2194: l_proration_rule pn_var_rents_all.proration_rule%TYPE;
2195: l_calculation_method pn_var_rents_all.cumulative_vol%TYPE;

Line 2192: l_vr_commencement_date pn_var_rents_all.commencement_date%TYPE;

2188: vr.var_rent_id = p_vr_id;
2189:
2190: /* variables for vr_c */
2191: l_org_id pn_var_rents_all.org_id%TYPE;
2192: l_vr_commencement_date pn_var_rents_all.commencement_date%TYPE;
2193: l_vr_termination_date pn_var_rents_all.termination_date%TYPE;
2194: l_proration_rule pn_var_rents_all.proration_rule%TYPE;
2195: l_calculation_method pn_var_rents_all.cumulative_vol%TYPE;
2196:

Line 2193: l_vr_termination_date pn_var_rents_all.termination_date%TYPE;

2189:
2190: /* variables for vr_c */
2191: l_org_id pn_var_rents_all.org_id%TYPE;
2192: l_vr_commencement_date pn_var_rents_all.commencement_date%TYPE;
2193: l_vr_termination_date pn_var_rents_all.termination_date%TYPE;
2194: l_proration_rule pn_var_rents_all.proration_rule%TYPE;
2195: l_calculation_method pn_var_rents_all.cumulative_vol%TYPE;
2196:
2197: /* get the periods that do not exist anymore */

Line 2194: l_proration_rule pn_var_rents_all.proration_rule%TYPE;

2190: /* variables for vr_c */
2191: l_org_id pn_var_rents_all.org_id%TYPE;
2192: l_vr_commencement_date pn_var_rents_all.commencement_date%TYPE;
2193: l_vr_termination_date pn_var_rents_all.termination_date%TYPE;
2194: l_proration_rule pn_var_rents_all.proration_rule%TYPE;
2195: l_calculation_method pn_var_rents_all.cumulative_vol%TYPE;
2196:
2197: /* get the periods that do not exist anymore */
2198: CURSOR chk_for_del_prd_c(p_vr_id IN NUMBER) IS

Line 2195: l_calculation_method pn_var_rents_all.cumulative_vol%TYPE;

2191: l_org_id pn_var_rents_all.org_id%TYPE;
2192: l_vr_commencement_date pn_var_rents_all.commencement_date%TYPE;
2193: l_vr_termination_date pn_var_rents_all.termination_date%TYPE;
2194: l_proration_rule pn_var_rents_all.proration_rule%TYPE;
2195: l_calculation_method pn_var_rents_all.cumulative_vol%TYPE;
2196:
2197: /* get the periods that do not exist anymore */
2198: CURSOR chk_for_del_prd_c(p_vr_id IN NUMBER) IS
2199: SELECT

Line 3271: pn_var_rents_all vr

3267: ,vr.commencement_date
3268: ,vr.termination_date
3269: ,vr.proration_rule
3270: FROM
3271: pn_var_rents_all vr
3272: WHERE
3273: vr.var_rent_id = p_vr_id;
3274:
3275: l_vr_commencement_date DATE;

Line 3394: pn_var_rents_all vr

3390: ,vr.commencement_date
3391: ,vr.termination_date
3392: ,vr.proration_rule
3393: FROM
3394: pn_var_rents_all vr
3395: WHERE
3396: vr.var_rent_id = p_vr_id;
3397:
3398: l_vr_commencement_date DATE;

Line 3511: pn_var_rents_all vr

3507: SELECT
3508: vr.var_rent_id
3509: ,vr.proration_rule
3510: FROM
3511: pn_var_rents_all vr
3512: WHERE
3513: vr.var_rent_id = p_vr_id;
3514:
3515: l_proration_rule pn_var_rents_all.proration_rule%TYPE;

Line 3515: l_proration_rule pn_var_rents_all.proration_rule%TYPE;

3511: pn_var_rents_all vr
3512: WHERE
3513: vr.var_rent_id = p_vr_id;
3514:
3515: l_proration_rule pn_var_rents_all.proration_rule%TYPE;
3516:
3517: /* get the line items with updated sales for FY, LY, FLY, STD, NP */
3518: CURSOR lines_c(p_vr_id IN NUMBER) IS
3519: SELECT

Line 3789: pn_var_rents_all vr

3785: ,vr.termination_date
3786: ,vr.proration_rule
3787: ,vr.cumulative_vol
3788: FROM
3789: pn_var_rents_all vr
3790: WHERE
3791: vr.var_rent_id = p_vr_id;
3792:
3793: l_org_id pn_var_rents_all.org_id%TYPE;

Line 3793: l_org_id pn_var_rents_all.org_id%TYPE;

3789: pn_var_rents_all vr
3790: WHERE
3791: vr.var_rent_id = p_vr_id;
3792:
3793: l_org_id pn_var_rents_all.org_id%TYPE;
3794: l_vr_commencement_date pn_var_rents_all.commencement_date%TYPE;
3795: l_vr_termination_date pn_var_rents_all.termination_date%TYPE;
3796: l_proration_rule pn_var_rents_all.proration_rule%TYPE;
3797: l_calculation_method pn_var_rents_all.cumulative_vol%TYPE;

Line 3794: l_vr_commencement_date pn_var_rents_all.commencement_date%TYPE;

3790: WHERE
3791: vr.var_rent_id = p_vr_id;
3792:
3793: l_org_id pn_var_rents_all.org_id%TYPE;
3794: l_vr_commencement_date pn_var_rents_all.commencement_date%TYPE;
3795: l_vr_termination_date pn_var_rents_all.termination_date%TYPE;
3796: l_proration_rule pn_var_rents_all.proration_rule%TYPE;
3797: l_calculation_method pn_var_rents_all.cumulative_vol%TYPE;
3798:

Line 3795: l_vr_termination_date pn_var_rents_all.termination_date%TYPE;

3791: vr.var_rent_id = p_vr_id;
3792:
3793: l_org_id pn_var_rents_all.org_id%TYPE;
3794: l_vr_commencement_date pn_var_rents_all.commencement_date%TYPE;
3795: l_vr_termination_date pn_var_rents_all.termination_date%TYPE;
3796: l_proration_rule pn_var_rents_all.proration_rule%TYPE;
3797: l_calculation_method pn_var_rents_all.cumulative_vol%TYPE;
3798:
3799: /* get the line items with updated sales */

Line 3796: l_proration_rule pn_var_rents_all.proration_rule%TYPE;

3792:
3793: l_org_id pn_var_rents_all.org_id%TYPE;
3794: l_vr_commencement_date pn_var_rents_all.commencement_date%TYPE;
3795: l_vr_termination_date pn_var_rents_all.termination_date%TYPE;
3796: l_proration_rule pn_var_rents_all.proration_rule%TYPE;
3797: l_calculation_method pn_var_rents_all.cumulative_vol%TYPE;
3798:
3799: /* get the line items with updated sales */
3800: CURSOR lines_c(p_vr_id IN NUMBER) IS

Line 3797: l_calculation_method pn_var_rents_all.cumulative_vol%TYPE;

3793: l_org_id pn_var_rents_all.org_id%TYPE;
3794: l_vr_commencement_date pn_var_rents_all.commencement_date%TYPE;
3795: l_vr_termination_date pn_var_rents_all.termination_date%TYPE;
3796: l_proration_rule pn_var_rents_all.proration_rule%TYPE;
3797: l_calculation_method pn_var_rents_all.cumulative_vol%TYPE;
3798:
3799: /* get the line items with updated sales */
3800: CURSOR lines_c(p_vr_id IN NUMBER) IS
3801: SELECT

Line 4277: pn_var_rents_all vr

4273: SELECT
4274: vr.var_rent_id
4275: ,vr.cumulative_vol
4276: FROM
4277: pn_var_rents_all vr
4278: WHERE
4279: vr.var_rent_id = p_vr_id;
4280:
4281: l_proration_rule pn_var_rents_all.proration_rule%TYPE;

Line 4281: l_proration_rule pn_var_rents_all.proration_rule%TYPE;

4277: pn_var_rents_all vr
4278: WHERE
4279: vr.var_rent_id = p_vr_id;
4280:
4281: l_proration_rule pn_var_rents_all.proration_rule%TYPE;
4282: l_calculation_method pn_var_rents_all.cumulative_vol%TYPE;
4283:
4284: /* get the line items with updated sales for FY, LY, FLY, STD, NP */
4285: CURSOR lines_c(p_vr_id IN NUMBER) IS

Line 4282: l_calculation_method pn_var_rents_all.cumulative_vol%TYPE;

4278: WHERE
4279: vr.var_rent_id = p_vr_id;
4280:
4281: l_proration_rule pn_var_rents_all.proration_rule%TYPE;
4282: l_calculation_method pn_var_rents_all.cumulative_vol%TYPE;
4283:
4284: /* get the line items with updated sales for FY, LY, FLY, STD, NP */
4285: CURSOR lines_c(p_vr_id IN NUMBER) IS
4286: SELECT

Line 4399: pn_var_rents_all vr

4395: ,vr.termination_date
4396: ,vr.proration_rule
4397: ,vr.cumulative_vol
4398: FROM
4399: pn_var_rents_all vr
4400: WHERE
4401: vr.var_rent_id = p_vr_id;
4402:
4403: l_org_id pn_var_rents_all.org_id%TYPE;

Line 4403: l_org_id pn_var_rents_all.org_id%TYPE;

4399: pn_var_rents_all vr
4400: WHERE
4401: vr.var_rent_id = p_vr_id;
4402:
4403: l_org_id pn_var_rents_all.org_id%TYPE;
4404: l_vr_commencement_date pn_var_rents_all.commencement_date%TYPE;
4405: l_vr_termination_date pn_var_rents_all.termination_date%TYPE;
4406: l_proration_rule pn_var_rents_all.proration_rule%TYPE;
4407: l_calculation_method pn_var_rents_all.cumulative_vol%TYPE;

Line 4404: l_vr_commencement_date pn_var_rents_all.commencement_date%TYPE;

4400: WHERE
4401: vr.var_rent_id = p_vr_id;
4402:
4403: l_org_id pn_var_rents_all.org_id%TYPE;
4404: l_vr_commencement_date pn_var_rents_all.commencement_date%TYPE;
4405: l_vr_termination_date pn_var_rents_all.termination_date%TYPE;
4406: l_proration_rule pn_var_rents_all.proration_rule%TYPE;
4407: l_calculation_method pn_var_rents_all.cumulative_vol%TYPE;
4408:

Line 4405: l_vr_termination_date pn_var_rents_all.termination_date%TYPE;

4401: vr.var_rent_id = p_vr_id;
4402:
4403: l_org_id pn_var_rents_all.org_id%TYPE;
4404: l_vr_commencement_date pn_var_rents_all.commencement_date%TYPE;
4405: l_vr_termination_date pn_var_rents_all.termination_date%TYPE;
4406: l_proration_rule pn_var_rents_all.proration_rule%TYPE;
4407: l_calculation_method pn_var_rents_all.cumulative_vol%TYPE;
4408:
4409: /* get the line items with updated sales */

Line 4406: l_proration_rule pn_var_rents_all.proration_rule%TYPE;

4402:
4403: l_org_id pn_var_rents_all.org_id%TYPE;
4404: l_vr_commencement_date pn_var_rents_all.commencement_date%TYPE;
4405: l_vr_termination_date pn_var_rents_all.termination_date%TYPE;
4406: l_proration_rule pn_var_rents_all.proration_rule%TYPE;
4407: l_calculation_method pn_var_rents_all.cumulative_vol%TYPE;
4408:
4409: /* get the line items with updated sales */
4410: CURSOR lines_c(p_vr_id IN NUMBER) IS

Line 4407: l_calculation_method pn_var_rents_all.cumulative_vol%TYPE;

4403: l_org_id pn_var_rents_all.org_id%TYPE;
4404: l_vr_commencement_date pn_var_rents_all.commencement_date%TYPE;
4405: l_vr_termination_date pn_var_rents_all.termination_date%TYPE;
4406: l_proration_rule pn_var_rents_all.proration_rule%TYPE;
4407: l_calculation_method pn_var_rents_all.cumulative_vol%TYPE;
4408:
4409: /* get the line items with updated sales */
4410: CURSOR lines_c(p_vr_id IN NUMBER) IS
4411: SELECT

Line 4853: pn_var_rents_all vr

4849: ,vr.commencement_date
4850: ,vr.termination_date
4851: ,vr.proration_rule
4852: FROM
4853: pn_var_rents_all vr
4854: WHERE
4855: vr.var_rent_id = p_vr_id;
4856:
4857: l_vr_commencement_date DATE;

Line 4951: pn_var_rents_all vr

4947: ,vr.commencement_date
4948: ,vr.termination_date
4949: ,vr.proration_rule
4950: FROM
4951: pn_var_rents_all vr
4952: WHERE
4953: vr.var_rent_id = p_vr_id;
4954:
4955: l_vr_commencement_date DATE;

Line 5044: pn_var_rents_all vr

5040: SELECT
5041: vr.var_rent_id
5042: ,vr.proration_rule
5043: FROM
5044: pn_var_rents_all vr
5045: WHERE
5046: vr.var_rent_id = p_vr_id;
5047:
5048: l_proration_rule pn_var_rents_all.proration_rule%TYPE;

Line 5048: l_proration_rule pn_var_rents_all.proration_rule%TYPE;

5044: pn_var_rents_all vr
5045: WHERE
5046: vr.var_rent_id = p_vr_id;
5047:
5048: l_proration_rule pn_var_rents_all.proration_rule%TYPE;
5049:
5050: /* get the line items with updated deductions for FY, LY, FLY, STD, NP */
5051: CURSOR lines_c(p_vr_id IN NUMBER) IS
5052: SELECT

Line 5320: pn_var_rents_all vr

5316: ,vr.termination_date
5317: ,vr.proration_rule
5318: ,vr.cumulative_vol
5319: FROM
5320: pn_var_rents_all vr
5321: WHERE
5322: vr.var_rent_id = p_vr_id;
5323:
5324: l_org_id pn_var_rents_all.org_id%TYPE;

Line 5324: l_org_id pn_var_rents_all.org_id%TYPE;

5320: pn_var_rents_all vr
5321: WHERE
5322: vr.var_rent_id = p_vr_id;
5323:
5324: l_org_id pn_var_rents_all.org_id%TYPE;
5325: l_vr_commencement_date pn_var_rents_all.commencement_date%TYPE;
5326: l_vr_termination_date pn_var_rents_all.termination_date%TYPE;
5327: l_proration_rule pn_var_rents_all.proration_rule%TYPE;
5328: l_calculation_method pn_var_rents_all.cumulative_vol%TYPE;

Line 5325: l_vr_commencement_date pn_var_rents_all.commencement_date%TYPE;

5321: WHERE
5322: vr.var_rent_id = p_vr_id;
5323:
5324: l_org_id pn_var_rents_all.org_id%TYPE;
5325: l_vr_commencement_date pn_var_rents_all.commencement_date%TYPE;
5326: l_vr_termination_date pn_var_rents_all.termination_date%TYPE;
5327: l_proration_rule pn_var_rents_all.proration_rule%TYPE;
5328: l_calculation_method pn_var_rents_all.cumulative_vol%TYPE;
5329:

Line 5326: l_vr_termination_date pn_var_rents_all.termination_date%TYPE;

5322: vr.var_rent_id = p_vr_id;
5323:
5324: l_org_id pn_var_rents_all.org_id%TYPE;
5325: l_vr_commencement_date pn_var_rents_all.commencement_date%TYPE;
5326: l_vr_termination_date pn_var_rents_all.termination_date%TYPE;
5327: l_proration_rule pn_var_rents_all.proration_rule%TYPE;
5328: l_calculation_method pn_var_rents_all.cumulative_vol%TYPE;
5329:
5330: /* get the line items*/

Line 5327: l_proration_rule pn_var_rents_all.proration_rule%TYPE;

5323:
5324: l_org_id pn_var_rents_all.org_id%TYPE;
5325: l_vr_commencement_date pn_var_rents_all.commencement_date%TYPE;
5326: l_vr_termination_date pn_var_rents_all.termination_date%TYPE;
5327: l_proration_rule pn_var_rents_all.proration_rule%TYPE;
5328: l_calculation_method pn_var_rents_all.cumulative_vol%TYPE;
5329:
5330: /* get the line items*/
5331: CURSOR lines_c(p_vr_id IN NUMBER) IS

Line 5328: l_calculation_method pn_var_rents_all.cumulative_vol%TYPE;

5324: l_org_id pn_var_rents_all.org_id%TYPE;
5325: l_vr_commencement_date pn_var_rents_all.commencement_date%TYPE;
5326: l_vr_termination_date pn_var_rents_all.termination_date%TYPE;
5327: l_proration_rule pn_var_rents_all.proration_rule%TYPE;
5328: l_calculation_method pn_var_rents_all.cumulative_vol%TYPE;
5329:
5330: /* get the line items*/
5331: CURSOR lines_c(p_vr_id IN NUMBER) IS
5332: SELECT