Problem with sql joins

SELECT ISNULL(IncludedCodesValueString,'')+ISNULL(ExcludedCodesValueString,'') AS FilterValues,ServiceLineName AS FilterName, CONVERT(BIT,1) AS IsServiceTypeFilter, SLT.ServiceLineTypeId AS ServiceLineTypeId, NULL AS PaymentTypeID FROM @temp_ContractFilterTable AS TempTable JOIN [dbo].[ref.ServiceLineTypes] AS SLT ON SLT.ServiceLineTypeId = TempTable.ServiceLineTypeId JOIN [dbo].[ContractServiceLinePaymentTypes] CSP ON CSP.ServiceLineTypeId = TempTable.ServiceLineTypeId WHERE ContractId = @ContractId OR ContractServiceTypeID = @ContractServiceTypeID
The above query is giving result as follow

FilterValues   FilterName    IsServiceTypeFilter   ServiceLineTypeId PaymentTypeID <> 34,90       Bill Type          1                                1           &nb ...