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_NORM_RENORM_PKG dependencies on PN_LEASE_CHANGES_ALL

Line 147: FROM pn_lease_changes_all

143: SELECT pn_schedules_items.FIRST_DAY(change_commencement_date)
144: INTO l_amd_comn_date
145: FROM
146: (SELECT *
147: FROM pn_lease_changes_all
148: WHERE lease_id = p_lease_id
149: ORDER BY lease_change_id DESC)
150: WHERE rownum < 2;
151:

Line 1081: FROM pn_lease_changes_all

1077: SELECT change_commencement_date
1078: INTO l_amd_comn_date
1079: FROM
1080: (SELECT *
1081: FROM pn_lease_changes_all
1082: WHERE lease_id = p_lease_id
1083: ORDER BY lease_change_id DESC)
1084: WHERE rownum < 2;
1085: