SQL & PL/SQL

Hi

Is there some way to use the results of the cursor in following SELECT statement ?

i want something like following :

Stored Procedure / Function :
-----------------------------
OPEN cursor1 FOR
SELECT .......................;

OPEN cursor2 FOR
SELECT * FROM cursor1 where .................................

Return cursor1 and cursor2;

----------------------------

I hope you understand this. I am stuck at some point for this, so any help will be really appreciated.

Cheers