select p.nm_cpf_pess, p.nm_pess, p.nm_mae
      from siga_pessoa p,
           siga_docente d
     where p.nm_cpf_pess=d.nm_cpf_pess
       and d.nm_sigl_tp_docnt <> 'PEB'
       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('1612' || 2014,'DDMMYYYY') and di.dt_demis is null) or  -- Alterar Ano Base
                               (to_char(di.dt_demis,'YYYY')=2014 and not exists (select 8                   -- Alterar Ano Base
                                                                                   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('1612' || 2014,'DDMMYYYY') -- Alterar Ano Base
                                                                                    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 (p.nm_pess like ('%.%') OR p.nm_pess like ('%-%') OR p.nm_mae like ('%.%') OR p.nm_mae like ('%-%'))
    order by p.nm_pess