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_LEASE_DETAILS_HISTORY

Line 1785: FROM pn_lease_details_history plh,

1781: WHERE payment_term_id = p_term_id;
1782:
1783: CURSOR get_old_ls_end_date IS
1784: SELECT NVL(plh.lease_extension_end_date, plh.lease_termination_date) old_ls_end_date
1785: FROM pn_lease_details_history plh,
1786: pn_lease_details_all pld
1787: WHERE pld.lease_change_id = plh.new_lease_change_id
1788: AND pld.lease_id = p_lease_id;
1789:

Line 2423: pn_lease_details_history det_history,

2419: details.lease_termination_date lease_term_date,
2420: det_history.lease_extension_end_date lease_ext_end_date,
2421: changes.change_commencement_date amd_comm_date
2422: FROM pn_lease_details_all details,
2423: pn_lease_details_history det_history,
2424: pn_lease_changes_all changes,
2425: pn_leases_all lease
2426: WHERE details.lease_id = p_lease_id
2427: AND det_history.lease_id = p_lease_id