APPS.AS_OPP_HEADER_PVT dependencies on OE_LOOKUPS

Line 3330: FROM OE_LOOKUPS

3326: )
3327: IS
3328: CURSOR C_CHANNEL_CODE_Exists (c_CHANNEL_CODE CHAR) IS
3329: SELECT 'X'
3330: FROM OE_LOOKUPS
3331: WHERE lookup_code = c_channel_code
3332: AND lookup_type = 'SALES_CHANNEL'
3333: AND nvl(start_date_active, sysdate) <= sysdate
3334: AND nvl(end_date_active, sysdate) >= sysdate

Line 3356: -- CHANNEL_CODE should exist in OE_LOOKUPS

3352:
3353: IF (p_CHANNEL_CODE is NOT NULL) and
3354: (p_CHANNEL_CODE <> FND_API.G_MISS_CHAR)
3355: THEN
3356: -- CHANNEL_CODE should exist in OE_LOOKUPS
3357: OPEN C_CHANNEL_CODE_Exists (p_CHANNEL_CODE);
3358: FETCH C_CHANNEL_CODE_Exists into l_val;
3359:
3360: IF C_CHANNEL_CODE_Exists%NOTFOUND THEN