1) you are using temp table concept in sql.

2) both store procedures are run differently.

so it will tell you that temp table not present , it may be becouse of...