DBA Data[Home] [Help]

APPS.WMS_PACKING_WORKBENCH_PVT dependencies on HR_LOCATIONS_ALL

Line 1293: FROM hr_locations_all hrl

1289: IF l_material_rec.receiving_location_id IS NOT NULL THEN
1290: BEGIN
1291: SELECT hrl.location_code
1292: INTO l_material_rec.receiving_location
1293: FROM hr_locations_all hrl
1294: WHERE hrl.location_id = l_material_rec.receiving_location_id;
1295: EXCEPTION
1296: WHEN no_data_found THEN
1297: IF l_debug = 1 THEN

Line 2439: FROM hr_locations_all

2435: IF l_material_rec.ship_to_location_id IS NOT NULL THEN
2436: --IF internal location IO
2437: BEGIN
2438: SELECT location_code INTO l_material_rec.ship_to_location
2439: FROM hr_locations_all
2440: WHERE location_id = l_material_rec.ship_to_location_id;
2441: EXCEPTION
2442: WHEN NO_DATA_FOUND THEN
2443: l_material_rec.ship_to_location := null;