APPS.IBE_MSITE_INFORMATION_PVT dependencies on OE_SHIP_METHODS_V

Line 245: IS SELECT 1 FROM oe_ship_methods_v

241: l_api_version CONSTANT NUMBER := 1.0;
242: l_tmp_id NUMBER;
243:
244: CURSOR c1(l_c_shipment_method_code IN VARCHAR2)
245: IS SELECT 1 FROM oe_ship_methods_v
246: WHERE lookup_type = 'SHIP_METHOD'
247: AND lookup_code = l_c_shipment_method_code
248: AND enabled_flag = 'Y'
249: AND (sysdate BETWEEN NVL(start_date_active, sysdate)

Line 257: -- Check if p_shipment_method_code exists in oe_ship_methods_v

253:
254: -- Initialize status to SUCCESS
255: x_return_status := FND_API.G_RET_STS_SUCCESS;
256:
257: -- Check if p_shipment_method_code exists in oe_ship_methods_v
258: OPEN c1(p_shipment_method_code);
259: FETCH c1 INTO l_tmp_id;
260: IF (c1%NOTFOUND) THEN
261: CLOSE c1;