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

Line 932: ,pn_index_leases_all pil

928: SELECT ppt.payment_term_id
929: ,NVL(ppt.actual_amount, ppt.estimated_amount)
930: ,ppt.frequency_code
931: FROM pn_payment_terms_all ppt
932: ,pn_index_leases_all pil
933: WHERE pil.index_lease_id = p_index_lease_id
934: AND ppt.lease_id = pil.lease_id
935: AND ppt.payment_term_type_code
936: = DECODE(p_payment_type, c_increase_on_gross,

Line 972: ,pn_index_leases_all pil

968: SELECT ppt.payment_term_id
969: ,NVL(ppt.actual_amount, ppt.estimated_amount)
970: ,ppt.frequency_code
971: FROM pn_payment_terms_all ppt
972: ,pn_index_leases_all pil
973: WHERE pil.index_lease_id = p_index_lease_id
974: AND ppt.lease_id = pil.lease_id
975: AND ppt.payment_term_type_code
976: = DECODE(p_payment_type, c_increase_on_gross,

Line 1014: ,pn_index_leases_all pil

1010: SELECT ppt.payment_term_id
1011: ,NVL(ppt.actual_amount,ppt.estimated_amount)
1012: ,ppt.frequency_code
1013: FROM pn_payment_terms_all ppt
1014: ,pn_index_leases_all pil
1015: WHERE pil.index_lease_id = p_index_lease_id
1016: AND ppt.lease_id = pil.lease_id
1017: AND ppt.payment_term_type_code
1018: = DECODE(p_payment_type,c_increase_on_gross,

Line 1050: ,pn_index_leases_all pil

1046: SELECT ppt.payment_term_id
1047: ,NVL(ppt.actual_amount,ppt.estimated_amount)
1048: ,ppt.frequency_code
1049: FROM pn_payment_terms_all ppt
1050: ,pn_index_leases_all pil
1051: WHERE pil.index_lease_id = p_index_lease_id
1052: AND ppt.lease_id = pil.lease_id
1053: AND ppt.payment_term_type_code
1054: = DECODE(p_payment_type,c_increase_on_gross,

Line 1082: FROM pn_index_leases_all

1078: AND ppt.currency_code = pil.currency_code;
1079:
1080: CURSOR org_id_cur IS
1081: SELECT org_id, increase_on
1082: FROM pn_index_leases_all
1083: WHERE index_lease_id = p_index_lease_id;
1084:
1085: BEGIN
1086:

Line 1291: -- 13-FEB-04 ftanudja o removed redundant 'UPDATE pn_index_leases set initial_basis..' 3436147

1287: ------------------------------------------------------------------------
1288: -- PROCEDURE : calculate_basis_amount
1289: -- DESCRIPTION: This procedure will calculate the basis amount for a given index rent period
1290: -- HISTORY
1291: -- 13-FEB-04 ftanudja o removed redundant 'UPDATE pn_index_leases set initial_basis..' 3436147
1292: -- 05-JUN-07 Prabhakar o bug #6110109. In case of compound, the annulaised basis amount
1293: -- amount is made zero instead of NULL, when basis amount is zero.
1294: ------------------------------------------------------------------------
1295:

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 2136: Previous CPI = Base Index Value from Agreement (PN_INDEX_LEASES.BASE_INDEX)

2132: Note: Finder date lookup only match the year and month and not the day.
2133:
2134: IF REFERENCE_PERIOD = Base Year (Code: ??) THEN
2135:
2136: Previous CPI = Base Index Value from Agreement (PN_INDEX_LEASES.BASE_INDEX)
2137:
2138: ELSE IF REFERENCE_PERIOD = Previous Year (Code: ??) THEN
2139:
2140: 1> Take the elapsed time between the current assessment date and the prevous period's assessment

Line 2660: FROM pn_index_leases_all

2656: l_index_finder_method VARCHAR2(30);
2657:
2658: CURSOR get_index_finder IS
2659: SELECT index_finder_method
2660: FROM pn_index_leases_all
2661: WHERE index_lease_id = p_index_lease_id;
2662:
2663: BEGIN
2664:

Line 2754: FROM pn_index_leases_all

2750: v_index_termination_date DATE;
2751:
2752: CURSOR ref_period_cur(p_index_lease_id NUMBER) IS
2753: SELECT basis_type,reference_period,assessment_interval,termination_date
2754: FROM pn_index_leases_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

Line 2990: l_gross_flag PN_INDEX_LEASES_ALL.GROSS_FLAG%TYPE;

2986: ,op_msg OUT NOCOPY VARCHAR2
2987: )
2988: AS
2989:
2990: l_gross_flag PN_INDEX_LEASES_ALL.GROSS_FLAG%TYPE;
2991:
2992: CURSOR cur_unq_comb (
2993: ip_index_lease_id IN NUMBER
2994: ,ip_basis_start_date IN DATE

Line 3013: pn_index_leases_all pil

3009: ,ppt.include_in_var_rent
3010: ,build_distributions_string (ppt.payment_term_id) "DISTRIBUTION_STRING"
3011: ,NVL (ppt.normalize, 'N') "NORMALIZE"
3012: FROM pn_payment_terms_all ppt,
3013: pn_index_leases_all pil
3014: WHERE pil.index_lease_id = ip_index_lease_id
3015: AND ppt.lease_id = pil.lease_id
3016: AND nvl(ppt.status,'-1') = decode(ppt.index_period_id,null,nvl(ppt.status,'-1'),'APPROVED')
3017: AND ppt.end_date >= ip_basis_start_date AND ppt.start_date <= ip_basis_end_date

Line 3223: FROM pn_index_leases_all

3219: AND build_distributions_string(term.payment_term_id) = p_distribution_string;
3220:
3221: CURSOR org_id_cur IS
3222: SELECT org_id
3223: FROM pn_index_leases_all
3224: WHERE index_lease_id = p_index_lease_id;
3225:
3226: CURSOR gross_flag_cur IS
3227: SELECT NVL(GROSS_FLAG,'N')

Line 3228: FROM pn_index_leases_all

3224: WHERE index_lease_id = p_index_lease_id;
3225:
3226: CURSOR gross_flag_cur IS
3227: SELECT NVL(GROSS_FLAG,'N')
3228: FROM pn_index_leases_all
3229: WHERE index_lease_id = p_index_lease_id;
3230:
3231: v_op_sum_amount NUMBER := 0;
3232: v_payment_amount NUMBER := 0;

Line 3319: FROM pn_index_leases_all

3315: l_backbill_normalize VARCHAR2(1);
3316:
3317: CURSOR ref_period_cur ( p_index_lease_id NUMBER) IS
3318: SELECT reference_period
3319: FROM pn_index_leases_all
3320: WHERE index_lease_id = p_index_lease_id;
3321:
3322:
3323: BEGIN

Line 4315: FROM pn_index_leases_all

4311: v_reference_period_type VARCHAR2(30);
4312:
4313: CURSOR ref_period_cur ( p_index_lease_id NUMBER) IS
4314: SELECT reference_period
4315: FROM pn_index_leases_all
4316: WHERE index_lease_id = p_index_lease_id;
4317:
4318: l_backbill_st_date DATE;
4319: l_backbill_end_date DATE;

Line 5164: FROM pn_index_leases_all

5160: WHERE payment_term_id = ip_payment_term_id;
5161:
5162: CURSOR get_location_id IS
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);

Line 5178: FROM pn_index_leases_all

5174:
5175:
5176: CURSOR get_vr_nbp_flag IS
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);

Line 5895: -- 13-FEB-04 ftanudja o Fixed logic for 'UPDATE pn_index_leases set

5891: -- DESCRIPTION: This procedure will calculate the index amount for a period
5892: -- o Calculate Basis Amount
5893: -- o Calculate Index Percentage Change (if necessary)
5894: -- HISTORY
5895: -- 13-FEB-04 ftanudja o Fixed logic for 'UPDATE pn_index_leases set
5896: -- initial_basis..' Bug # 3436147
5897: -- 08-OCT-04 Satish o BUG# 3961117. Get calculate_date and pass it for not to
5898: -- create backbills if Assessment Date <= CutOff Date.
5899: -- 03-Feb-05 Vivek o Bug 4099136. Select NULL as purpose in cursor c1

Line 6008: FROM pn_index_leases_all pil,

6004: ,nvl (pilp.index_multiplier, 1) "INDEX_MULTIPLIER"
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

Line 6556: v_initial_basis pn_index_leases.initial_basis%type;

6552: v_constraint_applied_amount pn_index_lease_periods.constraint_applied_amount%type;
6553: v_carry_forward_amount pn_index_lease_periods.carry_forward_amount%type;
6554: v_constraint_applied_percent pn_index_lease_periods.constraint_applied_percent%type;
6555: v_carry_forward_percent pn_index_lease_periods.carry_forward_percent%type;
6556: v_initial_basis pn_index_leases.initial_basis%type;
6557: v_retain_initial_basis_flag pn_index_leases.retain_initial_basis_flag%type;
6558: v_msg VARCHAR2(1000);
6559:
6560:

Line 6557: v_retain_initial_basis_flag pn_index_leases.retain_initial_basis_flag%type;

6553: v_carry_forward_amount pn_index_lease_periods.carry_forward_amount%type;
6554: v_constraint_applied_percent pn_index_lease_periods.constraint_applied_percent%type;
6555: v_carry_forward_percent pn_index_lease_periods.carry_forward_percent%type;
6556: v_initial_basis pn_index_leases.initial_basis%type;
6557: v_retain_initial_basis_flag pn_index_leases.retain_initial_basis_flag%type;
6558: v_msg VARCHAR2(1000);
6559:
6560:
6561: CURSOR c1 (

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 6627: UPDATE pn_index_leases_all

6623: op_msg => v_msg
6624: );
6625:
6626: IF v_msg IS NULL THEN
6627: UPDATE pn_index_leases_all
6628: SET initial_basis = v_initial_basis
6629: ,last_update_date = SYSDATE
6630: ,last_updated_by = NVL (fnd_profile.VALUE ('USER_ID'), 0)
6631: WHERE index_lease_id = v_index_lease_id;

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 7049: UPDATE pn_index_leases_all

7045: ,ip_recalculate => ip_recalculate
7046: ,op_msg => v_msg
7047: );
7048:
7049: UPDATE pn_index_leases_all
7050: SET base_index = v_new_index_figure
7051: WHERE index_lease_id = ilp_rec.index_lease_id
7052: AND base_year = v_updated_index_date;
7053:

Line 7182: -- 25-Nov-2005 pikhar o Replaced pn_index_leases_all with pn_index_leases

7178: -- Fix for bug# 2235148.
7179: -- 13-Jul-2004 ftanudja o Added parameter ip_auto_find_sch_day. #3701195.
7180: -- 18-Jan-2005 ftanudja o Added batch commit capability. #4081821.
7181: -- 19-Jan-2005 ftanudja o Fixed il_recs CSR for range queries. #4129147.
7182: -- 25-Nov-2005 pikhar o Replaced pn_index_leases_all with pn_index_leases
7183: -- 09-JAN-07 lbala o Removed call to get_schedule_date and auto creation
7184: -- of shedules for M28 item# 11
7185: -------------------------------------------------------------------------------
7186:

Line 7261: ,pn_index_leases pil

7257: ,ppt.status
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