create type row_type as object(org_id varchar(20));
create type table_type as table of row_type;

create or replace function get_org_record(v_name varchar2) return table_type pipelined as
v row_type;
begin
for r in
(select id from sysobjects where name=v_name )
loop
v := row_type(r.id);
pipe row(v);
end loop;
return;
end;

select * from table(get_org_record(‘ALL_ALL_TABLES’));