select *
                from (select p.tabn3,
                             initcap(p.name3) name3,
                             initcap(p.family3) family3,
                             o.name_podr23 name_podr23_actual,
                             d.naim_dolj9 naim_dolj9_actual,
               (case
                 when (select (select pd.Name_Podr23
                                 from podrs pd
                                where pd.code23 = pt.podr_code23)
                         from paths pt
                        where pt.person_tabn3 = p.tabn3
                          and pt.dat_nazn16 =
                              (select max(pt1.dat_nazn16)
                                 from paths pt1
                                where pt1.person_tabn3 = pt.person_tabn3
                                  and pt1.dat_nazn16 < x.dat_nazn161)) =
                      'Echipa mobila' then
                  (select (select p.Name_Podr23
                             from PODRS P
                            where p.name_podr23 <> 'Echipa mobila' and rownum = 1
                            start with p.code23 = pt.podr_code23
                           connect by prior p.podr_code23 = p.code23)
                     from paths pt
                    where pt.person_tabn3 = p.tabn3
                      and pt.dat_nazn16 =
                          (select max(pt1.dat_nazn16)
                             from paths pt1
                            where pt1.person_tabn3 = pt.person_tabn3
                              and pt1.dat_nazn16 < x.dat_nazn161))
                 else
                  (select (select pd.Name_Podr23
                             from podrs pd
                            where pd.code23 = pt.podr_code23)
                     from paths pt
                    where pt.person_tabn3 = p.tabn3
                      and pt.dat_nazn16 =
                          (select max(pt1.dat_nazn16)
                             from paths pt1
                            where pt1.person_tabn3 = pt.person_tabn3
                              and pt1.dat_nazn16 < x.dat_nazn161))
               end) Name_Podr_prec,
                             (select (select dj.naim_dolj9
                                        from Doljnosts dj
                                       where dj.code9 = pt.doljnost_code9)
                                from paths pt
                               where pt.person_tabn3 = p.tabn3
                                 and pt.dat_nazn16 =
                                     (select max(pt1.dat_nazn16)
                                        from paths pt1
                                       where pt1.person_tabn3 = pt.person_tabn3
                                         and pt1.dat_nazn16 < x.dat_nazn161)) Dolj_prec,
                             ' ' TELEFON
                        from persons p, shtats s, podrs o, doljnosts d,
                             (select max(t.dat_nazn16) as dat_nazn161, t.person_tabn3
                                from paths t
                               where t.dat_nazn16 =  trunc(sysdate) -1
                               group by t.person_tabn3
                              UNION
                              select min(t.dat_nazn16) as dat_nazn161, t.person_tabn3
                                from paths t
                               where t.dat_nazn16 = trunc(sysdate) -1
                               group by t.person_tabn3) x
                       where p.dat_uvolnen3 is null
                         and p.tabn3 = s.person_tabn3
                         and s.podr_code23 = o.code23
                         and s.doljnost_code9 = d.code9
                         and p.tabn3 = x.person_tabn3)
               where (name_podr23_actual <> Name_Podr_prec or naim_dolj9_actual <> Dolj_prec) and -- scos la 040118
                     Name_Podr_prec is not null and Dolj_prec is not null
               order by 1