APPS.PER_VETS_MAG_REPORT dependencies on HR_LOCATIONS_ALL

Line 181: hr_locations_all loc

177: per_gen_hierarchy_nodes pgn,
178: hr_organization_units hou,
179: hr_organization_information hoi1,
180: hr_organization_information hoi2,
181: hr_locations_all loc
182: where pgn.hierarchy_version_id = p_hierarchy_version_id
183: and pgn.node_type = 'PAR'
184: and pgn.entity_id = hou.organization_id
185: and hoi1.org_information_context = 'VETS_Spec'

Line 216: hr_locations_all loc

212: hr_all_organization_units hou, -- vik
213: -- hr_organization_units hou, -- vik
214: hr_organization_information hoi1,
215: hr_organization_information hoi2,
216: hr_locations_all loc
217: where pgn.hierarchy_version_id = p_hierarchy_version_id
218: and pgn.node_type = 'PAR'
219: and pgn.entity_id = hou.organization_id
220: and pgn.business_group_id = p_business_group_id -- vik

Line 239: ,hr_locations_all cloc

235: ,upper(replace(translate(hoi2.org_information18,'''`;"|\-+=_#$%^&*@!~:<>?/()[]{},.',' '),' ','')) contact_telnum -- removed special characters
236: ,upper(replace(hoi2.org_information20,',',' ')) contact_email
237: from
238: hr_organization_information hoi1
239: ,hr_locations_all cloc
240: ,hr_organization_units hou
241: ,hr_organization_information hoi2
242: ,per_gen_hierarchy_nodes pgn
243: where

Line 1059: hr_locations_all eloc

1055: pghn.hierarchy_node_id
1056: from per_gen_hierarchy_nodes pghn,
1057: hr_location_extra_info hlei1,
1058: hr_location_extra_info hlei2,
1059: hr_locations_all eloc
1060: where pghn.hierarchy_version_id = p_hierarchy_version_id
1061: and pghn.node_type = 'EST'
1062: and eloc.location_id = pghn.entity_id
1063: and hlei1.location_id = pghn.entity_id