Multipart identifier could not be bound error while migrating from SQL server 2000 to 2005

Multipart identifier could not be bound error while migrating from SQL server 2000 to 2005

When executing the below mentioned query in SQL server 2005 the following error occurs

Multipart identifier dbo.fn_getFinid could not be bound

The query works fine in SQL sever 2000

The query that is errorenous :
 
Select EmpCode, LeaveShortName, sum(LeaveValue) As LeaveTaken From txnLeaveDebits Where EmpCode = '10050' And LeaveId = 'LV0001' and ApplicationType <> 10 and  status <> 2 And dbo.fn_getFinid(fromdate,todate) = 'FY0002 ' Group By EmpCode, LeaveShortName
 
The user defined function : fn_getFinid
 
CREATE   function fn_getFinid(@fromdate as datetime,@todate as datetime) returns varchar(6) begin Declare @FinYearid_fr as varchar(6) Declare @FinYearid_to as varchar(6) set @FinYearid_fr = (select finyearid  from dbo.atFinancialYear where @fromdate between fromdate and todate ) set @FinYearid_to = (select finyearid  from dbo.atFinancialYear where @todate between fromdate and todate ) if @finyearid_fr <> @finyearid_to     set @finyearid_fr = null return @finyearid_fr end

Select allOpen in new window