APPS.PN_VAR_UPG_VOL_PKG dependencies on PN_PROPERTIES_ALL

Line 43: FROM pn_properties_all

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))
46: )
47: CONNECT BY PRIOR location_id=parent_location_id)