pipelined function consuming ref cursor

CREATE TABLE all_tables_plus AS SELECT * FROM all_tables WHERE 1 = 2;
ALTER TABLE all_tables_plus add (prev_table_name VARCHAR2(30));
 
 
 
CREATE OR REPLACE PACKAGE ref_pkg IS
  TYPE refcur_tables IS REF CURSOR RETURN all_tables%ROWTYPE;
  TYPE t_tables_plus IS TABLE OF all_tables_plus%ROWTYPE;
END ref_pkg;
/
 
CREATE OR REPLACE FUNCTION add_prev_table (cur_tables IN ref_pkg.refcur_tables)
RETURN ref_pkg.t_tables_plus pipelined
IS
  l_prev_table_name VARCHAR2(30) := NULL;
  l_tables          all_tables%ROWTYPE;
  l_tables_plus     all_tables_plus%ROWTYPE;
BEGIN
  LOOP
   FETCH cur_tables INTO l_tables;
   EXIT WHEN cur_tables%NOTFOUND;
   l_tables_plus.table_name :=  l_tables.table_name;
   l_tables_plus.prev_table_name := l_prev_table_name;
   l_prev_table_name := l_tables.table_name;
   PIPE ROW(l_tables_plus);
  END LOOP;
END;
/
 
 
SELECT table_name,prev_table_name
FROM TABLE(add_prev_table(CURSOR(SELECT * FROM all_tables)));