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 10320: FROM pn_locations_all

10316: where var.lease_id IN( SELECT distinct lease_id
10317: FROM ( SELECT lease_id
10318: FROM pn_tenancies_all
10319: WHERE location_id in (SELECT location_id
10320: FROM pn_locations_all
10321: WHERE property_id = p_prop_id)
10322: UNION
10323: SELECT lease_id
10324: FROM pn_leases_all

Line 10326: FROM pn_locations_all

10322: UNION
10323: SELECT lease_id
10324: FROM pn_leases_all
10325: WHERE location_id in (SELECT location_id
10326: FROM pn_locations_all
10327: WHERE property_id = p_prop_id)));
10328:
10329:
10330: /* Cursor to get all var_rents for the given location */