DBA Data[Home] [Help]

APPS.PO_NEGOTIATIONS_SV2 dependencies on HR_LOCATIONS_ALL

Line 199: FROM hr_locations_all

195: if l_ship_to_organization_id is null then
196: begin
197: SELECT inventory_organization_id
198: INTO l_ship_to_organization_id
199: FROM hr_locations_all
200: WHERE location_id = x_ship_to_location_id
201: AND ship_to_site_flag = 'Y';
202: x_progress := '021';
203: -- Bug 3419480