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

Line 33: pn_locations_all ploc

29: CURSOR csr_get_vrent_wprop IS
30: SELECT pvr.var_rent_id
31: FROM pn_leases pl,
32: pn_var_rents_all pvr,
33: pn_locations_all ploc
34: WHERE pl.lease_id = pvr.lease_id
35: AND ploc.location_id = pvr.location_id
36: AND ploc.location_id IN (SELECT location_id
37: FROM pn_locations_all

Line 37: FROM pn_locations_all

33: pn_locations_all ploc
34: WHERE pl.lease_id = pvr.lease_id
35: AND ploc.location_id = pvr.location_id
36: AND ploc.location_id IN (SELECT location_id
37: FROM pn_locations_all
38: START WITH location_id
39: IN
40: (SELECT location_id
41: FROM pn_locations_all

Line 41: FROM pn_locations_all

37: FROM pn_locations_all
38: START WITH location_id
39: IN
40: (SELECT location_id
41: FROM pn_locations_all
42: WHERE property_id IN(SELECT property_id
43: FROM pn_properties_all
44: WHERE property_code=NVL(p_property_code,property_code)
45: AND property_name=NVL(p_property_name,property_name))

Line 60: pn_locations_all ploc

56: CURSOR csr_get_vrent_wloc IS
57: SELECT pvr.var_rent_id
58: FROM pn_leases pl,
59: pn_var_rents_all pvr,
60: pn_locations_all ploc
61: WHERE pl.lease_id = pvr.lease_id
62: AND ploc.location_id = pvr.location_id
63: AND pl.lease_num >= NVL(p_lease_num_from, pl.lease_num)
64: AND pl.lease_num <= NVL(p_lease_num_to, pl.lease_num)