select p.nm_cpf_pess, p.nm_pess, p.nm_mae
      from siga_pessoa p,
           siga_vinculo v,
           siga_programa_formacao pf,
           siga_turno_vinculo tv,
           siga_situacao_academica sa,
           siga_periodo_letivo pl,           
           siga_modal_progr_form mpf
     where p.nm_cpf_pess=v.nm_cpf_pess
       and v.cd_progr_form=pf.cd_progr_form
       and v.nu_matr_curso=tv.nu_matr_curso
       and tv.cd_perd_letv=(select max(tv1.cd_perd_letv)
                              from siga_turno_vinculo tv1
                             where tv1.nu_matr_curso=tv.nu_matr_curso)                                
       and sa.nu_matr_curso=v.nu_matr_curso
       and sa.cd_perd_letv in (2014 || '.1', 2014 || '.2')  -- Alterar Ano Base
       and sa.cd_tp_sit_acad not in (18)
       and sa.dt_def_sit=(select max(sa2.dt_def_sit)
                            from siga_situacao_academica sa2
                           where sa.nu_matr_curso=sa2.nu_matr_curso
                             and sa.cd_perd_letv=sa2.cd_perd_letv
                         )                            
       and not exists (select 8
                         from siga_vinculo v1
                        where v1.nm_cpf_pess=v.nm_cpf_pess
                          and v1.nu_matr_curso<>v.nu_matr_curso
                          and v1.cd_progr_form=v.cd_progr_form
                          and v1.nu_ano_admis || '.' || v1.nu_semtr_admis > v.nu_ano_admis || '.' || v.nu_semtr_admis)
       and v.nu_ano_admis || '.' || v.nu_semtr_admis=pl.cd_perd_letv                                
       and pf.cd_progr_form = mpf.cd_progr_form
 --      and pf.cd_nivel='1'
       and pf.cd_progr_form not in (14,15)
       and (p.nm_pess like ('%.%') OR p.nm_pess like ('%-%') OR p.nm_mae like ('%.%') OR p.nm_mae like ('%-%'))
group by p.nm_cpf_pess, p.nm_pess, p.nm_mae       
    order by p.nm_pess