238:
239: SELECT hrl.inventory_organization_id
240: INTO x_org_id
241: FROM hr_locations hrl,
242: org_organization_definitions ood
243: WHERE ood.organization_id = hrl.inventory_organization_id
244: AND ood.set_of_books_id = x_sob_id
245: AND hrl.location_id = x_location_id;
246:
249: SELECT ood.organization_name,
250: ood.organization_code
251: INTO x_org_name,
252: X_org_code
253: FROM org_organization_definitions ood
254: WHERE ood.organization_id = x_org_id;
255:
256: exception
257: when no_data_found then