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.PNT_LOCATIONS_PKG dependencies on PN_TENANCIES_ALL

Line 2436: FROM pn_tenancies_all pt

2432: IS
2433:
2434: CURSOR check_tenancy IS
2435: SELECT 'Y'
2436: FROM pn_tenancies_all pt
2437: WHERE location_id IN (SELECT location_id
2438: FROM pn_locations_all
2439: WHERE active_start_date > p_active_end_date
2440: START WITH location_id = p_location_id

Line 2450: FROM pn_tenancies_all pt

2446: AND ROWNUM < 2;
2447:
2448: CURSOR check_start_tenancy IS
2449: SELECT 'Y'
2450: FROM pn_tenancies_all pt
2451: WHERE location_id IN (SELECT location_id
2452: FROM pn_locations_all
2453: WHERE active_end_date < p_active_start_date
2454: START WITH location_id = p_location_id