Thank you for the response.
The procedure accepts parameters. It generates a big dynamic query for 11 teams and then inserts into the 11 tables.
Currently I have resolved this now.
I had changed the affinity mask. It was 0 as default. After changing, this worked without any problems.