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 330: FROM pn_index_lease_periods_all pilp

326: ip_index_lease_id IN NUMBER
327: ,ip_index_period_id IN NUMBER) IS
328: SELECT pilp.index_lease_id,
329: pilp.index_period_id
330: FROM pn_index_lease_periods_all pilp
331: WHERE pilp.index_lease_id = ip_index_lease_id
332: AND ( pilp.index_period_id = ip_index_period_id
333: OR ip_index_period_id IS NULL);
334:

Line 342: FROM pn_index_lease_periods_all pilp, pn_payment_terms_all ppt

338: ,ip_index_period_id IN NUMBER) IS
339: SELECT pilp.index_period_id
340: ,ppt.payment_term_id
341: ,ppt.lease_id
342: FROM pn_index_lease_periods_all pilp, pn_payment_terms_all ppt
343: WHERE pilp.index_lease_id = ip_index_lease_id
344: AND pilp.index_period_id = ppt.index_period_id
345: AND pilp.index_period_id = ip_index_period_id;
346: var number;

Line 360: FROM pn_index_lease_periods_all

356: AND sched.payment_status_lookup_code = 'APPROVED');
357:
358: CURSOR get_latest_period IS
359: SELECT index_period_id
360: FROM pn_index_lease_periods_all
361: WHERE index_lease_id = p_index_lease_id
362: AND assessment_date <= p_new_termination_date
363: ORDER BY assessment_date DESC;
364:

Line 481: DELETE pn_index_lease_periods_all

477:
478: --
479: -- deleting index rent period record.
480: --
481: DELETE pn_index_lease_periods_all
482: WHERE index_lease_id = p_index_lease_id
483: AND index_period_id = il_rec_periods.index_period_id;
484: --DBMS_OUTPUT.put_line ('deleting periods...'||sql%rowcount);
485: end loop;

Line 710: FROM pn_index_lease_periods_all pilp

706: ,pilp.basis_start_date
707: ,pilp.basis_end_date
708: ,pilp.index_finder_date
709: ,pilp.assessment_date
710: FROM pn_index_lease_periods_all pilp
711: WHERE pilp.index_lease_id = ip_index_lease_id
712: ORDER BY pilp.line_number;
713:
714: v_line_count NUMBER;

Line 1106: pn_index_lease_periods_all period

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
1108: AND sched.payment_schedule_id = item.payment_schedule_id
1109: AND item.payment_term_id = term.payment_term_id
1110: AND term.lease_id = ilease.lease_id

Line 1141: FROM pn_payment_terms_all term,pn_index_lease_periods_all iperiod

1137: WHERE index_lease_id = p_index_lease_id ;
1138:
1139: DELETE FROM pn_payment_items_all
1140: WHERE payment_term_id IN ( SELECT term.payment_term_id
1141: FROM pn_payment_terms_all term,pn_index_lease_periods_all iperiod
1142: WHERE term.index_period_id = iperiod.index_period_id
1143: AND iperiod.index_lease_id = p_index_lease_id
1144: AND term.index_period_id IS NOT NULL);
1145:

Line 1154: FROM pn_payment_terms_all term,pn_index_lease_periods_all period

1150: WHERE item.payment_schedule_id = sched.payment_schedule_id);
1151:
1152: DELETE FROM pn_distributions_all
1153: WHERE payment_term_id IN (SELECT payment_term_id
1154: FROM pn_payment_terms_all term,pn_index_lease_periods_all period
1155: WHERE term.index_period_id = period.index_period_id
1156: AND period.index_lease_id = p_index_lease_id);
1157:
1158: DELETE FROM pn_payment_terms_all

Line 1160: FROM pn_index_lease_periods_all

1156: AND period.index_lease_id = p_index_lease_id);
1157:
1158: DELETE FROM pn_payment_terms_all
1159: WHERE index_period_id IN (SELECT index_period_id
1160: FROM pn_index_lease_periods_all
1161: WHERE index_lease_id = p_index_lease_id);
1162:
1163: DELETE FROM pn_index_lease_periods_all
1164: WHERE index_lease_id = p_index_lease_id ;

Line 1163: DELETE FROM pn_index_lease_periods_all

1159: WHERE index_period_id IN (SELECT index_period_id
1160: FROM pn_index_lease_periods_all
1161: WHERE index_lease_id = p_index_lease_id);
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 ;

Line 1233: FROM pn_index_lease_periods_all pilp

1229: CURSOR il_recs_to_delete (ip_index_lease_id IN NUMBER
1230: ,ip_new_termination_date IN DATE)
1231: IS
1232: SELECT pilp.index_period_id
1233: FROM pn_index_lease_periods_all pilp
1234: WHERE pilp.index_lease_id = ip_index_lease_id
1235: AND pilp.assessment_date > ip_new_termination_date;
1236:
1237: v_latest_assessment_date DATE;

Line 1246: FROM pn_index_lease_periods_all

1242: BEGIN
1243: -- getting the latest assessment date for this index rent period
1244: SELECT MAX (assessment_date)
1245: INTO v_latest_assessment_date
1246: FROM pn_index_lease_periods_all
1247: WHERE index_lease_id = p_index_lease_id;
1248: -- retreive index lease information.
1249:
1250: OPEN il_rec (p_index_lease_id);

