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_LEASE_PERIODS_ALL

Line 335: FROM pn_index_lease_periods_all pilp

331: ip_index_lease_id IN NUMBER
332: ,ip_index_period_id IN NUMBER) IS
333: SELECT pilp.index_lease_id,
334: pilp.index_period_id
335: FROM pn_index_lease_periods_all pilp
336: WHERE pilp.index_lease_id = ip_index_lease_id
337: AND ( pilp.index_period_id = ip_index_period_id
338: OR ip_index_period_id IS NULL);
339:

Line 347: FROM pn_index_lease_periods_all pilp, pn_payment_terms_all ppt

343: ,ip_index_period_id IN NUMBER) IS
344: SELECT pilp.index_period_id
345: ,ppt.payment_term_id
346: ,ppt.lease_id
347: FROM pn_index_lease_periods_all pilp, pn_payment_terms_all ppt
348: WHERE pilp.index_lease_id = ip_index_lease_id
349: AND pilp.index_period_id = ppt.index_period_id
350: AND pilp.index_period_id = ip_index_period_id;
351: var number;

Line 365: FROM pn_index_lease_periods_all

361: AND sched.payment_status_lookup_code = 'APPROVED');
362:
363: CURSOR get_latest_period IS
364: SELECT index_period_id
365: FROM pn_index_lease_periods_all
366: WHERE index_lease_id = p_index_lease_id
367: AND assessment_date <= p_new_termination_date
368: ORDER BY assessment_date DESC;
369:

Line 486: DELETE pn_index_lease_periods_all

482:
483: --
484: -- deleting index rent period record.
485: --
486: DELETE pn_index_lease_periods_all
487: WHERE index_lease_id = p_index_lease_id
488: AND index_period_id = il_rec_periods.index_period_id;
489: --DBMS_OUTPUT.put_line ('deleting periods...'||sql%rowcount);
490: end loop;

Line 718: FROM pn_index_lease_periods_all pilp

714: ,pilp.basis_start_date
715: ,pilp.basis_end_date
716: ,pilp.index_finder_date
717: ,pilp.assessment_date
718: FROM pn_index_lease_periods_all pilp
719: WHERE pilp.index_lease_id = ip_index_lease_id
720: ORDER BY pilp.line_number;
721:
722: v_line_count NUMBER;

Line 1114: pn_index_lease_periods_all period

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
1116: AND sched.payment_schedule_id = item.payment_schedule_id
1117: AND item.payment_term_id = term.payment_term_id
1118: AND term.lease_id = ilease.lease_id

Line 1149: FROM pn_payment_terms_all term,pn_index_lease_periods_all iperiod

1145: WHERE index_lease_id = p_index_lease_id ;
1146:
1147: DELETE FROM pn_payment_items_all
1148: WHERE payment_term_id IN ( SELECT term.payment_term_id
1149: FROM pn_payment_terms_all term,pn_index_lease_periods_all iperiod
1150: WHERE term.index_period_id = iperiod.index_period_id
1151: AND iperiod.index_lease_id = p_index_lease_id
1152: AND term.index_period_id IS NOT NULL);
1153:

Line 1162: FROM pn_payment_terms_all term,pn_index_lease_periods_all period

1158: WHERE item.payment_schedule_id = sched.payment_schedule_id);
1159:
1160: DELETE FROM pn_distributions_all
1161: WHERE payment_term_id IN (SELECT payment_term_id
1162: FROM pn_payment_terms_all term,pn_index_lease_periods_all period
1163: WHERE term.index_period_id = period.index_period_id
1164: AND period.index_lease_id = p_index_lease_id);
1165:
1166: DELETE FROM pn_payment_terms_all

Line 1168: FROM pn_index_lease_periods_all

1164: AND period.index_lease_id = p_index_lease_id);
1165:
1166: DELETE FROM pn_payment_terms_all
1167: WHERE index_period_id IN (SELECT index_period_id
1168: FROM pn_index_lease_periods_all
1169: WHERE index_lease_id = p_index_lease_id);
1170:
1171: DELETE FROM pn_index_lease_periods_all
1172: WHERE index_lease_id = p_index_lease_id ;

Line 1171: DELETE FROM pn_index_lease_periods_all

1167: WHERE index_period_id IN (SELECT index_period_id
1168: FROM pn_index_lease_periods_all
1169: WHERE index_lease_id = p_index_lease_id);
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 ;

Line 1241: FROM pn_index_lease_periods_all pilp

1237: CURSOR il_recs_to_delete (ip_index_lease_id IN NUMBER
1238: ,ip_new_termination_date IN DATE)
1239: IS
1240: SELECT pilp.index_period_id
1241: FROM pn_index_lease_periods_all pilp
1242: WHERE pilp.index_lease_id = ip_index_lease_id
1243: AND pilp.assessment_date > ip_new_termination_date;
1244:
1245: v_latest_assessment_date DATE;

Line 1254: FROM pn_index_lease_periods_all

1250: BEGIN
1251: -- getting the latest assessment date for this index rent period
1252: SELECT MAX (assessment_date)
1253: INTO v_latest_assessment_date
1254: FROM pn_index_lease_periods_all
1255: WHERE index_lease_id = p_index_lease_id;
1256: -- retreive index lease information.
1257:
1258: OPEN il_rec (p_index_lease_id);

Line 1437: pn_index_lease_periods_all pilp

