You forgot actually run the function or proc first before test it in cache memory

select name, id from sysobjects where name = 'get_emp_list_FY06'

exec get_emp_list_FY06

Then:

select bucketid, cacheobjtype, objtype, objid, dbid     

 from master.dbo.SYSCACHEOBJECTS

 where  objid = 1718297181