Line 1429: pn_index_lease_periods_all pilp

1425: decode(ppt.actual_amount,null,ppt.estimated_amount,ppt.actual_amount) term_amount,
1426: ppt.org_id,
1427: ppt.norm_end_date
1428: FROM pn_payment_terms_all ppt,
1429: pn_index_lease_periods_all pilp
1430: WHERE ppt.index_period_id = pilp.index_period_id
1431: AND pilp.index_lease_id = p_index_lease_id
1432: AND ppt.frequency_code = pn_index_amount_pkg.c_spread_frequency_one_time
1433: AND ppt.index_term_indicator not in(pn_index_amount_pkg.c_index_pay_term_type_atlst_bb,

Line 1743: FROM pn_index_lease_periods_all

1739: v_last_period_assess_end_date DATE;
1740:
1741: CURSOR get_last_index_period_cur(p_index_lease_id NUMBER) IS
1742: SELECT max(index_period_id) last_index_period_id, max(assessment_date) last_assessment_date
1743: FROM pn_index_lease_periods_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

Line 1754: FROM pn_index_lease_periods_all

1750: AND termination_date = p_old_ls_end_date;
1751:
1752: CURSOR index_periods_cur (p_index_lease_id NUMBER ) IS
1753: SELECT index_period_id
1754: FROM pn_index_lease_periods_all
1755: WHERE index_lease_id = p_index_lease_id
1756: AND assessment_date > p_old_main_lease_term_date;
1757:
1758: CURSOR get_term_4_mtm_update(p_index_lease_id NUMBER) IS

Line 1761: FROM pn_payment_terms_all term,pn_index_lease_periods_all period

1757:
1758: CURSOR get_term_4_mtm_update(p_index_lease_id NUMBER) IS
1759: SELECT term.payment_term_id payment_term_id,
1760: NVL(term.normalize,'N') normalize
1761: FROM pn_payment_terms_all term,pn_index_lease_periods_all period
1762: WHERE term.index_period_id = period.index_period_id
1763: AND period.index_lease_id = p_index_lease_id
1764: AND term.frequency_code <> pn_index_amount_pkg.c_spread_frequency_one_time
1765: AND term.end_date = p_old_main_lease_term_date;

Line 1793: FROM pn_payment_terms_all terms, pn_index_lease_periods_all period

1789: CURSOR get_appr_terms_to_extend(p_index_lease_id IN NUMBER) IS
1790: SELECT *
1791: FROM pn_payment_terms_all
1792: WHERE payment_term_id IN ( SELECT payment_term_id
1793: FROM pn_payment_terms_all terms, pn_index_lease_periods_all period
1794: WHERE terms.index_period_id = period.index_period_id
1795: AND period.index_lease_id = p_index_lease_id)
1796: AND status ='APPROVED'
1797: AND frequency_code <>'OT'

Line 1907: FROM pn_payment_terms_all ppt, pn_index_lease_periods_all pilp

1903: last_updated_by = fnd_global.user_id,
1904: last_update_login = fnd_global.login_id
1905: WHERE payment_term_id IN
1906: (SELECT ppt.payment_term_id
1907: FROM pn_payment_terms_all ppt, pn_index_lease_periods_all pilp
1908: WHERE pilp.index_period_id = ppt.index_period_id
1909: AND pilp.index_lease_id = c_rec.index_lease_id
1910: AND p_lease_context <> 'CON'
1911: AND ppt.frequency_code <>

Line 1924: FROM pn_payment_terms_all ppt, pn_index_lease_periods_all pilp

1920: last_updated_by = fnd_global.user_id,
1921: last_update_login = fnd_global.login_id
1922: WHERE payment_term_id IN
1923: (SELECT ppt.payment_term_id
1924: FROM pn_payment_terms_all ppt, pn_index_lease_periods_all pilp
1925: WHERE pilp.index_period_id = ppt.index_period_id
1926: AND pilp.index_lease_id = c_rec.index_lease_id
1927: AND (ppt.status = pn_index_amount_pkg.c_payment_term_status_draft AND
1928: p_lease_context = 'CON')

Line 1949: FROM pn_payment_terms_all ppt, pn_index_lease_periods_all pilp

1945: last_updated_by = fnd_global.user_id,
1946: last_update_login = fnd_global.login_id
1947: WHERE payment_term_id IN
1948: (SELECT ppt.payment_term_id
1949: FROM pn_payment_terms_all ppt, pn_index_lease_periods_all pilp
1950: WHERE pilp.index_period_id = ppt.index_period_id
1951: AND pilp.index_lease_id = c_rec.index_lease_id
1952: AND (ppt.status = pn_index_amount_pkg.c_payment_term_status_draft AND
1953: p_lease_context = 'CON')

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

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

Line 2327: pn_index_lease_periods_all periods,

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

Line 2489: FROM pn_index_lease_periods_all

2485: CURSOR get_ri_terms_to_modify IS
2486: SELECT *
2487: FROM pn_payment_terms_all
2488: WHERE ((index_period_id IN (SELECT index_period_id
2489: FROM pn_index_lease_periods_all
2490: WHERE index_lease_id = p_index_lease_id))
2491: OR
2492: index_period_id IS NULL)
2493: AND end_date = p_old_termination_date