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_TRUEUP_PKG dependencies on PN_VAR_PERIODS_ALL

Line 53: pn_var_periods_all p

49: SELECT
50: invoice_date
51: FROM
52: pn_var_grp_dates_all g,
53: pn_var_periods_all p
54: WHERE
55: g.var_rent_id = p_vr_id AND
56: g.period_id = p_prd_id AND
57: g.period_id = p.period_id AND

Line 65: pn_var_periods_all p

61: g.invoice_date
62: FROM
63: pn_var_trx_headers_all t,
64: pn_var_grp_dates_all g,
65: pn_var_periods_all p
66: WHERE
67: t.grp_date_id = g.grp_date_id AND
68: t.var_rent_id = p_vr_id AND
69: t.period_id = p_prd_id AND

Line 150: pn_var_periods_all prd,

146: SELECT
147: NVL(SUM(percent_rent_due),0) AS billed_rent
148: ,line_item_id
149: FROM
150: pn_var_periods_all prd,
151: pn_var_rents_all var,
152: pn_var_trx_headers_all trx
153: WHERE
154: prd.var_rent_id = p_vr_id AND

Line 169: pn_var_periods_all prd

165: CURSOR second_yr_cur (p_vr_id IN NUMBER) IS
166: SELECT
167: period_id
168: FROM
169: pn_var_periods_all prd
170: WHERE
171: prd.var_rent_id = p_vr_id AND
172: prd.period_num = 2;
173:

Line 692: pn_var_periods_all per,

688: ,'N' true_up_exp_code
689: , invoice_date
690: FROM
691: pn_var_rent_summ_all summ,
692: pn_var_periods_all per,
693: pn_var_rents_all vr
694: WHERE
695: summ.period_id = per.period_id AND
696: vr.var_rent_id = per.var_rent_id AND

Line 711: pn_var_periods_all per

