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_RENT_PKG dependencies on PN_LOCATIONS_ALL

Line 10303: FROM pn_locations_all

10299: where var.lease_id IN( SELECT distinct lease_id
10300: FROM ( SELECT lease_id
10301: FROM pn_tenancies_all
10302: WHERE location_id in (SELECT location_id
10303: FROM pn_locations_all
10304: WHERE property_id = p_prop_id)
10305: UNION
10306: SELECT lease_id
10307: FROM pn_leases_all

Line 10309: FROM pn_locations_all

10305: UNION
10306: SELECT lease_id
10307: FROM pn_leases_all
10308: WHERE location_id in (SELECT location_id
10309: FROM pn_locations_all
10310: WHERE property_id = p_prop_id)));
10311:
10312:
10313: /* Cursor to get all var_rents for the given location */