1433: decode(ppt.actual_amount,null,ppt.estimated_amount,ppt.actual_amount) term_amount,
1434: ppt.org_id,
1435: ppt.norm_end_date
1436: FROM pn_payment_terms_all ppt,
1437: pn_index_lease_periods_all pilp
1438: WHERE ppt.index_period_id = pilp.index_period_id
1439: AND pilp.index_lease_id = p_index_lease_id
1440: AND ppt.frequency_code = pn_index_amount_pkg.c_spread_frequency_one_time
1441: AND ppt.index_term_indicator not in(pn_index_amount_pkg.c_index_pay_term_type_atlst_bb,

Line 1754: FROM pn_index_lease_periods_all

1750: v_last_period_assess_end_date DATE;
1751:
1752: CURSOR get_last_index_period_cur(p_index_lease_id NUMBER) IS
1753: SELECT max(index_period_id) last_index_period_id, max(assessment_date) last_assessment_date
1754: FROM pn_index_lease_periods_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

Line 1765: FROM pn_index_lease_periods_all

1761: AND termination_date = p_old_ls_end_date;
1762:
1763: CURSOR index_periods_cur (p_index_lease_id NUMBER ) IS
1764: SELECT index_period_id
1765: FROM pn_index_lease_periods_all
1766: WHERE index_lease_id = p_index_lease_id
1767: AND assessment_date > p_old_main_lease_term_date;
1768:
1769: CURSOR get_term_4_mtm_update(p_index_lease_id NUMBER) IS

Line 1772: FROM pn_payment_terms_all term,pn_index_lease_periods_all period

1768:
1769: CURSOR get_term_4_mtm_update(p_index_lease_id NUMBER) IS
1770: SELECT term.payment_term_id payment_term_id,
1771: NVL(term.normalize,'N') normalize
1772: FROM pn_payment_terms_all term,pn_index_lease_periods_all period
1773: WHERE term.index_period_id = period.index_period_id
1774: AND period.index_lease_id = p_index_lease_id
1775: AND term.frequency_code <> pn_index_amount_pkg.c_spread_frequency_one_time
1776: AND term.end_date = p_old_main_lease_term_date;

Line 1804: FROM pn_payment_terms_all terms, pn_index_lease_periods_all period

1800: CURSOR get_appr_terms_to_extend(p_index_lease_id IN NUMBER) IS
1801: SELECT *
1802: FROM pn_payment_terms_all
1803: WHERE payment_term_id IN ( SELECT payment_term_id
1804: FROM pn_payment_terms_all terms, pn_index_lease_periods_all period
1805: WHERE terms.index_period_id = period.index_period_id
1806: AND period.index_lease_id = p_index_lease_id)
1807: AND status ='APPROVED'
1808: AND frequency_code <>'OT'

Line 1813: FROM pn_payment_terms_all ppt, pn_index_lease_periods_all pilp

1809: AND end_date = p_old_main_lease_term_date;
1810:
1811: CURSOR get_ri_terms_to_extend(p_index_lease_id IN NUMBER) IS --Bug16243330
1812: SELECT ppt.*
1813: FROM pn_payment_terms_all ppt, pn_index_lease_periods_all pilp
1814: WHERE pilp.index_period_id = ppt.index_period_id
1815: AND pilp.index_lease_id = p_index_lease_id
1816: AND p_lease_context <> 'CON'
1817: AND ppt.frequency_code <>

Line 1975: FROM pn_payment_terms_all ppt, pn_index_lease_periods_all pilp

1971: last_updated_by = fnd_global.user_id,
1972: last_update_login = fnd_global.login_id
1973: WHERE payment_term_id IN
1974: (SELECT ppt.payment_term_id
1975: FROM pn_payment_terms_all ppt, pn_index_lease_periods_all pilp
1976: WHERE pilp.index_period_id = ppt.index_period_id
1977: AND pilp.index_lease_id = c_rec.index_lease_id
1978: AND (ppt.status = pn_index_amount_pkg.c_payment_term_status_draft AND
1979: p_lease_context = 'CON')

Line 2000: FROM pn_payment_terms_all ppt, pn_index_lease_periods_all pilp

1996: last_updated_by = fnd_global.user_id,
1997: last_update_login = fnd_global.login_id
1998: WHERE payment_term_id IN
1999: (SELECT ppt.payment_term_id
2000: FROM pn_payment_terms_all ppt, pn_index_lease_periods_all pilp
2001: WHERE pilp.index_period_id = ppt.index_period_id
2002: AND pilp.index_lease_id = c_rec.index_lease_id
2003: AND (ppt.status = pn_index_amount_pkg.c_payment_term_status_draft AND
2004: p_lease_context = 'CON')

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 2328: FROM pn_index_lease_periods_all pilpx

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
2331: AND pilx.index_lease_id=pil.index_lease_id
2332: AND (pilx.increase_on=ip_payment_type_code OR

Line 2453: pn_index_lease_periods_all periods,

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
2457: AND terms.payment_term_id = p_payment_term_id;

Line 2618: FROM pn_index_lease_periods_all

2614: CURSOR get_ri_terms_to_modify IS
2615: SELECT *
2616: FROM pn_payment_terms_all
2617: WHERE ((index_period_id IN (SELECT index_period_id
2618: FROM pn_index_lease_periods_all
2619: WHERE index_lease_id = p_index_lease_id))
2620: /* -- OR commented for bug 16223906
2621: -- index_period_id IS NULL */
2622: )

Line 2631: FROM pn_index_lease_periods_all

2627: CURSOR get_ri_terms_to_exp IS
2628: SELECT *
2629: FROM pn_payment_terms_all
2630: WHERE ((index_period_id IN (SELECT index_period_id
2631: FROM pn_index_lease_periods_all
2632: WHERE index_lease_id = p_index_lease_id))
2633: /* -- OR commented for bug 16223906
2634: -- index_period_id IS NULL */
2635: )