APPS.OE_BULK_CACHE dependencies on HR_LOCATIONS

Line 1944: hr_locations hl

1940:
1941: SELECT hu.location_id,hl.ece_tp_location_code, hl.location_code
1942: INTO l_addr_id, l_location_code,l_addr_code
1943: FROM hr_all_organization_units hu,
1944: hr_locations hl
1945: WHERE hl.location_id = hu.location_id
1946: AND hu.organization_id = p_key;
1947:
1948: EXCEPTION