Using table variable in data model

Hi All,

I am using Oracle cloud finance BIP reporting.

I need use a table in my data model which is created by oracle process. In other word I don't know my table name or it can change every time. The way I can get the name of the table using this function call.

select fa_whatif_deprn_pkg.get_whatif_table_name(:Param_ID) from dual

I need to use this somehow in event trigger before so that I get the table name. I added a Event Triggers and I put this block in it... trying to us in my data model sql select * from &P_SQL but its not working. I think I am missing something,