select v.nm_cpf_pess,
       v.nu_matr_curso,
       pf.nm_progr_form,
       saMax.Cd_Perd_Letv,
       tsa.ds_tp_sit_acad   
  from siga_vinculo v,
       siga_situacao_academica saMax,
       siga_programa_formacao pf,
       siga_tipo_situacao_academica tsa
 where v.cd_progr_form not in (14,15)
   and v.nu_matr_curso=saMax.nu_matr_curso
   and v.cd_progr_form=pf.cd_progr_form
   and saMax.cd_tp_sit_acad=tsa.cd_tp_sit_acad
   and v.fl_vinc='0'
   and pf.cd_nivel<>'1'
   and pf.cd_progr_form not in (85)
   and saMax.cd_perd_letv=(select max(sa2.cd_perd_letv)
                             from siga_situacao_academica sa2
                            where sa2.nu_matr_curso=saMax.nu_matr_curso)  
   and saMax.cd_tp_sit_acad in (1,2,3)
   and saMax.dt_def_sit = (select max(sa3.dt_def_sit)
                                  from siga_situacao_academica sa3
                                 where sa3.nu_matr_curso=saMax.nu_matr_curso
                                   and sa3.cd_perd_letv=saMax.cd_perd_letv)
order by pf.nm_progr_form,
         v.nm_cpf_pess