Oracle SQL insert into values using newly found value

I’m trying to insert new values into the existing table in Oracle.
The SP in Oracle is working fine, but Snaplogic throw me an error
Below is Oracle SP. The highlighted Insert into is the one that I’m trying to work in Snaplogic

And below is the error message

Can anyone help?
Thank you

@yes1819 Error showing the query is not properly ended, might miss “;” here.
Also you can try to enable the = and use " " wrapped the query.

I tried end with ; but didn’t like it, and with =, still not working.
Maybe I need to put one more snap in between P_SNAP_QTR Oracle Execute and this snap that has error?