DBA Data[Home] [Help]

APPS.WMS_PACKING_WORKBENCH_PVT dependencies on HR_LOCATIONS_ALL

Line 1356: FROM hr_locations_all hrl

1352: IF l_material_rec.receiving_location_id IS NOT NULL THEN
1353: BEGIN
1354: SELECT hrl.location_code
1355: INTO l_material_rec.receiving_location
1356: FROM hr_locations_all hrl
1357: WHERE hrl.location_id = l_material_rec.receiving_location_id;
1358: EXCEPTION
1359: WHEN no_data_found THEN
1360: IF l_debug = 1 THEN

Line 2512: FROM hr_locations_all

2508: IF l_material_rec.ship_to_location_id IS NOT NULL THEN
2509: --IF internal location IO
2510: BEGIN
2511: SELECT location_code INTO l_material_rec.ship_to_location
2512: FROM hr_locations_all
2513: WHERE location_id = l_material_rec.ship_to_location_id;
2514: EXCEPTION
2515: WHEN NO_DATA_FOUND THEN
2516: l_material_rec.ship_to_location := null;