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_ALL

Line 933: ,pn_index_leases_all pil

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

Line 973: ,pn_index_leases_all pil

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

Line 1015: ,pn_index_leases_all pil

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

Line 1051: ,pn_index_leases_all pil

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

Line 1083: FROM pn_index_leases_all

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

Line 1505: FROM pn_index_leases_all pil, pn_index_lease_periods_all pilp

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

Line 2661: FROM pn_index_leases_all

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

Line 2755: FROM pn_index_leases_all

2751: v_index_termination_date DATE;
2752:
2753: CURSOR ref_period_cur(p_index_lease_id NUMBER) IS
2754: SELECT basis_type,reference_period,assessment_interval,termination_date
2755: FROM pn_index_leases_all
2756: WHERE index_lease_id = p_index_lease_id;
2757:
2758: CURSOR assessment_date_cur(p_index_lease_id NUMBER) IS
2759: SELECT assessment_date, index_period_id

Line 2991: l_gross_flag PN_INDEX_LEASES_ALL.GROSS_FLAG%TYPE;

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

Line 3014: pn_index_leases_all pil

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

Line 3224: FROM pn_index_leases_all

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

Line 3229: FROM pn_index_leases_all

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

Line 3320: FROM pn_index_leases_all

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

Line 4317: FROM pn_index_leases_all

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

Line 5166: FROM pn_index_leases_all

5162: WHERE payment_term_id = ip_payment_term_id;
5163:
5164: CURSOR get_location_id IS
5165: SELECT location_id
5166: FROM pn_index_leases_all
5167: WHERE index_lease_id =
5168: (SELECT index_lease_id
5169: FROM pn_index_lease_periods_all
5170: WHERE index_period_id = p_index_period_id);

Line 5180: FROM pn_index_leases_all

5176:
5177:
5178: CURSOR get_vr_nbp_flag IS
5179: SELECT vr_nbp_flag
5180: FROM pn_index_leases_all
5181: WHERE index_lease_id =
5182: (SELECT index_lease_id
5183: FROM pn_index_lease_periods_all
5184: WHERE index_period_id = p_index_period_id);

Line 6010: FROM pn_index_leases_all pil,

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

Line 6571: FROM pn_index_leases_all pil, pn_index_lease_periods_all pilp

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

Line 6585: FROM pn_index_leases_all pil, pn_index_lease_periods_all pilp

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

Line 6629: UPDATE pn_index_leases_all

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

Line 7051: UPDATE pn_index_leases_all

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

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

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