With clause inside the cursor

Hi ,

We have a cursor which is having the with clause..

structure is like :

Cursor cursor_name is

with alias_name as

<<query>>

Here we have a issue like :

The with clause query is giving the value if we are running the query separately but running inside the cursor,

cursor is not having any value from that query.

Here also query might be fetching the values but cannot able to pass to cursor.

I tried to put %not found after opening the cursor, it is showing cursor not found.

Kindly help in this regards/