707: NULL as var_rent_inv_id
708: ,(SELECT NVL(SUM(first_yr_rent), 0)
709: FROM
710: pn_var_rent_summ_all summ,
711: pn_var_periods_all per
712: WHERE
713: per.period_id = summ.period_id AND
714: summ.var_rent_id = ip_var_rent_id AND
715: per.period_num = 2

Line 729: pn_var_periods_all per

725: as const_t
726: ,(SELECT NVL(SUM(first_yr_rent), 0)
727: FROM
728: pn_var_rent_summ_all summ,
729: pn_var_periods_all per
730: WHERE
731: per.period_id = summ.period_id AND
732: summ.var_rent_id = ip_var_rent_id AND
733: per.period_num = 2

Line 748: pn_var_periods_all per,

744: ,'N' true_up_exp_code
745: , invoice_date
746: FROM
747: pn_var_rent_summ_all summ,
748: pn_var_periods_all per,
749: pn_var_rents_all vr
750: WHERE
751: summ.period_id = per.period_id AND
752: vr.var_rent_id = per.var_rent_id AND

Line 1207: FROM pn_var_periods_all

1203: SELECT MAX(invoice_date) inv_date
1204: FROM pn_var_grp_dates_all
1205: WHERE var_rent_id = p_var_rent_id
1206: AND period_id = (SELECT max(period_id)
1207: FROM pn_var_periods_all
1208: WHERE var_rent_id = p_var_rent_id
1209: AND NVL(status, pn_var_rent_calc_pkg.G_PERIOD_ACTIVE_STATUS)
1210: <> pn_var_rent_calc_pkg.G_PERIOD_REVERSED_STATUS);
1211:

Line 1367: FROM pn_var_periods_all

1363: SELECT MAX(invoice_date) inv_date
1364: FROM pn_var_grp_dates_all
1365: WHERE var_rent_id = p_var_rent_id
1366: AND period_id = (SELECT max(period_id)
1367: FROM pn_var_periods_all
1368: WHERE var_rent_id = p_var_rent_id
1369: AND NVL(status, pn_var_rent_calc_pkg.G_PERIOD_ACTIVE_STATUS)
1370: <> pn_var_rent_calc_pkg.G_PERIOD_REVERSED_STATUS);
1371:

Line 1525: FROM pn_var_rent_inv_all inv, pn_var_periods_all per

1521: -- Get the details of actual start and end date for FY/LY/FLY
1522: CURSOR invoice_dates_fyly_c(ip_var_rent_inv_id NUMBER
1523: ) IS
1524: SELECT per.start_date, per.end_date
1525: FROM pn_var_rent_inv_all inv, pn_var_periods_all per
1526: WHERE per.period_id = inv.period_id
1527: AND inv.var_rent_inv_id = ip_var_rent_inv_id;
1528:
1529: -- Get the id of invoice created for first year.

Line 1534: FROM pn_var_rent_inv_all inv, pn_var_periods_all per

1530: -- This has meaning only if proration is FY/FLY
1531: CURSOR get_fy_inv_c(ip_var_rent_id NUMBER
1532: ) IS
1533: SELECT inv.var_rent_inv_id
1534: FROM pn_var_rent_inv_all inv, pn_var_periods_all per
1535: WHERE per.period_id = inv.period_id
1536: AND inv.var_rent_id = ip_var_rent_id
1537: AND per.start_date = (SELECT MIN(start_date) from pn_var_periods_all
1538: WHERE var_rent_id = ip_var_rent_id);

Line 1537: AND per.start_date = (SELECT MIN(start_date) from pn_var_periods_all

1533: SELECT inv.var_rent_inv_id
1534: FROM pn_var_rent_inv_all inv, pn_var_periods_all per
1535: WHERE per.period_id = inv.period_id
1536: AND inv.var_rent_id = ip_var_rent_id
1537: AND per.start_date = (SELECT MIN(start_date) from pn_var_periods_all
1538: WHERE var_rent_id = ip_var_rent_id);
1539: -- Get the id of last invoice created.
1540: -- This has meaning only if proration is LY/FLY
1541: CURSOR get_ly_inv_c(ip_var_rent_id NUMBER

Line 1544: FROM pn_var_rent_inv_all inv, pn_var_periods_all per

1540: -- This has meaning only if proration is LY/FLY
1541: CURSOR get_ly_inv_c(ip_var_rent_id NUMBER
1542: ) IS
1543: SELECT inv.var_rent_inv_id
1544: FROM pn_var_rent_inv_all inv, pn_var_periods_all per
1545: WHERE per.period_id = inv.period_id
1546: AND inv.var_rent_id = ip_var_rent_id
1547: AND per.start_date = (SELECT MAX(start_date) from pn_var_periods_all
1548: WHERE var_rent_id = ip_var_rent_id)

Line 1547: AND per.start_date = (SELECT MAX(start_date) from pn_var_periods_all

1543: SELECT inv.var_rent_inv_id
1544: FROM pn_var_rent_inv_all inv, pn_var_periods_all per
1545: WHERE per.period_id = inv.period_id
1546: AND inv.var_rent_id = ip_var_rent_id
1547: AND per.start_date = (SELECT MAX(start_date) from pn_var_periods_all
1548: WHERE var_rent_id = ip_var_rent_id)
1549: AND inv.invoice_date = (SELECT MAX(invoice_date) FROM pn_var_rent_inv_all
1550: WHERE var_rent_id = ip_var_rent_id)
1551: AND inv.true_up_amt is NULL;

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

1588: -- Get the number of inv which should exist for a period
1589: CURSOR num_inv_c(ip_var_rent_inv_id NUMBER
1590: ) IS
1591: 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
1592: FROM pn_var_rent_inv_all inv, pn_var_periods_all per, pn_var_rents_all vr, pn_var_rent_dates_all vrd
1593: WHERE per.period_id = inv.period_id
1594: AND inv.var_rent_inv_id = ip_var_rent_inv_id
1595: AND per.var_rent_id = vr.var_rent_id
1596: AND vrd.var_rent_id = vr.var_rent_id;

Line 1605: pn_var_periods_all per,

1601: SELECT inv.invoice_date,
1602: inv.var_rent_inv_id,
1603: inv.period_id
1604: FROM pn_var_rents_all vr,
1605: pn_var_periods_all per,
1606: pn_var_rent_inv_all inv
1607: WHERE per.var_rent_id = vr.var_rent_id
1608: AND inv.period_id = per.period_id
1609: AND per.start_date = (select max(start_date) from pn_var_periods_all per1

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

1605: pn_var_periods_all per,
1606: pn_var_rent_inv_all inv
1607: WHERE per.var_rent_id = vr.var_rent_id
1608: AND inv.period_id = per.period_id
1609: AND per.start_date = (select max(start_date) from pn_var_periods_all per1
1610: where per1.var_rent_id = vr.var_rent_id)
1611: AND inv.invoice_date = (select max(invoice_date) from pn_var_rent_inv_all inv1
1612: where inv1.period_id = per.period_id)
1613: AND vr.var_rent_id = ip_vr_id;

Line 1936: FROM pn_var_rent_inv_all inv, pn_var_periods_all per

1932: -- Get the details of actual start and end date for FY/LY/FLY
1933: CURSOR invoice_dates_fyly_c(ip_var_rent_inv_id NUMBER
1934: ) IS
1935: SELECT per.start_date, per.end_date
1936: FROM pn_var_rent_inv_all inv, pn_var_periods_all per
1937: WHERE per.period_id = inv.period_id
1938: AND inv.var_rent_inv_id = ip_var_rent_inv_id;
1939: -- Get the id of invoice created for first year.
1940: -- This has meaning only if proration is FY/FLY

Line 1944: FROM pn_var_rent_inv_all inv, pn_var_periods_all per

1940: -- This has meaning only if proration is FY/FLY
1941: CURSOR get_fy_inv_c(ip_var_rent_id NUMBER
1942: ) IS
1943: SELECT inv.var_rent_inv_id
1944: FROM pn_var_rent_inv_all inv, pn_var_periods_all per
1945: WHERE per.period_id = inv.period_id
1946: AND inv.var_rent_id = ip_var_rent_id
1947: AND per.start_date = (SELECT MIN(start_date) from pn_var_periods_all
1948: WHERE var_rent_id = ip_var_rent_id);

Line 1947: AND per.start_date = (SELECT MIN(start_date) from pn_var_periods_all

1943: SELECT inv.var_rent_inv_id
1944: FROM pn_var_rent_inv_all inv, pn_var_periods_all per
1945: WHERE per.period_id = inv.period_id
1946: AND inv.var_rent_id = ip_var_rent_id
1947: AND per.start_date = (SELECT MIN(start_date) from pn_var_periods_all
1948: WHERE var_rent_id = ip_var_rent_id);
1949: -- Get the id of last invoice created.
1950: -- This has meaning only if proration is LY/FLY
1951: CURSOR get_ly_inv_c(ip_var_rent_id NUMBER

Line 1954: FROM pn_var_rent_inv_all inv, pn_var_periods_all per

1950: -- This has meaning only if proration is LY/FLY
1951: CURSOR get_ly_inv_c(ip_var_rent_id NUMBER
1952: ) IS
1953: SELECT inv.var_rent_inv_id
1954: FROM pn_var_rent_inv_all inv, pn_var_periods_all per
1955: WHERE per.period_id = inv.period_id
1956: AND inv.var_rent_id = ip_var_rent_id
1957: AND per.start_date = (SELECT MAX(start_date) from pn_var_periods_all
1958: WHERE var_rent_id = ip_var_rent_id)

Line 1957: AND per.start_date = (SELECT MAX(start_date) from pn_var_periods_all

1953: SELECT inv.var_rent_inv_id
1954: FROM pn_var_rent_inv_all inv, pn_var_periods_all per
1955: WHERE per.period_id = inv.period_id
1956: AND inv.var_rent_id = ip_var_rent_id
1957: AND per.start_date = (SELECT MAX(start_date) from pn_var_periods_all
1958: WHERE var_rent_id = ip_var_rent_id)
1959: AND inv.invoice_date = (SELECT MAX(invoice_date) from pn_var_rent_inv_all
1960: WHERE var_rent_id = ip_var_rent_id);
1961:

Line 2341: pn_var_periods_all

2337: ,start_date
2338: ,end_date
2339: ,partial_period
2340: FROM
2341: pn_var_periods_all
2342: WHERE
2343: var_rent_id = p_vr_id AND
2344: end_date <= p_prd_date
2345: AND NVL(status, pn_var_rent_calc_pkg.G_PERIOD_ACTIVE_STATUS)

Line 2356: FROM pn_var_periods_all

2352: -- periods might have changed so we need to apply_abatements to subsequent periods.
2353: CURSOR periods_abat_c(ip_var_rent_id NUMBER
2354: ) IS
2355: SELECT period_id
2356: FROM pn_var_periods_all
2357: WHERE var_rent_id = ip_var_rent_id
2358: AND NVL(status, pn_var_rent_calc_pkg.G_PERIOD_ACTIVE_STATUS)
2359: <> pn_var_rent_calc_pkg.G_PERIOD_REVERSED_STATUS;
2360: