APPS.PER_US_EEO4_PKG dependencies on HR_LOCATIONS

Line 1040: hr_locations hl

1036: NVL(hl.town_or_city,' ') town_or_city,
1037: NVL(hl.region_1,' ') county,
1038: NVL(hl.region_2,' ')||' '||NVL(hl.postal_code,' ') state_zip
1039: FROM hr_all_organization_units hou,
1040: hr_locations hl
1041: WHERE hou.location_id = hl.location_id
1042: AND hou.business_group_id = g_business_group_id
1043: AND hou.organization_id = g_business_group_id;
1044: