127: ,upper(eloc.region_2) "Estab State"
128: ,upper(eloc.postal_code) "Estab Zip"
129:
130: from
131: hr_location_extra_info hlei1
132: ,hr_location_extra_info hlei2
133: ,per_gen_hierarchy_nodes pghn
134: ,hr_locations_all eloc
135: where
128: ,upper(eloc.postal_code) "Estab Zip"
129:
130: from
131: hr_location_extra_info hlei1
132: ,hr_location_extra_info hlei2
133: ,per_gen_hierarchy_nodes pghn
134: ,hr_locations_all eloc
135: where
136: pghn.parent_hierarchy_node_id = l_parent_node_id