APPS.WSH_FREIGHT_COSTS_GRP dependencies on WSH_FREIGHT_COST_TYPES

Line 45: FROM wsh_freight_cost_types

41:
42: IF (x_freight_cost_type_id IS NULL) THEN
43: IF (p_freight_cost_type <> FND_API.G_MISS_CHAR) THEN
44: SELECT freight_cost_type_id INTO x_freight_cost_type_id
45: FROM wsh_freight_cost_types
46: WHERE name = p_freight_cost_type;
47: IF (SQL%NOTFOUND) THEN
48: RAISE invalid_type;
49: END IF;

Line 53: FROM wsh_freight_cost_types

49: END IF;
50: END IF;
51: ELSE
52: SELECT freight_cost_type_id INTO l_type_id
53: FROM wsh_freight_cost_types
54: WHERE freight_cost_type_id = x_freight_cost_type_id;
55: IF (SQL%NOTFOUND) THEN
56: RAISE invalid_type;
57: END IF;

Line 654: FROM wsh_freight_cost_types

650:
651:
652: CURSOR get_freight_cost_type_del(p_freight_cost_type_id NUMBER) IS
653: SELECT currency_code, amount
654: FROM wsh_freight_cost_types
655: WHERE freight_cost_type_id=p_freight_cost_type_id;
656:
657: --J-IB-JCKWOK
658: CURSOR c_detail_rec(v_detail_id NUMBER ) IS