public List<OperacaoInterna> findOperacaoInternaCteVigentePorFilialEOperacaoInternaOrigem(Long idFilial, Date dataEmissao, List<Long> listIdsOperacaoInternaOrigem) {

        StringBuilder sql = new StringBuilder();

        sql.append("SELECT coic ")
        .append("FROM ConfigOpIntCTe coic ")
        .append("   JOIN coic.configOpIntCTeOrigems ConfigOpIntCTeOrigem ")
        .append("   LEFT JOIN coic.configOpIntCTeFilials ConfigOpIntCTeFilial ")
        .append("WHERE ")
        .append("   ConfigOpIntCTeFilial.idFilial = :idFilial ")
        .append("   AND ConfigOpIntCTeOrigem.idoperacaointerna in(:listIdsOperacaoInternaOrigem) ")
        .append("   AND (coic.inicioVigencia <= :dataEmissao AND (coic.fimVigencia >= :dataEmissao OR coic.fimVigencia IS NULL)) ");

        TypedQuery<OperacaoInterna> query = createTypedQuery(sql);
        query.setParameter("idFilial", idFilial);
        query.setParameter("dataEmissao", dataEmissao);
        query.setParameter("idOperacaoInterna", listIdsOperacaoInternaOrigem);

        return query.getResultList();
    }