APPS.OE_BULK_CACHE dependencies on HR_ALL_ORGANIZATION_UNITS

Line 1943: FROM hr_all_organization_units hu,

1939: BEGIN
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: