APPS.AS_COMPETITOR_PROD_PVT dependencies on AS_LOOKUPS

Line 1180: FROM as_lookups

1176:
1177: CURSOR C_WIN_LOSS_STATUS_Exists (c_lookup_type VARCHAR2,
1178: c_Lookup_Code VARCHAR2) IS
1179: SELECT 'X'
1180: FROM as_lookups
1181: WHERE lookup_type = c_lookup_type
1182: and lookup_code = c_Lookup_Code;
1183: l_val VARCHAR2(1);
1184: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

Line 1202: -- WIN_LOSS_STATUS should exist in as_lookups

1198:
1199: IF (p_WIN_LOSS_STATUS is NOT NULL) and
1200: (p_WIN_LOSS_STATUS <> FND_API.G_MISS_CHAR)
1201: THEN
1202: -- WIN_LOSS_STATUS should exist in as_lookups
1203: OPEN C_WIN_LOSS_STATUS_Exists ('WIN_LOSS_STATUS',
1204: p_WIN_LOSS_STATUS);
1205: FETCH C_WIN_LOSS_STATUS_Exists into l_val;
1206: