Histórico da Página

...

AND               A.CHAPA = B.CHAPA

AND         (YEAR(B.DATAADMISSAO) = YEAR(GETDATE())

AND               MONTH(B.DATAADMISSAO) = MONTH(GETDATE())

AND               DAY(B.DATAADMISSAO) =  DAY(GETDATE()))

AND               A.CAGED = 'SIM'

...

JOIN PFUNC B ON (A.CODCOLIGADA = B.CODCOLIGADA AND A.CHAPA = B.CHAPA)

WHERE TO_NUMBER(TO_CHAR(B.DATAADMISSAO, 'yy')) = TO_NUMBER(TO_CHAR(SYSDATE, 'yy'))

AND   TO_NUMBER(TO_CHAR(B.DATAADMISSAO, 'MM')) = TO_NUMBER(TO_CHAR(SYSDATE, 'MM'))

AND   TO_NUMBER(TO_CHAR(B.DATAADMISSAO, 'DD')) = TO_NUMBER(TO_CHAR(SYSDATE, 'DD'))

AND   A.CAGED = 'SIM'

...