Thanks for your response.

As per the logic we need to fetch full data from tables.

I modified the script using temp tables in it is working as expected, normal run as of now.