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 1774: FROM pn_lease_details_history plh,

1770: WHERE payment_term_id = p_term_id;
1771:
1772: CURSOR get_old_ls_end_date IS
1773: SELECT NVL(plh.lease_extension_end_date, plh.lease_termination_date) old_ls_end_date
1774: FROM pn_lease_details_history plh,
1775: pn_lease_details_all pld
1776: WHERE pld.lease_change_id = plh.new_lease_change_id
1777: AND pld.lease_id = p_lease_id;
1778:

Line 2297: pn_lease_details_history det_history,

2293: details.lease_termination_date lease_term_date,
2294: det_history.lease_extension_end_date lease_ext_end_date,
2295: changes.change_commencement_date amd_comm_date
2296: FROM pn_lease_details_all details,
2297: pn_lease_details_history det_history,
2298: pn_lease_changes_all changes,
2299: pn_leases_all lease
2300: WHERE details.lease_id = p_lease_id
2301: AND det_history.lease_id = p_lease_id