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

Line 594: FROM pn_tenancies_all

590: WHERE property_id = p_prop_id)
591: CONNECT by prior loc.location_id = parent_location_id)
592: UNION
593: SELECT lease_id
594: FROM pn_tenancies_all
595: WHERE location_id in (SELECT location_id
596: FROM pn_locations_all loc
597: START with loc.location_id in (SELECT location_id
598: FROM pn_locations_all

Line 607: FROM pn_tenancies_all

603: CURSOR lease_cur(p_loc_id IN NUMBER)
604: IS
605: SELECT lease_id from
606: (SELECT lease_id
607: FROM pn_tenancies_all
608: WHERE location_id = p_loc_id
609: UNION
610: SELECT lease_id
611: FROM pn_leases_all