DBA Data[Home] [Help]

APPS.PER_US_VETS_100A_SINGLE_PKG dependencies on HR_LOCATION_EXTRA_INFO

Line 131: hr_location_extra_info hlei1

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

Line 132: ,hr_location_extra_info hlei2

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