SELECT COUNT(*) INTO V_RETORNO FROM (
              SELECT A.ID_UNID_ADMIN, A.DT_AGEND, P.QT_POSIC_ATEND ATD_POS, COUNT(*) ATD_AGD
                FROM SPV_AGENDAMENTO    A
                JOIN SPV_POSICAO_AGENCIA P
                  ON P.ID_UNID_ADMIN = A.ID_UNID_ADMIN
                 AND P.FL_HABILT = 'S'
               WHERE TRUNC(A.DT_AGEND) > TRUNC(SYSDATE - 1)
                 AND P.ID_UNID_ADMIN = 100
            GROUP BY A.ID_UNID_ADMIN, A.DT_AGEND, P.QT_POSIC_ATEND
              HAVING P.QT_POSIC_ATEND > COUNT(*)
                 AND A.DT_AGEND = P_DATA_HORARIO