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_LEASE_UTILS dependencies on PN_TENANCIES_ALL

Line 367: FROM pn_tenancies_all

363: SELECT loc2.location_id
364: FROM pn_locations_all loc2
365: START WITH loc2.location_id IN (
366: SELECT location_id
367: FROM pn_tenancies_all
368: WHERE lease_id =
369: p_parent_lease_id
370: AND status = 'A')
371: CONNECT BY PRIOR loc2.location_id =

Line 423: FROM pn_tenancies_all

419: SELECT loc2.location_id
420: FROM pn_locations_all loc2
421: START WITH loc2.location_id IN (
422: SELECT location_id
423: FROM pn_tenancies_all
424: WHERE lease_id =
425: p_parent_lease_id
426: AND status = 'A')
427: CONNECT BY PRIOR loc2.location_id =