TA Query ( Use of Temp Table and Where condition with multiple criteria)

USE [uattcstravelmaster] GO /****** Object:  StoredProcedure [dbo].[uspGetBookingsDetailsFor_TA]    Script Date: 11/20/2015 16:47:09 ******/ IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[uspGetBookingsDetailsFor_TA]') AND type in (N'P', N'PC')) DROP PROCEDURE [dbo].[uspGetBookingsDetailsFor_TA] GO /****** Object:  UserDefinedFunction [dbo].[fnGetDealMileage]    Script Date: 11/20/2015...