APPS.PER_US_VETS_100A_CONS_PKG dependencies on HR_LOCATION_EXTRA_INFO

Line 112: hr_location_extra_info hlei1

108: cursor c_state(l_parent_node_id varchar2) is
109: Select
110: distinct(eloc.region_2) "State"
111: from
112: hr_location_extra_info hlei1
113: ,hr_location_extra_info hlei2
114: ,per_gen_hierarchy_nodes pghn
115: ,hr_locations_all eloc
116: where

Line 113: ,hr_location_extra_info hlei2

109: Select
110: distinct(eloc.region_2) "State"
111: from
112: hr_location_extra_info hlei1
113: ,hr_location_extra_info hlei2
114: ,per_gen_hierarchy_nodes pghn
115: ,hr_locations_all eloc
116: where
117: pghn.parent_hierarchy_node_id = l_parent_node_id

Line 148: ,hr_location_extra_info hlei1

144: pghn1.entity_id
145: ,pghn1.hierarchy_node_id
146: from
147: per_gen_hierarchy_nodes pghn1
148: ,hr_location_extra_info hlei1
149: ,hr_location_extra_info hlei2
150: ,hr_locations_all eloc
151: where
152: pghn1.hierarchy_version_id = P_HIERARCHY_VERSION_ID

Line 149: ,hr_location_extra_info hlei2

145: ,pghn1.hierarchy_node_id
146: from
147: per_gen_hierarchy_nodes pghn1
148: ,hr_location_extra_info hlei1
149: ,hr_location_extra_info hlei2
150: ,hr_locations_all eloc
151: where
152: pghn1.hierarchy_version_id = P_HIERARCHY_VERSION_ID
153: and pghn1.node_type = 'EST'

Line 289: hr_location_extra_info hlei1

285: cursor c_ests is
286: select
287: pghn.hierarchy_node_id
288: from
289: hr_location_extra_info hlei1
290: ,hr_location_extra_info hlei2
291: ,per_gen_hierarchy_nodes pghn
292: ,hr_locations_all eloc
293: where

Line 290: ,hr_location_extra_info hlei2

286: select
287: pghn.hierarchy_node_id
288: from
289: hr_location_extra_info hlei1
290: ,hr_location_extra_info hlei2
291: ,per_gen_hierarchy_nodes pghn
292: ,hr_locations_all eloc
293: where
294: pghn.hierarchy_version_id = p_hierarchy_version_id