APPS.IBE_MSITE_INFORMATION_PVT dependencies on FND_LOOKUPS

Line 100: IS SELECT 1 FROM fnd_lookups

96: l_api_version CONSTANT NUMBER := 1.0;
97: l_tmp_id NUMBER;
98:
99: CURSOR c1(l_c_payment_method_code IN VARCHAR2)
100: IS SELECT 1 FROM fnd_lookups
101: WHERE lookup_type = 'IBE_PAYMENT_TYPE'
102: AND lookup_code = l_c_payment_method_code
103: AND enabled_flag = 'Y'
104: AND (sysdate BETWEEN NVL(start_date_active, sysdate)

Line 112: -- Check if p_payment_method_code exists in fnd_lookups

108:
109: -- Initialize status to SUCCESS
110: x_return_status := FND_API.G_RET_STS_SUCCESS;
111:
112: -- Check if p_payment_method_code exists in fnd_lookups
113: OPEN c1(p_payment_method_code);
114: FETCH c1 INTO l_tmp_id;
115: IF (c1%NOTFOUND) THEN
116: CLOSE c1;