Operand type clash: int is incompatible with datetime2

I'm updating an old project that still uses DF Classic. I've created a stored procedure and I'm getting the above error.

There is an issue with mapping procedures with temporary tables, so i have a real table that gets returned.

Here is the procedure:

CREATE PROCEDURE procCreateAccountTrx
    @pStartPeriod        int, 
    @pEndPeriod            int,
    @pStartYear            int,
    @pEndYear            int,
    @pStartDate            datetime,
    @pEndDate            datetime,
    @pAccounts            varchar(4000)
AS
BEGIN
    -- SET NOCOUNT ON added to prevent extra result sets from
    -- interfering with SELECT statements.
    SET NOCOUNT ON;

    DECLARE @StartPeriod        int,
    @EndPeriod        int,
    @StartYear        int,
    @EndYear        int,
    @StartDate        datetime,
    @EndDate        datetime,
    @Accounts        varchar(4000)

    SELECT @StartPeriod = @pStartPeriod,
    @EndPeriod = @pEndPeriod,
    @StartYear = @pStartYear,
    @EndYear = @pEndYear,
    @StartDate = @pStartDate,
    @EndDate = @pEndDate,
    @Accounts = @pAccounts

        IF OBJECT_ID (N'[tempTransactions]', N'U') IS NOT NULL DROP TABLE [tempTransactions]
    CREATE TABLE [tempTransactions](
    [AccountId] [int] NOT NULL,
    [SubAccountId] [int] NOT NULL,
    [OpeningBalance] [money] NOT NULL,
    [DebitAmount] [money] NOT NULL,
    [CreditAmount] [money] NOT NULL,
    [Reference] [varchar] (50) NOT NULL,
    [BatchName] [varchar] (50) NOT NULL,
    [Period] [int] NOT NULL,
    [Year] [int] NOT NULL,
    [TransactionDate] [datetime] NOT NULL
    ) 

    INSERT INTO [tempTransactions]
    exec  CreateAccountTrx @StartPeriod, @EndPeriod, @StartYear, @EndYear, @StartDate, @EndDate, @Accounts

    select a.Number, a.Description, s.Code, t.OpeningBalance, t.DebitAmount, t.CreditAmount, t.Reference,
    t.BatchName, t.Period, t.Year, t.TransactionDate
     From [tempTransactions] as t
    INNER JOIN GLAccount as A ON t.AccountId = a.Id
    INNER JOIN GLSubAccount as S on t.SubAccountId = s.Id

END
GO

I have never seen this error before and am not too sure how to get past it. Any clues?

Edited by smi-mark - 19-Jul-2011 at 3:13pm