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.PNP_UTIL_FUNC dependencies on PN_PROPERTIES_ALL

Line 5227: pn_properties_all prop

5223: pn_locations_all b,
5224: pn_locations_all c,
5225: pn_location_parks d,
5226: pn_location_parks e,
5227: pn_properties_all prop
5228: WHERE a.location_id = p_Location_Id
5229: AND l_as_of_date BETWEEN a.active_start_date AND a.active_end_date
5230: AND b.location_id = l_parent_location_id
5231: AND l_as_of_date BETWEEN b.active_start_date AND b.active_end_date

Line 5253: pn_properties_all prop

5249: FROM pn_locations_all b,
5250: pn_locations_all c,
5251: pn_location_parks d,
5252: pn_location_parks e,
5253: pn_properties_all prop
5254: WHERE b.location_id = p_Location_Id
5255: AND l_as_of_date BETWEEN b.active_start_date AND b.active_end_date
5256: AND c.location_id = l_parent_location_id
5257: AND l_as_of_date BETWEEN c.active_start_date AND c.active_end_date

Line 5276: pn_properties_all prop

5272: INTO l_location_name_rec
5273: FROM pn_locations_all c,
5274: pn_location_parks d,
5275: pn_location_parks e,
5276: pn_properties_all prop
5277: WHERE c.location_id = p_Location_Id
5278: AND l_as_of_date BETWEEN c.active_start_date AND c.active_end_date
5279: AND prop.property_id(+) = c.property_id
5280: AND d.location_park_id(+) = prop.location_park_id