DECLARE
aux cliente_type;
BEGIN
  SELECT DEREF(cl.cliente) INTO aux FROM(
    SELECT ct.cliente FROM Carregar_table ct
      WHERE ct.auxiliar.supervisor.cpf = '211.111.11115'
        GROUP BY ct.auxiliar
        ORDER BY COUNT(ct.carga) DESC
  )cl WHERE ROWNUM = 1;
  dbms_output.put_line('nome '|| aux.nome||' cnpj '||aux.cnpj||' cep '||aux.cep);
END;
/