Error al migrar equivalencias - post contorles

SIU-Guaraní Migración de Datos
34

¿Que valores retornan estas consultas?

-- G2
SELECT count(DISTINCT m_r.nro_tramite) 
FROM mig._cnv_pk_reconocimiento as m_r
JOIN mig.sga_equiv_operac as eo ON eo.operacion_equiv = m_r.operacion_equiv_g2
JOIN mig.sga_equiv_otorgada as e ON e.operacion_equiv = eo.operacion_equiv
WHERE eo.operacion_equiv IN (SELECT operacion_equiv FROM mig.sga_equiv_otorgada)
     AND eo.origen = 'H' 
     AND m_r.origen = 'EQUIVALENCIA'; 

SELECT COUNT(DISTINCT m_r.nro_tramite) 
  FROM mig._cnv_pk_reconocimiento as m_r
     JOIN mig.sga_resol_activ as rs ON rs.unidad_academica = m_r.unidad_academica AND rs.resol_actividades = m_r.resol_actividades
 WHERE m_r.origen = 'EXTRACURRICULAR'; 

-- Guarani 3   
SELECT count(DISTINCT r.nro_tramite) INTO cnt_homologaciones_g3 
  FROM sga_reconocimiento as r
  JOIN sga_reconocimiento_act as ra ON ra.nro_tramite = r.nro_tramite 
 WHERE ra.homologada = 'S';