DBA Data[Home] [Help]

APPS.WSH_FREIGHT_COSTS_PUB dependencies on WSH_FREIGHT_COST_TYPES

Line 27: FROM wsh_freight_cost_types

23:
24: IF (x_freight_cost_type_id IS NULL) THEN
25: IF (p_freight_cost_type <> FND_API.G_MISS_CHAR) THEN
26: SELECT freight_cost_type_id INTO x_freight_cost_type_id
27: FROM wsh_freight_cost_types
28: WHERE name = p_freight_cost_type;
29: IF (SQL%NOTFOUND) THEN
30: RAISE invalid_type;
31: END IF;

Line 35: FROM wsh_freight_cost_types

31: END IF;
32: END IF;
33: ELSE
34: SELECT freight_cost_type_id INTO l_type_id
35: FROM wsh_freight_cost_types
36: WHERE freight_cost_type_id = x_freight_cost_type_id;
37: IF (SQL%NOTFOUND) THEN
38: RAISE invalid_type;
39: END IF;