Looks to me like you've pretty much covered the A-Z of the subject.

Well done!

I never realised, for instance, that temporary tables are still in scope to nested procedures. I'm going to rewrite some code based on this realisation.

Very useful indeed.

David McKinney.