David,
According to your profiler trace, the pepper doesn't turn to fly specs until the appian.dbo.udf_A User Defined Function hits the fan... that's where your problem is and you should probably post the code for THAT. If you don't think so, tell me where in the script you submitted that dealer regions are found and the IsActive flag is interrogated...
--Jeff Moden
Change is inevitable... Change for the better is not.