I'm also seeing a ton of things like this PARTY_ID > 0 in statements that are creating temp tables.  Is that an identity field?  If so aren't you basically just selecting the entire table?