APPS.OE_BULK_CACHE dependencies on HR_LOCATIONS

Line 1945: hr_locations hl

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