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

Line 232: FROM pn_index_leases_all pil, pn_lease_details_all pld

228: ,pil.termination_date
229: ,pil.assessment_interval
230: ,pil.relationship_default
231: ,pil.basis_percent_default
232: FROM pn_index_leases_all pil, pn_lease_details_all pld
233: WHERE pld.lease_id = pil.lease_id
234: AND pil.index_lease_id = ip_index_lease_id;
235:
236: tlinfo il_rec%ROWTYPE;

Line 505: ,p_relationship_default pn_index_leases.relationship_default%TYPE

501: ,p_ml_start_dt DATE
502: ,p_date_assessed DATE
503: ,p_assessment_freq_years NUMBER
504: ,p_index_finder_months NUMBER
505: ,p_relationship_default pn_index_leases.relationship_default%TYPE
506: ,p_basis_percent_default pn_index_leases.basis_percent_default%TYPE
507: ,p_starting_period_num NUMBER
508: ,p_index_multiplier NUMBER)
509: IS

Line 506: ,p_basis_percent_default pn_index_leases.basis_percent_default%TYPE

502: ,p_date_assessed DATE
503: ,p_assessment_freq_years NUMBER
504: ,p_index_finder_months NUMBER
505: ,p_relationship_default pn_index_leases.relationship_default%TYPE
506: ,p_basis_percent_default pn_index_leases.basis_percent_default%TYPE
507: ,p_starting_period_num NUMBER
508: ,p_index_multiplier NUMBER)
509: IS
510: v_basis_start_date DATE;

Line 525: FROM pn_index_leases_all

521: v_org_id NUMBER;
522:
523: CURSOR c IS
524: SELECT ORG_ID
525: FROM pn_index_leases_all
526: WHERE index_lease_id = p_index_lease_id;
527: BEGIN
528: -- all date calculation uses month
529: -- convert assessment frequency from years to month

Line 700: FROM pn_index_leases_all pil

696: ,pil.assessment_date "DATE_ASSESSED"
697: ,pil.assessment_interval
698: ,pil.relationship_default
699: ,pil.basis_percent_default
700: FROM pn_index_leases_all pil
701: WHERE pil.index_lease_id = ip_index_lease_id;
702:
703: CURSOR index_lease_periods (
704: ip_index_lease_id IN NUMBER) IS

Line 866: -- 25-NOV-05 Kiran o replaced pn_index_leases_all with pn_index_leases

