APPS.OE_XML_PROCESS_UTIL dependencies on HR_LOCATIONS

Line 210: From hr_all_organization_units hu, hr_locations hl

206: x_country,
207: x_postal_code,
208: x_edi_location_code,
209: x_customer_name
210: From hr_all_organization_units hu, hr_locations hl
211: Where hl.location_id = hu.location_id
212: And hu.organization_id = p_site_use_id;
213:
214: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 331: From hr_all_organization_units hu, hr_locations hl

327: END IF;
328:
329: Select hl.ece_tp_location_code
330: Into x_edi_location_code
331: From hr_all_organization_units hu, hr_locations hl
332: Where hl.location_id = hu.location_id
333: And hu.organization_id = p_ship_from_org_id;
334:
335: Exception