I don't know if the code below works but try it
 
create or replace view v_remote_table as
      select * from remote_tablename@waw;

declare
   cursor seq_cursor is
      select guid.nextval from dual;
 
   seq_val seq_cursor%rowtype;
 
   cursor count_cursor is
      select * from v_remote_tablename;
      
   count_val count_cursor%rowtype;
begin ...