862: -- ip_index_lease_high_num - Index Number (To)
863: --
864: -- 07-Mar-02 lkatputu o Bug#2254491. datatype of p_index_lease_num changed from
865: -- NUMBER to VARCHAR2 in the Cursor index_lease_periods.
866: -- 25-NOV-05 Kiran o replaced pn_index_leases_all with pn_index_leases
867: -- 24-NOV-06 Prabhakar o Added index_multiplier in cursor attributes.
868: --------------------------------------------------------------------------------
869: PROCEDURE generate_periods_batch (
870: errbuf OUT NOCOPY VARCHAR2

Line 887: FROM pn_index_leases pil

883: ,pil.relationship_default
884: ,pil.basis_percent_default
885: ,pil.index_finder_months
886: ,nvl (pil.index_multiplier,1) "INDEX_MULTIPLIER"
887: FROM pn_index_leases pil
888: ,pn_lease_details_all pld
889: WHERE pld.lease_id = pil.lease_id
890: AND ( pil.index_lease_number = p_index_lease_num
891: OR p_index_lease_num IS NULL)

Line 1025: FROM pn_index_leases_all pil, pn_lease_details_all pld

1021: ,pil.relationship_default
1022: ,pil.basis_percent_default
1023: ,pil.index_finder_months
1024: ,nvl (pil.index_multiplier, 1) "INDEX_MULTIPLIER"
1025: FROM pn_index_leases_all pil, pn_lease_details_all pld
1026: WHERE pld.lease_id = pil.lease_id
1027: AND pil.index_lease_id = p_index_lease_id;
1028:
1029: v_msg VARCHAR2 (100);

Line 1103: pn_index_leases_all ilease,

1099:
1100: CURSOR approved_sched_exist(p_index_lease_id IN NUMBER) IS
1101: SELECT term.payment_term_id
1102: FROM pn_payment_schedules_all sched,
1103: pn_index_leases_all ilease,
1104: pn_payment_terms_all term,
1105: pn_payment_items_all item,
1106: pn_index_lease_periods_all period
1107: WHERE sched.lease_id = ilease.lease_id

Line 1166: DELETE FROM pn_index_leases_all

1162:
1163: DELETE FROM pn_index_lease_periods_all
1164: WHERE index_lease_id = p_index_lease_id ;
1165:
1166: DELETE FROM pn_index_leases_all
1167: WHERE index_lease_id = p_index_lease_id ;
1168:
1169: put_log(' deleted agreements');
1170:

Line 1223: FROM pn_index_leases_all pil, pn_lease_details_all pld

1219: ,pil.relationship_default
1220: ,pil.basis_percent_default
1221: ,pil.index_finder_months
1222: ,nvl (pil.index_multiplier, 1) "INDEX_MULTIPLIER"
1223: FROM pn_index_leases_all pil, pn_lease_details_all pld
1224: WHERE pld.lease_id = pil.lease_id
1225: AND pil.index_lease_id = ip_index_lease_id;
1226:
1227: tlinfo il_rec%ROWTYPE;

Line 1731: FROM pn_index_leases_all pil

1727: ,pil.rounding_flag
1728: ,pil.org_id
1729: ,pil.basis_type
1730: ,pil.reference_period
1731: FROM pn_index_leases_all pil
1732: WHERE pil.lease_id = ip_lease_id;
1733:
1734: tlinfo il_rec%ROWTYPE;
1735: v_msg VARCHAR2 (1000);

Line 1748: FROM pn_index_leases_all

1744: WHERE index_lease_id = p_index_lease_id;
1745:
1746: CURSOR extendable_index_cur(p_old_ls_end_date IN DATE) IS
1747: SELECT index_lease_id
1748: FROM pn_index_leases_all
1749: WHERE lease_id = p_lease_id
1750: AND termination_date = p_old_ls_end_date;
1751:
1752: CURSOR index_periods_cur (p_index_lease_id NUMBER ) IS

Line 1849: UPDATE pn_index_leases_all

1845:
1846: --
1847: -- update index rent with a new termination date
1848: --
1849: UPDATE pn_index_leases_all
1850: SET termination_date = GREATEST(p_new_main_lease_term_date,commencement_date)
1851: ,last_update_date = SYSDATE
1852: ,last_updated_by = fnd_global.user_id
1853: ,last_update_login = fnd_global.login_id

Line 2065: UPDATE pn_index_leases_all

2061:
2062:
2063: FOR index_leases_rec IN extendable_index_cur(l_old_ls_end_date)
2064: LOOP
2065: UPDATE pn_index_leases_all
2066: SET termination_date = p_new_main_lease_term_date,
2067: last_update_date = SYSDATE,
2068: last_updated_by = NVL(fnd_profile.value('USER_ID'),0),
2069: last_update_login = NVL(fnd_profile.value('LOGIN_ID'),0)

Line 2195: FROM pn_leases_all pl, pn_index_leases_all pil, pn_index_lease_periods_all pilp

2191: ,pilp.basis_end_date
2192: ,pilp.line_number
2193: ,pil.initial_basis
2194: ,pil.retain_initial_basis_flag
2195: FROM pn_leases_all pl, pn_index_leases_all pil, pn_index_lease_periods_all pilp
2196: WHERE pl.lease_id = pil.lease_id
2197: AND pil.index_lease_id = pilp.index_lease_id
2198: AND pl.lease_id=p_lease_id
2199: AND exists(SELECT 'x'

Line 2200: FROM pn_index_leases_all pilx

2196: WHERE pl.lease_id = pil.lease_id
2197: AND pil.index_lease_id = pilp.index_lease_id
2198: AND pl.lease_id=p_lease_id
2199: AND exists(SELECT 'x'
2200: FROM pn_index_leases_all pilx
2201: WHERE ip_payment_end_date >=(SELECT min(pilpx.basis_start_date)
2202: FROM pn_index_lease_periods_all pilpx
2203: WHERE pilpx.index_lease_id=pilx.index_lease_id)
2204: AND pilx.termination_date >= ip_payment_start_date

Line 2242: UPDATE pn_index_leases_all

2238: p_index_lease_id => rec1.index_lease_id
2239: ,op_basis_amount => v_initial_basis_amt
2240: ,op_msg => v_msg);
2241:
2242: UPDATE pn_index_leases_all
2243: SET initial_basis = v_initial_basis_amt
2244: ,last_update_date = SYSDATE
2245: ,last_updated_by = NVL (fnd_profile.VALUE ('USER_ID'), 0)
2246: WHERE index_lease_id = rec1.index_lease_id;

Line 2317: FROM pn_index_leases_all

2313: CURSOR get_mtm_terms( p_lease_id NUMBER,p_term_end_date DATE) IS
2314: SELECT *
2315: FROM pn_payment_terms_all terms
2316: WHERE index_period_id IN ( SELECT index_period_id
2317: FROM pn_index_leases_all
2318: WHERE lease_id = p_lease_id)
2319: AND end_date = p_term_end_date
2320: AND lease_id = p_lease_id
2321: AND frequency_code <> 'OT';

Line 2326: FROM pn_index_leases_all ileases,

2322:
2323: CURSOR get_index_lease_details( p_payment_term_id NUMBER) Is
2324: SELECT basis_type,
2325: reference_period
2326: FROM pn_index_leases_all ileases,
2327: pn_index_lease_periods_all periods,
2328: pn_payment_terms_all terms
2329: WHERE ileases.index_lease_id = periods.index_lease_id
2330: AND periods.index_period_id = terms.index_period_id

Line 2482: SELECT lease_id FROM pn_index_leases_all

2478: l_lst_cash_sch_dt DATE;
2479: l_var_rent_id NUMBER;
2480:
2481: CURSOR get_lease_id IS
2482: SELECT lease_id FROM pn_index_leases_all
2483: WHERE index_lease_id = p_index_lease_id;
2484:
2485: CURSOR get_ri_terms_to_modify IS
2486: SELECT *

Line 2503: FROM pn_index_leases_all

2499: lease_termination_date,
2500: ROUND(MONTHS_BETWEEN(lease_termination_date,lease_commencement_date))+1 p_mts
2501: FROM pn_lease_details_all
2502: WHERE lease_id IN (SELECT lease_id
2503: FROM pn_index_leases_all
2504: WHERE index_lease_id = p_index_lease_id);
2505:
2506: CURSOR approved_sched_exist_cur(p_payment_term_id IN NUMBER)
2507: IS

Line 2528: AND pps.lease_id IN (SELECT lease_id FROM pn_index_leases_all

2524: CURSOR draft_schedule_exists_cur (p_sched_date DATE) IS
2525: SELECT pps.payment_schedule_id
2526: FROM pn_payment_schedules_all pps
2527: WHERE pps.schedule_date = p_sched_date
2528: AND pps.lease_id IN (SELECT lease_id FROM pn_index_leases_all
2529: WHERE index_lease_id = p_index_lease_id)
2530: AND pps.payment_status_lookup_code = 'DRAFT';
2531:
2532: CURSOR cash_item_exist_cur(p_sched_id NUMBER,p_payment_term_id IN NUMBER) IS