@Override
    public List<V_Detalle_Carga_Academica> Lista_detalle_academico(String idtr, String facultad, String eap, String ciclo, String dni) {
        this.conn = FactoryConnectionDB.open(FactoryConnectionDB.ORACLE);
        String sql = "SELECT * FROM RHVD_DETALLE_CARGA_ACADEMICA WHERE campus is not null";
        //      sql += (idtr.equals("")) ? "" : " and TRIM(ID_TRABAJADOR)= '" + idtr.trim();
        sql += (facultad.trim().equals("")) ? "" : " and TRIM(NO_FACULTAD)='" + facultad.trim() + "' ";
        sql += (eap.equals("")) ? "" : "  AND TRIM(NO_EAP)='" + eap.trim() + "' ";
        sql += (ciclo.trim().equals("")) ? "" : "  AND TRIM(DE_CARGA)='" + ciclo.trim() + "' ";
        sql += (dni.trim().equals("")) ? "" : "  AND TRIM(NU_DOC)='" + dni.trim() + "' ";
        List<V_Detalle_Carga_Academica> list = new ArrayList<V_Detalle_Carga_Academica>();
        try {
            ResultSet rs = this.conn.query(sql);
            while (rs.next()) {
                V_Detalle_Carga_Academica ca = new V_Detalle_Carga_Academica();
                ca.setId_carga_academica(CCriptografiar.Encriptar(rs.getString("id_carga_academica")));
                ca.setEs_carga_academica(rs.getString("es_carga_academica"));
                ca.setCampus(rs.getString("campus"));
                ca.setEs_tipo_doc(rs.getString("es_tipo_doc"));
                ca.setNu_doc(rs.getString("nu_doc"));
                ca.setAp_paterno(rs.getString("ap_paterno"));
                ca.setAp_materno(rs.getString("ap_materno"));
                ca.setNo_trabajador(rs.getString("no_trabajador"));
                ca.setNo_facultad(rs.getString("no_facultad"));
                ca.setNo_eap(rs.getString("no_eap"));
                ca.setDe_carga(rs.getString("de_carga"));
                ca.setNo_curso(rs.getString("no_curso"));
                ca.setNu_grupo(rs.getString("nu_grupo"));
                ca.setDe_horario(rs.getString("de_horario"));
                ca.setCa_hlab(rs.getDouble("ca_hlab"));
                ca.setDe_condicion(rs.getString("de_condicion"));
                ca.setDe_tipo_curso(rs.getString("de_tipo_curso"));
                ca.setEs_procesado(rs.getString("es_procesado"));
                ca.setFe_creacion(rs.getString("fe_creacion"));
                ca.setCa_tipo_hora_pago_refeerencial(rs.getString("ca_tipo_hora_pago_refeerencial"));
                ca.setId_trabajador(CCriptografiar.Encriptar(rs.getString("id_trabajador")));
                list.add(ca);
            }
        } catch (SQLException e) {
            throw new RuntimeException(e.getMessage());
        } catch (Exception e) {
            throw new RuntimeException("ERROR :" + e.getMessage());
        } finally {
            try {
                this.conn.close();
            } catch (Exception e) {
                throw new RuntimeException(e.getMessage());
            }
        }
        return list;

    }