DBA Data[Home] [Help]

APPS.PER_US_VETS_TAP dependencies on HR_LOCATIONS_ALL

Line 143: ,hr_locations_all eloc

139: hr_location_extra_info hlei1
140: ,hr_location_extra_info hlei2
141: ,per_gen_hierarchy_nodes pghn
142: ,per_gen_hierarchy_nodes pgn
143: ,hr_locations_all eloc
144: ,hr_organization_units hou
145: ,hr_organization_information hoi1
146: ,hr_organization_information hoi2
147: ,hr_organization_information hoi3

Line 148: ,hr_locations_all cloc

144: ,hr_organization_units hou
145: ,hr_organization_information hoi1
146: ,hr_organization_information hoi2
147: ,hr_organization_information hoi3
148: ,hr_locations_all cloc
149: where pgn.hierarchy_version_id = pghn.hierarchy_version_id
150: and pgn.node_type = 'PAR'
151: and pgn.entity_id = hou.organization_id
152: and hoi1.org_information_context = 'VETS_Spec'