APPS.AS_OPP_HEADER_PVT dependencies on OE_LOOKUPS

Line 3331: FROM OE_LOOKUPS

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

Line 3357: -- CHANNEL_CODE should exist in OE_LOOKUPS

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