APPS.HR_AE_VALIDATE_PKG dependencies on HR_LOCATIONS_ALL

Line 1125: hr_locations_all hl,

1121:
1122: CURSOR csr_fetch_bus_id IS
1123: SELECT distinct paaf.business_group_id
1124: FROM per_all_assignments_f paaf,
1125: hr_locations_all hl,
1126: hr_organization_information hoi
1127: WHERE paaf.location_id = p_location_id
1128: and paaf.location_id = hl.location_id
1129: AND paaf.business_group_id = hoi.organization_id;