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_INDEX_AMOUNT_PKG dependencies on PN_INDEX_LEASE_PERIODS_ALL

Line 547: FROM pn_index_lease_periods_all pilp

543: ,pilp.current_index_line_value
544: ,pilp.previous_index_line_id
545: ,pilp.previous_index_line_value
546: ,pilp.unconstraint_rent_due
547: FROM pn_index_lease_periods_all pilp
548: WHERE pilp.index_lease_id = ip_index_lease_id
549: AND pilp.index_period_id = ip_index_period_id
550: ORDER BY pilp.line_number;
551:

Line 653: FROM pn_index_lease_periods_all pilp

649: --
650:
651: SELECT pilp.index_period_id
652: INTO op_prev_index_lease_id
653: FROM pn_index_lease_periods_all pilp
654: WHERE pilp.index_lease_id = p_index_lease_id
655: AND pilp.assessment_date = (SELECT MAX (pilp.assessment_date)
656: FROM pn_index_lease_periods_all pilp
657: WHERE pilp.index_lease_id = p_index_lease_id

Line 656: FROM pn_index_lease_periods_all pilp

652: INTO op_prev_index_lease_id
653: FROM pn_index_lease_periods_all pilp
654: WHERE pilp.index_lease_id = p_index_lease_id
655: AND pilp.assessment_date = (SELECT MAX (pilp.assessment_date)
656: FROM pn_index_lease_periods_all pilp
657: WHERE pilp.index_lease_id = p_index_lease_id
658: /*
659: -- if p_assessment_date is null, this will return the
660: -- assessment date of the last index rent period.

Line 706: FROM pn_index_lease_periods_all pilp

702: ,'UNCONSTRAINT', unconstraint_rent_due
703: ,'CONSTRAINT', constraint_rent_due
704: )
705: INTO op_index_amount
706: FROM pn_index_lease_periods_all pilp
707: WHERE index_period_id = v_index_period_id;
708: END IF;
709: EXCEPTION
710: WHEN OTHERS THEN

Line 736: FROM pn_index_lease_periods_all pilp

732: --put_log ('..In derive_next_peroid_details');
733:
734: SELECT pilp.index_period_id,pilp.basis_start_date,pilp.basis_end_date
735: INTO op_next_index_period_id,op_basis_start_date,op_basis_end_date
736: FROM pn_index_lease_periods_all pilp
737: WHERE pilp.index_lease_id = p_index_lease_id
738: AND pilp.assessment_date = (SELECT MIN (pilp.assessment_date)
739: FROM pn_index_lease_periods_all pilp
740: WHERE pilp.index_lease_id = p_index_lease_id

Line 739: FROM pn_index_lease_periods_all pilp

735: INTO op_next_index_period_id,op_basis_start_date,op_basis_end_date
736: FROM pn_index_lease_periods_all pilp
737: WHERE pilp.index_lease_id = p_index_lease_id
738: AND pilp.assessment_date = (SELECT MIN (pilp.assessment_date)
739: FROM pn_index_lease_periods_all pilp
740: WHERE pilp.index_lease_id = p_index_lease_id
741: AND pilp.assessment_date > p_assessment_date
742: );
743:

Line 830: FROM pn_payment_terms_all ppt, pn_index_lease_periods_all ppi

826: ,c_spread_frequency_one_time, 0
827: )
828: )
829: INTO p_prev_index_amount
830: FROM pn_payment_terms_all ppt, pn_index_lease_periods_all ppi
831: WHERE ppt.index_period_id = ppi.index_period_id
832: AND ppi.index_lease_id = p_index_lease_id
833: AND ppi.assessment_date < (SELECT assessment_date
834: FROM pn_index_lease_periods_all

Line 834: FROM pn_index_lease_periods_all

830: FROM pn_payment_terms_all ppt, pn_index_lease_periods_all ppi
831: WHERE ppt.index_period_id = ppi.index_period_id
832: AND ppi.index_lease_id = p_index_lease_id
833: AND ppi.assessment_date < (SELECT assessment_date
834: FROM pn_index_lease_periods_all
835: WHERE index_period_id = p_index_period_id)
836: AND ppt.lease_id = p_lease_id;
837: EXCEPTION
838: WHEN OTHERS THEN

Line 871: FROM pn_index_lease_periods_all pilp

867: ,'CONSTRAINT', constraint_rent_due
868: )
869: )
870: INTO p_sum_prev_index_amts
871: FROM pn_index_lease_periods_all pilp
872: WHERE pilp.index_lease_id = p_index_lease_id
873: AND pilp.assessment_date < p_assessment_date;
874: EXCEPTION
875: WHEN OTHERS THEN

Line 940: FROM pn_index_lease_periods_all ppilx

936: = DECODE(p_payment_type, c_increase_on_gross,
937: ppt.payment_term_type_code, p_payment_type)
938: AND NVL(ppt.index_period_id, -1) NOT IN
939: (SELECT index_period_id
940: FROM pn_index_lease_periods_all ppilx
941: WHERE ppilx.index_lease_id = p_index_lease_id)
942: AND NVL(ppt.status,'-1')
943: = DECODE(ppt.index_period_id, NULL,
944: NVL(ppt.status,'-1'), 'APPROVED')

Line 980: FROM pn_index_lease_periods_all ppilx

976: = DECODE(p_payment_type, c_increase_on_gross,
977: ppt.payment_term_type_code, p_payment_type)
978: AND NVL(ppt.index_period_id, -1) NOT IN
979: (SELECT index_period_id
980: FROM pn_index_lease_periods_all ppilx
981: WHERE ppilx.index_lease_id = p_index_lease_id)
982: AND NVL(ppt.status,'-1')
983: = DECODE(ppt.index_period_id, NULL,
984: NVL(ppt.status,'-1'), 'APPROVED')

Line 1504: FROM pn_index_leases_all pil, pn_index_lease_periods_all pilp

1500: ,nvl(pil.increase_on,c_increase_on_gross) "INCREASE_ON"
1501: ,pilp.index_period_id
1502: ,pilp.basis_start_date
1503: ,pilp.basis_end_date
1504: FROM pn_index_leases_all pil, pn_index_lease_periods_all pilp
1505: WHERE pil.index_lease_id = pilp.index_lease_id
1506: AND pil.index_lease_id = p_index_lease_id
1507: AND pilp.line_number = 1;
1508:

Line 2103: FROM pn_index_lease_periods_all

2099: v_lower_index_date_code NUMBER;
2100:
2101: CURSOR get_relationship IS
2102: SELECT relationship
2103: FROM pn_index_lease_periods_all
2104: WHERE assessment_date = p_assessment_date
2105: AND index_lease_id = p_index_lease_id;
2106:
2107: v_relationship_default VARCHAR2(30);

Line 2262: FROM pn_index_lease_periods_all pilp

2258: -- Get the latest assessment date before the current assessment date
2259: --
2260: SELECT MAX (pilp.assessment_date)
2261: INTO v_prev_assessment_date
2262: FROM pn_index_lease_periods_all pilp
2263: WHERE pilp.index_lease_id = p_index_lease_id
2264: AND pilp.assessment_date < p_assessment_date;
2265: ELSE
2266: v_prev_assessment_date := p_prev_assessment_date;

Line 2323: FROM pn_index_lease_periods_all

2319: SELECT current_index_line_id
2320: ,current_index_line_value
2321: INTO v_previous_cpi_id
2322: ,v_previous_cpi_value
2323: FROM pn_index_lease_periods_all
2324: WHERE index_period_id = v_prev_period_id;
2325: ELSE
2326: -- Fix for bug # 1873888
2327: -- If no previous CPI is found, then use base index

Line 2759: FROM pn_index_lease_periods_all

2755: WHERE index_lease_id = p_index_lease_id;
2756:
2757: CURSOR assessment_date_cur(p_index_lease_id NUMBER) IS
2758: SELECT assessment_date, index_period_id
2759: FROM pn_index_lease_periods_all
2760: WHERE index_lease_id = p_index_lease_id
2761: ORDER BY assessment_date;
2762:
2763: BEGIN

Line 3038: FROM pn_index_lease_periods_all plpx

3034: )
3035: )
3036: AND (( p_basis_type = c_basis_type_compound AND
3037: not exists( SELECT null
3038: FROM pn_index_lease_periods_all plpx
3039: WHERE plpx.index_period_id = ppt.index_period_id
3040: AND plpx.index_lease_id = p_index_lease_id))
3041: OR p_basis_type <> c_basis_type_compound)
3042: AND ppt.frequency_code <> c_spread_frequency_one_time

Line 3106: FROM pn_index_lease_periods_all plpx

3102: )
3103: )
3104: AND ( ( p_basis_type = c_basis_type_compound AND
3105: not exists( SELECT null
3106: FROM pn_index_lease_periods_all plpx
3107: WHERE plpx.index_period_id = ppt.index_period_id
3108: AND plpx.index_lease_id = p_index_lease_id))
3109: OR p_basis_type <> c_basis_type_compound)
3110: AND ppt.end_date >= ip_basis_start_date AND ppt.start_date <= ip_basis_end_date

Line 4435: FROM pn_index_lease_periods_all pilp

4431: NVL (v_prev_index_amt, 0);
4432: ELSE
4433: SELECT current_basis
4434: INTO v_normalize_basis_amount
4435: FROM pn_index_lease_periods_all pilp
4436: WHERE pilp.index_lease_id = p_index_lease_id
4437: AND line_number = 1;
4438: END IF;
4439:

Line 5167: FROM pn_index_lease_periods_all

5163: SELECT location_id
5164: FROM pn_index_leases_all
5165: WHERE index_lease_id =
5166: (SELECT index_lease_id
5167: FROM pn_index_lease_periods_all
5168: WHERE index_period_id = p_index_period_id);
5169:
5170: CURSOR org_id_cur IS
5171: SELECT org_id

Line 5181: FROM pn_index_lease_periods_all

5177: SELECT vr_nbp_flag
5178: FROM pn_index_leases_all
5179: WHERE index_lease_id =
5180: (SELECT index_lease_id
5181: FROM pn_index_lease_periods_all
5182: WHERE index_period_id = p_index_period_id);
5183:
5184: BEGIN
5185: put_log ('pn_index_amount_pkg.create_payment_term_record (+) :');

Line 5451: FROM pn_index_lease_periods_all pilp

5447:
5448: BEGIN
5449: SELECT trunc(pilp.assessment_date)
5450: INTO v_assessment_date
5451: FROM pn_index_lease_periods_all pilp
5452: WHERE pilp.index_period_id = p_index_period_id;
5453:
5454: EXCEPTION
5455: WHEN TOO_MANY_ROWS THEN

Line 6009: pn_index_lease_periods_all pilp,

6005: ,nvl (pil.proration_rule, 'NO_PRORATION') "PRORATION_RULE"
6006: ,pil.proration_period_start_date
6007: ,pil.assessment_interval
6008: FROM pn_index_leases_all pil,
6009: pn_index_lease_periods_all pilp,
6010: pn_leases_all pl
6011: WHERE pil.index_lease_id = pilp.index_lease_id
6012: AND pil.lease_id = pl.lease_id
6013: AND pilp.index_period_id = p_index_lease_period_id;

Line 6569: FROM pn_index_leases_all pil, pn_index_lease_periods_all pilp

6565: ,pilp.index_period_id
6566: ,pil.lease_id
6567: ,pil.retain_initial_basis_flag
6568: ,pil.initial_basis
6569: FROM pn_index_leases_all pil, pn_index_lease_periods_all pilp
6570: WHERE pil.index_lease_id = pilp.index_lease_id
6571: AND pil.index_lease_id = p_index_lease_id
6572: ORDER BY pilp.line_number;
6573:

Line 6583: FROM pn_index_leases_all pil, pn_index_lease_periods_all pilp

6579: ,pilp.index_period_id
6580: ,pil.lease_id
6581: ,pil.retain_initial_basis_flag
6582: ,pil.initial_basis
6583: FROM pn_index_leases_all pil, pn_index_lease_periods_all pilp
6584: WHERE pil.index_lease_id = pilp.index_lease_id
6585: AND pil.index_lease_id = p_index_lease_id
6586: AND pilp.index_period_id = p_index_lease_period_id
6587: ORDER BY pilp.line_number;

Line 6661: UPDATE pn_index_lease_periods_all

6657: p_new_msg => v_period_msg
6658: ,p_all_msg => v_all_msg
6659: );
6660:
6661: UPDATE pn_index_lease_periods_all
6662: SET current_basis = v_basis_amount
6663: ,unconstraint_rent_due = v_uncontrained_index_amount
6664: ,constraint_rent_due = v_p_constrained_rent_amount
6665: ,index_percent_change = v_index_percent_change

Line 6756: FROM pn_leases_all pl, pn_index_leases pil, pn_index_lease_periods_all pilp

6752: ,pilp.assessment_date
6753: ,pil.index_lease_number
6754: ,pil.term_template_id
6755: ,pil.org_id
6756: FROM pn_leases_all pl, pn_index_leases pil, pn_index_lease_periods_all pilp
6757: WHERE pl.lease_id = pil.lease_id
6758: AND pil.index_lease_id = pilp.index_lease_id
6759: AND (pil.index_lease_number >= nvl(p_index_rent_number_lower,pil.index_lease_number))
6760: AND (pil.index_lease_number <= nvl(p_index_rent_number_upper,pil.index_lease_number))

Line 6859: FROM pn_index_lease_periods_all pilp

6855: p_index_history_line_id IN NUMBER
6856: ) IS
6857: SELECT pilp.index_lease_id
6858: ,pilp.index_period_id
6859: FROM pn_index_lease_periods_all pilp
6860: WHERE ( pilp.previous_index_line_id = p_index_history_line_id
6861: OR pilp.current_index_line_id = p_index_history_line_id
6862: );
6863:

Line 6935: FROM pn_index_lease_periods_all pilp

6931: ,pilp.current_index_line_id
6932: ,pilp.current_index_line_value
6933: ,pilp.previous_index_line_value
6934: ,pilp.constraint_rent_due
6935: FROM pn_index_lease_periods_all pilp
6936: WHERE ( pilp.previous_index_line_id = p_index_history_line_id
6937: OR pilp.current_index_line_id = p_index_history_line_id
6938: );
6939:

Line 7031: UPDATE pn_index_lease_periods_all

7027: --
7028:
7029: IF ilp_rec.constraint_rent_due IS NULL
7030: OR NVL (ip_recalculate, 'N') = 'Y' THEN
7031: UPDATE pn_index_lease_periods_all
7032: SET index_percent_change = v_index_percent_change
7033: ,current_index_line_value = v_current_cpi_value
7034: ,previous_index_line_value = v_previous_cpi_value
7035: WHERE index_period_id = ilp_rec.index_period_id;

Line 7262: ,pn_index_lease_periods_all pilp

7258: ,DECODE (ppt.normalize, 'Y', 'NORMALIZE') "NORMALIZE"
7259: ,ppt.schedule_day
7260: FROM pn_leases_all pl
7261: ,pn_index_leases pil
7262: ,pn_index_lease_periods_all pilp
7263: ,pn_payment_terms_all ppt
7264: WHERE pl.lease_id = pil.lease_id
7265: AND pil.index_lease_id = pilp.index_lease_id
7266: AND pilp.index_period_id = ppt.index_period_id

Line 7553: FROM pn_index_lease_periods_all pilp

7549: op_carry_forward_percent OUT NOCOPY NUMBER) IS
7550: CURSOR csr_cum_carry_for IS
7551: SELECT pilp.carry_forward_amount,
7552: pilp.carry_forward_percent
7553: FROM pn_index_lease_periods_all pilp
7554: WHERE pilp.index_lease_id = p_index_lease_id
7555: AND pilp.assessment_date = (SELECT MAX (pilp.assessment_date)
7556: FROM pn_index_lease_periods_all pilp
7557: WHERE pilp.index_lease_id = p_index_lease_id

Line 7556: FROM pn_index_lease_periods_all pilp

7552: pilp.carry_forward_percent
7553: FROM pn_index_lease_periods_all pilp
7554: WHERE pilp.index_lease_id = p_index_lease_id
7555: AND pilp.assessment_date = (SELECT MAX (pilp.assessment_date)
7556: FROM pn_index_lease_periods_all pilp
7557: WHERE pilp.index_lease_id = p_index_lease_id
7558: AND pilp.assessment_date < p_assessment_date);
7559:
7560: BEGIN

Line 7596: FROM pn_index_lease_periods_all

7592: RETURN number
7593: IS
7594: CURSOR csr_negative_rent IS
7595: SELECT unconstraint_rent_due, constraint_rent_due
7596: FROM pn_index_lease_periods_all
7597: WHERE index_lease_id = p_index_lease_id
7598: AND assessment_date < p_assessment_date
7599: ORDER BY assessment_date desc;
7600:

Line 7677: FROM pn_index_lease_periods_all

7673: IS
7674: CURSOR csr_get_dt
7675: IS
7676: SELECT max(assessment_date)
7677: FROM pn_index_lease_periods_all
7678: WHERE index_lease_id = p_index_lease_id
7679: AND assessment_date > p_assessment_date
7680: AND constraint_rent_due is not null;
7681:

Line 7714: FROM pn_index_lease_periods_all

7710: CURSOR csr_get_periods is
7711: SELECT index_lease_id,
7712: index_period_id,
7713: assessment_date
7714: FROM pn_index_lease_periods_all
7715: WHERE index_lease_id = p_index_lease_id
7716: AND assessment_date > p_assessment_date
7717: AND assessment_date <= get_max_assessment_dt(index_lease_id,p_assessment_date);
7718: