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_ALL

Line 237: FROM pn_index_leases_all pil, pn_lease_details_all pld

233: ,pil.termination_date
234: ,pil.assessment_interval
235: ,pil.relationship_default
236: ,pil.basis_percent_default
237: FROM pn_index_leases_all pil, pn_lease_details_all pld
238: WHERE pld.lease_id = pil.lease_id
239: AND pil.index_lease_id = ip_index_lease_id;
240:
241: tlinfo il_rec%ROWTYPE;

Line 533: FROM pn_index_leases_all

529: v_org_id NUMBER;
530:
531: CURSOR c IS
532: SELECT ORG_ID
533: FROM pn_index_leases_all
534: WHERE index_lease_id = p_index_lease_id;
535: BEGIN
536: -- all date calculation uses month
537: -- convert assessment frequency from years to month

Line 708: FROM pn_index_leases_all pil

704: ,pil.assessment_date "DATE_ASSESSED"
705: ,pil.assessment_interval
706: ,pil.relationship_default
707: ,pil.basis_percent_default
708: FROM pn_index_leases_all pil
709: WHERE pil.index_lease_id = ip_index_lease_id;
710:
711: CURSOR index_lease_periods (
712: ip_index_lease_id IN NUMBER) IS

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

870: -- ip_index_lease_high_num - Index Number (To)
871: --
872: -- 07-Mar-02 lkatputu o Bug#2254491. datatype of p_index_lease_num changed from
873: -- NUMBER to VARCHAR2 in the Cursor index_lease_periods.
874: -- 25-NOV-05 Kiran o replaced pn_index_leases_all with pn_index_leases
875: -- 24-NOV-06 Prabhakar o Added index_multiplier in cursor attributes.
876: --------------------------------------------------------------------------------
877: PROCEDURE generate_periods_batch (
878: errbuf OUT NOCOPY VARCHAR2

Line 1033: FROM pn_index_leases_all pil, pn_lease_details_all pld

1029: ,pil.relationship_default
1030: ,pil.basis_percent_default
1031: ,pil.index_finder_months
1032: ,nvl (pil.index_multiplier, 1) "INDEX_MULTIPLIER"
1033: FROM pn_index_leases_all pil, pn_lease_details_all pld
1034: WHERE pld.lease_id = pil.lease_id
1035: AND pil.index_lease_id = p_index_lease_id;
1036:
1037: v_msg VARCHAR2 (100);

Line 1111: pn_index_leases_all ilease,

1107:
1108: CURSOR approved_sched_exist(p_index_lease_id IN NUMBER) IS
1109: SELECT term.payment_term_id
1110: FROM pn_payment_schedules_all sched,
1111: pn_index_leases_all ilease,
1112: pn_payment_terms_all term,
1113: pn_payment_items_all item,
1114: pn_index_lease_periods_all period
1115: WHERE sched.lease_id = ilease.lease_id

Line 1174: DELETE FROM pn_index_leases_all

1170:
1171: DELETE FROM pn_index_lease_periods_all
1172: WHERE index_lease_id = p_index_lease_id ;
1173:
1174: DELETE FROM pn_index_leases_all
1175: WHERE index_lease_id = p_index_lease_id ;
1176:
1177: put_log(' deleted agreements');
1178:

Line 1231: FROM pn_index_leases_all pil, pn_lease_details_all pld

1227: ,pil.relationship_default
1228: ,pil.basis_percent_default
1229: ,pil.index_finder_months
1230: ,nvl (pil.index_multiplier, 1) "INDEX_MULTIPLIER"
1231: FROM pn_index_leases_all pil, pn_lease_details_all pld
1232: WHERE pld.lease_id = pil.lease_id
1233: AND pil.index_lease_id = ip_index_lease_id;
1234:
1235: tlinfo il_rec%ROWTYPE;

Line 1742: FROM pn_index_leases_all pil

1738: ,pil.rounding_flag
1739: ,pil.org_id
1740: ,pil.basis_type
1741: ,pil.reference_period
1742: FROM pn_index_leases_all pil
1743: WHERE pil.lease_id = ip_lease_id;
1744:
1745: tlinfo il_rec%ROWTYPE;
1746: v_msg VARCHAR2 (1000);

Line 1759: FROM pn_index_leases_all

1755: WHERE index_lease_id = p_index_lease_id;
1756:
1757: CURSOR extendable_index_cur(p_old_ls_end_date IN DATE) IS
1758: SELECT index_lease_id
1759: FROM pn_index_leases_all
1760: WHERE lease_id = p_lease_id
1761: AND termination_date = p_old_ls_end_date;
1762:
1763: CURSOR index_periods_cur (p_index_lease_id NUMBER ) IS

Line 1837: l_basis_type PN_INDEX_LEASES_ALL.BASIS_TYPE%TYPE; -- added for bug #11671285

1833: l_lease_num PN_LEASES_ALL.lease_num%TYPE;
1834: l_ri_term_rec pn_payment_terms_all%ROWTYPE;
1835: v_end_date DATE; -- added for bug #11671285
1836: l_period_id pn_payment_terms_all.index_period_id%TYPE; /* 9263195 */ -- added for bug #11671285
1837: l_basis_type PN_INDEX_LEASES_ALL.BASIS_TYPE%TYPE; -- added for bug #11671285
1838: l_ref_period PN_INDEX_LEASES_ALL.reference_period%TYPE; -- added for bug #11671285
1839: TYPE rec is record(index_id NUMBER,term_id NUMBER,period_id NUMBER); -- added for bug #11671285
1840: TYPE tab is table of rec INDEX BY BINARY_INTEGER; -- added for bug #11671285
1841: l_term tab; -- added for bug #11671285

Line 1838: l_ref_period PN_INDEX_LEASES_ALL.reference_period%TYPE; -- added for bug #11671285

1834: l_ri_term_rec pn_payment_terms_all%ROWTYPE;
1835: v_end_date DATE; -- added for bug #11671285
1836: l_period_id pn_payment_terms_all.index_period_id%TYPE; /* 9263195 */ -- added for bug #11671285
1837: l_basis_type PN_INDEX_LEASES_ALL.BASIS_TYPE%TYPE; -- added for bug #11671285
1838: l_ref_period PN_INDEX_LEASES_ALL.reference_period%TYPE; -- added for bug #11671285
1839: TYPE rec is record(index_id NUMBER,term_id NUMBER,period_id NUMBER); -- added for bug #11671285
1840: TYPE tab is table of rec INDEX BY BINARY_INTEGER; -- added for bug #11671285
1841: l_term tab; -- added for bug #11671285
1842: l_term_index NUMBER := 1; -- added for bug #11671285

Line 1881: UPDATE pn_index_leases_all

1877:
1878: --
1879: -- update index rent with a new termination date
1880: --
1881: UPDATE pn_index_leases_all
1882: SET termination_date = GREATEST(p_new_main_lease_term_date,commencement_date)
1883: ,last_update_date = SYSDATE
1884: ,last_updated_by = fnd_global.user_id
1885: ,last_update_login = fnd_global.login_id

Line 2128: UPDATE pn_index_leases_all

2124:
2125:
2126: FOR index_leases_rec IN extendable_index_cur(l_old_ls_end_date)
2127: LOOP
2128: UPDATE pn_index_leases_all
2129: SET termination_date = p_new_main_lease_term_date,
2130: last_update_date = SYSDATE,
2131: last_updated_by = NVL(fnd_profile.value('USER_ID'),0),
2132: last_update_login = NVL(fnd_profile.value('LOGIN_ID'),0)

Line 2195: FROM PN_PAYMENT_TERMS_ALL PP,PN_INDEX_LEASES_ALL PI

2191: l_ri_term_rec := appr_terms_rec;
2192: /* added for bug #11671285*/
2193: select INDEX_PERIOD_ID,basis_type,reference_period
2194: into l_period_id,l_basis_type,l_ref_period
2195: FROM PN_PAYMENT_TERMS_ALL PP,PN_INDEX_LEASES_ALL PI
2196: WHERE PP.PAYMENT_TERM_ID = l_ri_term_rec.payment_term_id
2197: and pp.LEASE_ID = pi.LEASE_ID
2198: and rownum=1;
2199:

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

2317: ,pilp.basis_end_date
2318: ,pilp.line_number
2319: ,pil.initial_basis
2320: ,pil.retain_initial_basis_flag
2321: FROM pn_leases_all pl, pn_index_leases_all pil, pn_index_lease_periods_all pilp
2322: WHERE pl.lease_id = pil.lease_id
2323: AND pil.index_lease_id = pilp.index_lease_id
2324: AND pl.lease_id=p_lease_id
2325: AND exists(SELECT 'x'

Line 2326: FROM pn_index_leases_all pilx

2322: WHERE pl.lease_id = pil.lease_id
2323: AND pil.index_lease_id = pilp.index_lease_id
2324: AND pl.lease_id=p_lease_id
2325: AND exists(SELECT 'x'
2326: FROM pn_index_leases_all pilx
2327: WHERE ip_payment_end_date >=(SELECT min(pilpx.basis_start_date)
2328: FROM pn_index_lease_periods_all pilpx
2329: WHERE pilpx.index_lease_id=pilx.index_lease_id)
2330: AND pilx.termination_date >= ip_payment_start_date

Line 2368: UPDATE pn_index_leases_all

2364: p_index_lease_id => rec1.index_lease_id
2365: ,op_basis_amount => v_initial_basis_amt
2366: ,op_msg => v_msg);
2367:
2368: UPDATE pn_index_leases_all
2369: SET initial_basis = v_initial_basis_amt
2370: ,last_update_date = SYSDATE
2371: ,last_updated_by = NVL (fnd_profile.VALUE ('USER_ID'), 0)
2372: WHERE index_lease_id = rec1.index_lease_id;

Line 2443: FROM pn_index_leases_all

2439: CURSOR get_mtm_terms( p_lease_id NUMBER,p_term_end_date DATE) IS
2440: SELECT *
2441: FROM pn_payment_terms_all terms
2442: WHERE index_period_id IN ( SELECT index_period_id
2443: FROM pn_index_leases_all
2444: WHERE lease_id = p_lease_id)
2445: AND end_date = p_term_end_date
2446: AND lease_id = p_lease_id
2447: AND frequency_code <> 'OT';

Line 2452: FROM pn_index_leases_all ileases,

2448:
2449: CURSOR get_index_lease_details( p_payment_term_id NUMBER) Is
2450: SELECT basis_type,
2451: reference_period
2452: FROM pn_index_leases_all ileases,
2453: pn_index_lease_periods_all periods,
2454: pn_payment_terms_all terms
2455: WHERE ileases.index_lease_id = periods.index_lease_id
2456: AND periods.index_period_id = terms.index_period_id

Line 2611: SELECT lease_id FROM pn_index_leases_all

2607: l_lst_cash_sch_dt DATE;
2608: l_var_rent_id NUMBER;
2609:
2610: CURSOR get_lease_id IS
2611: SELECT lease_id FROM pn_index_leases_all
2612: WHERE index_lease_id = p_index_lease_id;
2613:
2614: CURSOR get_ri_terms_to_modify IS
2615: SELECT *

Line 2647: FROM pn_index_leases_all

2643: lease_termination_date,
2644: ROUND(MONTHS_BETWEEN(lease_termination_date,lease_commencement_date))+1 p_mts
2645: FROM pn_lease_details_all
2646: WHERE lease_id IN (SELECT lease_id
2647: FROM pn_index_leases_all
2648: WHERE index_lease_id = p_index_lease_id);
2649:
2650: CURSOR approved_sched_exist_cur(p_payment_term_id IN NUMBER)
2651: IS

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

2668: CURSOR draft_schedule_exists_cur (p_sched_date DATE) IS
2669: SELECT pps.payment_schedule_id
2670: FROM pn_payment_schedules_all pps
2671: WHERE pps.schedule_date = p_sched_date
2672: AND pps.lease_id IN (SELECT lease_id FROM pn_index_leases_all
2673: WHERE index_lease_id = p_index_lease_id)
2674: AND pps.payment_status_lookup_code = 'DRAFT';
2675:
2676: CURSOR cash_item_exist_cur(p_sched_id NUMBER,p_payment_term_id IN NUMBER) IS