select p.NM_CPF_PESS, p.nm_pess from siga_pessoa p, siga_docente d where p.nm_cpf_pess = d.nm_cpf_pess and d.cd_docnt=(select di.cd_docnt 
                  from siga_docente di
                          where di.nm_cpf_pess=d.nm_cpf_pess
                            and ((di.dt_admis<to_date('0211' || 2016,'DDMMYYYY') and di.dt_demis is null) or  -- Alterada a data para '0211' para censo 2015
                                 (to_char(di.dt_demis,'YYYY')=2016 and not exists (select 8
                                                                                     from siga_docente di1
                                                                                    where di1.nm_cpf_pess=di.nm_cpf_pess
                                                                                      and di1.cd_docnt<>di.cd_docnt
                                                                                      and di1.dt_admis<to_date('0211' || 2016,'DDMMYYYY') -- Alterada a data para '0211' para censo 2015
                                                                                      and di1.dt_demis is null
                                                                                  )
                                 ))
                        )          
  and d.cd_tp_sit_docnt not in (2,10,145,144,150,151,147,152,155,153,154,148,146,149,165) 
  and d.NM_CPF_PESS not in (select distinct 
  p.NM_CPF_PESS
  from siga_turma t,
  siga_atividade_academica aa,
  SIGA_COMPONENTE_CURRICULAR cc,
  SIGA_DOCNT_TURMA dt,
  SIGA_DOCENTE d,
  SIGA_PESSOA p,
  SIGA_PERIODO_LETIVO pl
  where t.CD_ATIV_ACAD=aa.CD_ATIV_ACAD
  and aa.CD_COMPNT_CURR=cc.CD_COMPNT_CURR
  and pl.NU_ANO_PERD_LETV = 2016
  and t.CD_TURMA=dt.CD_TURMA
  and dt.CD_DOCNT=d.CD_DOCNT
  and dt.NM_CPF_PESS=d.NM_CPF_PESS
  and d.NM_CPF_PESS=p.NM_CPF_PESS
  and exists (
  select *
  from SIGA_MATRICULA_TURMA mt,
  SIGA_VINCULO v
  where mt.CD_TURMA=t.CD_TURMA
  and mt.NU_MATR_CURSO=v.NU_MATR_CURSO
  ))order by p.NM_PESS;