Getting Erorr

hi

below is my procedure but when i execute this i m gettin g following error

Syntax error converting the varchar value 'empbankdetailsBACS' to a column of data type int.

what is problem

-- EXEC sp_GetPaymentMethod 0
CREATE PROCEDURE sp_GetPaymentMethod
@PaymentMethodID int = 0
AS
BEGIN
SET NOCOUNT ON
SELECT
PaymentMethodID,
PM.Descn,
'empbankdetails'+ PM.Descn as 'Descn2',
DateCreated,
LastModified,
0 as 'Value'
INTO
#tmpPaymentMethodGlobalSettings
FROM
t_PayrollPaymentMethod PM, t_GlobalSettings GS
WHERE
PaymentMethodID = 0 OR 0 = 0
ORDER BY
Descn

Declare @SqlString1 varchar(1000)
Declare @SqlString2 varchar(250)
Set @SqlString2 = ''
Declare @Payment integer
Declare @Descn varchar(50)
Declare Payment Cursor for
Select PaymentMethodID
from #tmpPaymentMethodGlobalSettings
Open Payment
FETCH NEXT FROM Payment into @Payment
WHILE @@FETCH_STATUS = 0
BEGIN
Declare @Value int
Select @Descn = Descn2 from #tmpPaymentMethodGlobalSettings where
PaymentMethodID = @Payment
--Set @SqlString1 = '
--Declare @Value int
Select @Value = @Descn from t_GlobalSettings
Update #tmpPaymentMethodGlobalSettings
Set Value = @Value where PaymentMethodID = Convert(varchar(10),
@Payment)
-- exec (@SqlString1)

FETCH NEXT FROM Payment into @Payment
END
CLOSE Payment
DEALLOCATE Payment
Select * from #tmpPaymentMethodGlobalSettings
--Drop Table tmpPaymentMethodGlobalSettings
IF @@error <> 0
RETURN(0)
ELSE
RETURN(1)
END

GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO