Msg 2715 after upgrade to SQL2005

After upgrading to MSSQL 2005 we have stored procedures which get this error
Msg 2715, Level 16, State 7, Procedure prc_sel_accruals, Line 37
Column, parameter, or variable #15: Cannot find data type umoney.

The user data type is defined in the database. I tried recompiling the SP, which suucceeds but then fails on execution.

The SP works under SQL2000. Is there anything we need to do after the conversion?

Can you post the definition of alias data type.

actually I just found the issue. The SP was creating the table in tempdb, so i needed to define the user data type there too along with the user DB. I also added it to model so it will stay in tempdb after a reboot. thanks...