How to recuperate FA_PROJ_INTERIMxxxxx data in a cursor

Hello,

Technical question.  The table FA_PROJ_INTERIM_xxxxx created by FAPROJ program for the projections need to be read by a package.

How can I read the data.  I have to put the table name in the select but the name is variable.

Do I have to use an Execute_immediate for dynamci sql?

Is there other solutions?

I need tu put that in a package.

Thanks!