stringBuffer.append("select ID_COORD_CC, CC_NAME from v_responsavel_cc where ID_COORD_CC IN (");
stringBuffer.append("select distinct(ID_COORD_CC), CC_NAME from v_responsavel_cc where ID_COORD_CC IN (");
    public List<IRubric> getInstitucionalProjectByCCIDs(List<Integer> ccCodes) throws ExcepcaoPersistencia {        List<IRubric> result = new ArrayList<IRubric>();        if (ccCodes != null && ccCodes.size() != 0) {            StringBuilder stringBuffer = new StringBuilder();            stringBuffer.append("select ID_COORD_CC, CC_NAME from v_responsavel_cc where ID_COORD_CC IN (");            for (int i = 0; i < ccCodes.size(); i++) {                if (i != 0)                    stringBuffer.append(", ");                stringBuffer.append(ccCodes.get(i));            }            stringBuffer.append(") order by ID_COORD_CC");            String query = stringBuffer.toString();            try {                PersistentSuportOracle p = PersistentSuportOracle.getInstance();                p.startTransaction();                PreparedStatement stmt = p.prepareStatement(query);                ResultSet rs = stmt.executeQuery();                while (rs.next()) {                    IRubric rubric = new Rubric();                    rubric.setCode(new Integer(rs.getInt("ID_COORD_CC")).toString());                    rubric.setDescription(rs.getString("CC_NAME"));                    result.add(rubric);                }                rs.close();                p.commitTransaction();            } catch (SQLException e) {                throw new ExcepcaoPersistencia();            }        }        return result;    }