SELECT ABATHOR.CODCOLIGADA, ABATHOR.CODHORARIO, INDICE, BATIDA, TIPO, \r                                                         FIM, NATUREZA, INICIO, TEMPOMINREF, INDLIMREF, \r                                                         ATRASOMINREF, EXTRAMINREF, RECCREATEDBY, RECCREATEDON, RECMODIFIEDBY, RECMODIFIEDON, ABATEATRASO, ABATEEXTRA\r                                                   FROM ABATHOR \r                                                   WHERE (EXISTS (SELECT 1 FROM PFHSTHOR A , PFUNC , PPESSOA \r                                    WHERE ABATHOR.CODCOLIGADA = A.CODCOLIGADA AND\r                                        ABATHOR.CODHORARIO = A.CODHORARIO AND\r                                        A.CODCOLIGADA = PFUNC.CODCOLIGADA AND\r                                          A.CHAPA = PFUNC.CHAPA AND\r                                          PFUNC.CODPESSOA = PPESSOA.CODIGO AND PFUNC.CODCOLIGADA = :COL_FUNC AND PFUNC.CHAPA = :CHAPA_FUNC AND ROWNUM = 1