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_LEASES_ALL

Line 585: FROM pn_leases_all

581: SELECT distinct lease_id
582: FROM
583: (
584: SELECT lease_id
585: FROM pn_leases_all
586: WHERE location_id in (SELECT location_id
587: FROM pn_locations_all loc
588: START with loc.location_id in (SELECT location_id
589: FROM pn_locations_all

Line 611: FROM pn_leases_all

607: FROM pn_tenancies_all
608: WHERE location_id = p_loc_id
609: UNION
610: SELECT lease_id
611: FROM pn_leases_all
612: WHERE location_id = p_loc_id
613: );
614:
615: