APPS.PN_VAR_TRUEUP_PKG dependencies on PN_VAR_RENTS_ALL

Line 151: pn_var_rents_all var,

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
155: prd.var_rent_id = var.var_rent_id AND

Line 347: FROM pn_var_rents_all

343: l_rec_abatement_override NUMBER;
344: /* get ORG ID */
345: CURSOR org_c(p_vr_id IN NUMBER) IS
346: SELECT org_id, termination_date
347: FROM pn_var_rents_all
348: WHERE var_rent_id = p_vr_id;
349:
350: l_org_id NUMBER;
351:

Line 648: FROM PN_VAR_RENTS_ALL abat

644: IS
645: -- Allowances first ot abatements?
646: CURSOR order_c(ip_var_rent_id NUMBER) IS
647: SELECT ORDER_OF_APPL_CODE, termination_date, org_id
648: FROM PN_VAR_RENTS_ALL abat
649: WHERE abat.var_rent_id = ip_var_rent_id;
650:
651: -- Get the details of
652: CURSOR inv_c( ip_var_rent_id NUMBER,

Line 693: pn_var_rents_all vr

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
697: (per.period_num <> 1 OR

Line 749: pn_var_rents_all vr

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
753: vr.proration_rule IN ('FY', 'FLY') AND

Line 816: FROM pn_var_rents_all vr,

812: pn_var_rent_calc_pkg.G_INV_ON_ACTUAL, actual_exp_code,
813: pn_var_rent_calc_pkg.G_INV_ON_FORECASTED, variance_exp_code) AS
814: exp_code,
815: inv.actual_invoiced_amount
816: FROM pn_var_rents_all vr,
817: pn_var_rent_inv_all inv
818: WHERE vr.var_rent_id = inv.var_rent_id
819: AND inv.var_rent_inv_id = ip_var_rent_inv_id;
820:

Line 1238: FROM pn_var_rents_all

1234: AND inv1.invoice_date = inv.invoice_date);
1235: CURSOR csr_get_abt(ip_var_rent_id NUMBER)
1236: IS
1237: SELECT negative_rent
1238: FROM pn_var_rents_all
1239: WHERE var_rent_id = ip_var_rent_id;
1240:
1241:
1242: l_negative_rent pn_var_rent_inv.negative_rent%TYPE := 0;

Line 1376: FROM pn_var_rents_all

1372:
1373: CURSOR csr_get_abt(ip_var_rent_id NUMBER)
1374: IS
1375: SELECT negative_rent
1376: FROM pn_var_rents_all
1377: WHERE var_rent_id = ip_var_rent_id;
1378:
1379: l_neg_rent_def NUMBER;
1380: l_negative_rent pn_var_rent_inv.negative_rent%TYPE := 0;

Line 1511: FROM PN_VAR_RENTS_ALL ABAT

1507: AND type_code = pn_var_rent_calc_pkg.G_ABAT_TYPE_CODE_ABAT;
1508: -- Get the details of
1509: CURSOR EXCESS_ABAT_C(ip_var_rent_id NUMBER) IS
1510: SELECT EXCESS_ABAT_CODE
1511: FROM PN_VAR_RENTS_ALL ABAT
1512: WHERE abat.var_rent_id = ip_var_rent_id;
1513: -- Get the details of inv_start, end_date
1514: CURSOR invoice_dates_c(ip_var_rent_id NUMBER,
1515: ip_invoice_date DATE

Line 1569: FROM pn_var_rents_all

1565: -- Get the details of negative_rent
1566: CURSOR neg_rent_c(ip_var_rent_id NUMBER
1567: ) IS
1568: SELECT negative_rent
1569: FROM pn_var_rents_all
1570: WHERE var_rent_id = ip_var_rent_id;
1571:
1572: -- Get the details of negative_rent
1573: CURSOR calc_freq_c(ip_var_rent_id NUMBER

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 1604: FROM pn_var_rents_all vr,

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

Line 1619: FROM pn_var_rents_all

1615: -- Get the proration type
1616: CURSOR proration_type_c(ip_var_rent_id NUMBER
1617: ) IS
1618: SELECT proration_rule
1619: FROM pn_var_rents_all
1620: WHERE var_rent_id = ip_var_rent_id;
1621:
1622: -- Get the details of
1623: CURSOR rec_abatement_c(ip_period_id NUMBER

Line 1966: FROM pn_var_rents_all

1962: -- Get the proration type
1963: CURSOR proration_type_c(ip_var_rent_id NUMBER
1964: ) IS
1965: SELECT proration_rule
1966: FROM pn_var_rents_all
1967: WHERE var_rent_id = ip_var_rent_id;
1968:
1969:
1970:

Line 2322: pn_var_rents_all

2318: ,commencement_date
2319: ,termination_date
2320: ,org_id
2321: FROM
2322: pn_var_rents_all
2323: WHERE
2324: var_rent_id = p_vr_id;
2325:
2326: l_vr_start_date DATE;

Line 2330: l_org_id pn_var_rents_all.org_id%TYPE;

2326: l_vr_start_date DATE;
2327: l_vr_end_date DATE;
2328: l_proration_rule VARCHAR2(30);
2329: l_calc_method VARCHAR2(30);
2330: l_org_id pn_var_rents_all.org_id%TYPE;
2331:
2332: CURSOR periods_c( p_vr_id IN NUMBER
2333: ,p_date IN DATE) IS
2334: SELECT

Line 2818: ,pn_var_rents_all vr

2814: SELECT
2815: vr.var_rent_id
2816: FROM
2817: pn_leases_all lease
2818: ,pn_var_rents_all vr
2819: WHERE
2820: vr.cumulative_vol = 'T' AND
2821: vr.lease_id = lease.lease_id AND
2822: lease.lease_num BETWEEN l_lease_num_low AND l_lease_num_high AND

Line 2833: ,pn_var_rents_all vr

2829: SELECT
2830: vr.var_rent_id
2831: FROM
2832: pn_leases_all lease
2833: ,pn_var_rents_all vr
2834: WHERE
2835: vr.cumulative_vol = pn_var_rent_calc_pkg.G_CALC_TRUE_UP AND
2836: vr.lease_id = lease.lease_id AND
2837: lease.lease_num BETWEEN l_lease_num_low AND l_lease_num_high AND