You have to name your temp.table with prefix '# '

like #aarobtmp:

CREATE PROCEDURE rob_tmp_1

AS

SELECT glt_urn,

glt_code,

glt_description

INTO #aarobtmp

FROM ncm_general_list_type

SELECT * FROM #aarobtmp

GO