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 5069: pn_properties_all prop

5065: pn_locations_all b,
5066: pn_locations_all c,
5067: pn_location_parks d,
5068: pn_location_parks e,
5069: pn_properties_all prop
5070: WHERE a.location_id = p_Location_Id
5071: AND l_as_of_date BETWEEN a.active_start_date AND a.active_end_date
5072: AND b.location_id = l_parent_location_id
5073: AND l_as_of_date BETWEEN b.active_start_date AND b.active_end_date

Line 5095: pn_properties_all prop

5091: FROM pn_locations_all b,
5092: pn_locations_all c,
5093: pn_location_parks d,
5094: pn_location_parks e,
5095: pn_properties_all prop
5096: WHERE b.location_id = p_Location_Id
5097: AND l_as_of_date BETWEEN b.active_start_date AND b.active_end_date
5098: AND c.location_id = l_parent_location_id
5099: AND l_as_of_date BETWEEN c.active_start_date AND c.active_end_date

Line 5118: pn_properties_all prop

5114: INTO l_location_name_rec
5115: FROM pn_locations_all c,
5116: pn_location_parks d,
5117: pn_location_parks e,
5118: pn_properties_all prop
5119: WHERE c.location_id = p_Location_Id
5120: AND l_as_of_date BETWEEN c.active_start_date AND c.active_end_date
5121: AND prop.property_id(+) = c.property_id
5122: AND d.location_park_id(+) = prop.location_park_id