SELECT
      obv.numopzn
    ,obv.dateizm
    ...
  FROM
   ...
   ,(
      SELECT 
         obv.numopzn  numopzn 
        ,MAX(obv.dateizm)  dateizm 
      FROM
        ...
      WHERE
        ...
      GROUP BY obv.numopzn
  )  t1
 WHERE
   ...
    obv.numopzn=t1. numopzn
   AND obv.dateizm =t1.dateizm  
 ORDER BY obv.numopzn;

 procedure get_PrebivanieTB(
   cur_viborka out t_cursor
   ,xdate in date
 )
 is
  CURSOR cr IS
   SELECT * 
   FROM (
    SELECT 
      TRIM(obv.numopzn) numopzn
     ,slv.namvrr namvrr  
     ,jdk.numdoc numdoc
     ,obj.ABBROBJR  mesto
     ,SUBSTR(loc.coord, 1, 7) lat
     ,SUBSTR(loc.coord, 8, 8) lng
     ,obv.dateizm dateizm
    FROM
      objvr obv
     ,objs obj
     ,objlocation obl
     ,location loc
     ,slvr slv
     ,cg_ref_codes cd
     ,tipvr tv
     ,sltipvr slt
     ,(
       SELECT codprvr, namesostvr 
       FROM prvr 
       WHERE prvr.CODDOG = '___'
     ) pv
     ,(
       SELECT ov2.NUMOPZN, ov2.codobjvr 
       FROM   OBJVR ov2 
       WHERE ov2.numopzn is not null
     ) svyaz
     ,(
       SELECT jdc.coddoc, jdc.numdoc, sfu.nformuved, jdc.datetimeregdoc 
       FROM journaldoc jdc, slformuv sfu 
       WHERE jdc.coddog = '___' AND jdc.codformuv = sfu.codformuv (+)
     ) jdk
    WHERE 
      obv.DEL IS NULL
     AND obv.coddoc = jdk.coddoc (+)
      . . . 
     AND TRUNC(obv.dateizm) <= xdate
    ORDER BY
      obv.numopzn
     ,obv.dateizm
  );
  
  xstr varchar2(30);

 BEGIN
  DELETE FROM  tbl_tmp_gis;
  COMMIT;

  xstr := ' ';

  FOR row IN cr LOOP
   IF row.numopzn <> xstr THEN
    INSERT INTO tbl_tmp_gis VALUES (
      row.numopzn
     ,row.namvrr
     ,row.numdoc
     ,row.mesto
     ,row.lat
     ,row.lng
     ,row.dateizm 
    );
    xstr := row.numopzn;
   END IF; 
  END LOOP;
  open cur_viborka for 
  SELECT tbl_tmp_gis.*
  FROM  tbl_tmp_gis;
 
  DELETE FROM  tbl_tmp_gis;
  COMMIT;
 end get_PrebivanieTB; 

 CREATE GLOBAL TEMPORARY TABLE tbl_tmp_gis(
     numopzn VARCHAR2(30)
    ,namvrr VARCHAR2(55)
    ,numdoc VARCHAR2(20)
    ,mesto VARCHAR2(255)
    ,lat VARCHAR2(7)
    ,lng VARCHAR2(8)
    ,dateizm DATE 
   )
   ON COMMIT PRESERVE ROWS;