APPS.PER_VETS_MAG_100A_REPORT dependencies on HR_LOCATIONS_ALL

Line 229: hr_locations_all loc

225: from per_gen_hierarchy_nodes pgn,
226: hr_all_organization_units hou,
227: hr_organization_information hoi1,
228: hr_organization_information hoi2,
229: hr_locations_all loc
230: where pgn.hierarchy_version_id = p_hierarchy_version_id
231: and pgn.node_type = 'PAR'
232: and pgn.entity_id = hou.organization_id
233: and pgn.business_group_id = p_business_group_id

Line 249: ,hr_locations_all cloc

245: ,upper(replace(translate(hoi2.org_information18,'''`;"|\-+=_#$%^&*@!~:<>?/()[]{},.',' '),' ','')) contact_telnum -- removed special characters
246: ,upper(replace(hoi2.org_information20,',',' ')) contact_email --converted to upper case, bug 13905482
247: from
248: hr_organization_information hoi1
249: ,hr_locations_all cloc
250: ,hr_organization_units hou
251: ,hr_organization_information hoi2
252: ,per_gen_hierarchy_nodes pgn
253: where

Line 1183: hr_locations_all eloc

1179: pghn.hierarchy_node_id
1180: from per_gen_hierarchy_nodes pghn,
1181: hr_location_extra_info hlei1,
1182: hr_location_extra_info hlei2,
1183: hr_locations_all eloc
1184: where pghn.hierarchy_version_id = p_hierarchy_version_id
1185: and pghn.node_type = 'EST'
1186: and eloc.location_id = pghn.entity_id
1187: and hlei1.location_id = pghn.entity_id