APPS.AS_OPP_OBSTACLE_PVT dependencies on AS_LOOKUPS

Line 1224: FROM as_lookups

1220: IS
1221: CURSOR C_OBSTACLE_CODE_Exists (c_lookup_type VARCHAR2,
1222: c_OBSTACLE_CODE VARCHAR2) IS
1223: SELECT 'X'
1224: FROM as_lookups
1225: WHERE lookup_type = c_lookup_type
1226: and lookup_code = c_OBSTACLE_CODE
1227: and enabled_flag = 'Y';
1228:

Line 1246: -- OBSTACLE_CODE should exist in as_lookups

1242: x_return_status := FND_API.G_RET_STS_SUCCESS;
1243:
1244: IF(p_OBSTACLE_CODE is NOT NULL) and (p_OBSTACLE_CODE <> FND_API.G_MISS_CHAR)
1245: THEN
1246: -- OBSTACLE_CODE should exist in as_lookups
1247: OPEN C_OBSTACLE_CODE_Exists ('ISSUE', p_OBSTACLE_CODE);
1248: FETCH C_OBSTACLE_CODE_Exists into l_val;
1249:
1250: IF C_OBSTACLE_CODE_Exists%NOTFOUND THEN