@Override
    public List<Map<String, ?>> List_Plazo(String tipo) {

        List<Map<String, ?>> lista = new ArrayList<Map<String, ?>>();
        try {
            this.conn = FactoryConnectionDB.open(FactoryConnectionDB.ORACLE);
            String sql = "";
            sql +="select id_plazo,no_plazo,det_alerta ,to_char(fe_desde,'dd-mm-yyyy')  as fe_desde ,"
                    + " to_char(fe_hasta,'dd-mm-yyyy')  as fe_hasta,TO_CHAR(fe_hasta,'MONTH','nls_date_language=spanish')  as mes,"
                    + " sysdate+CA_DIAS_TOLERANCIA as fe_tol, CA_DIAS_TOLERANCIA   from rhtr_plazo where es_plazo ='1' "
                    + " and id_requerimiento='0' and SYSDATE BETWEEN FE_DESDE AND FE_HASTA+1 ";
            switch (tipo) {
                case "1":
                    sql += " and ti_plazo='1'";
                    break;
                case "2":
                    sql += " and ti_plazo='2'";
                    break;
            }

            ResultSet rs = this.conn.query(sql);
            while (rs.next()) {

                Map<String, Object> rec = new HashMap<String, Object>();
                rec.put("id", rs.getString("id_plazo"));
                rec.put("nom", rs.getString("no_plazo"));
                rec.put("det", rs.getString("DET_ALERTA"));
                rec.put("desde", rs.getString("FE_DESDE"));
                rec.put("hasta", rs.getString("FE_HASTA"));
                rec.put("mes", rs.getString("mes"));
                rec.put("dias_tol", rs.getString("CA_DIAS_TOLERANCIA"));
                rec.put("fe_tol", rs.getString("fe_tol"));
                lista.add(rec);
            }
            rs.close();
        } catch (SQLException e) {
            throw new RuntimeException(e.getMessage());
        } catch (Exception e) {
            throw new RuntimeException("ERROR");
        } finally {
            try {
                this.conn.close();
            } catch (Exception e) {
            }
        }
        return lista;

    }