select pf.nm_progr_form AS CURSO,
       pl.cd_perd_letv AS PERIODO_LETIVO,
       tsa.ds_tp_sit_acad AS SITUACAO_ACADEMICA,
       p.NM_PESS as NOME_DISCENTE,
       p.NM_CPF_PESS as CPF
  from siga_vinculo v,
       siga_situacao_academica sa,
       siga_programa_formacao pf,
       siga_tipo_situacao_academica tsa,
       siga_periodo_letivo pl,
       siga_pessoa p
 where v.cd_progr_form not in (14,15,85)
   and v.nu_matr_curso=sa.nu_matr_curso
   and v.nm_cpf_pess=p.nm_cpf_pess
   and v.cd_progr_form=pf.cd_progr_form
   and pf.cd_nivel='1' -- Graduação
   --and pf.cd_nivel<>'1' -- Pós-Graduação
   and sa.cd_tp_sit_acad=tsa.cd_tp_sit_acad
   and sa.cd_perd_letv=pl.cd_perd_letv
   and pl.cd_tp_perd_letv='1'
   and pl.nu_ano_perd_letv=2014 -- Ano Base
   and sa.dt_def_sit=(select max(sa2.dt_def_sit)
                        from siga_situacao_academica sa2
                       where sa2.nu_matr_curso=sa.nu_matr_curso
                         and sa2.cd_perd_letv=sa.cd_perd_letv
                         and sa2.cd_tp_sit_acad not in (4,21))  
order by pf.nm_progr_form,
         pl.cd_perd_letv,
         tsa.ds_tp_sit_acad,
         P.nm_pess