Thank you Garadin, I actually changed the name of the calling procedure's temp table and am still getting the error. So I must have been wrong about that - let me investigate further before I stick my foot in my mouth (again!) here.
The greatest enemy of knowledge is not ignorance, it is the illusion of knowledge. - Stephen Hawking