Cursors!!! Please Help!

I am trying to write a stored procedure that will insert rows of data meeting my criteria using an inserted stored procedure that should update each row with a unique id. However, when I run it, all of the rows have the same id. I'm new to cursors so any help is appreciated!!!

CREATE PROCEDURE dbo.usp_CreateWelcomeCallTickets AS
DECLARE @ActivityID char(12),
@Accountid char(12),
@Createdate DateTime,
@Createuser char(12),
@Modifydate DateTime,
@Modifyuser char(12),
@Contactid char(12),
@Type int,
@Category varchar(64),
@Description varchar(64),
@Phonenumber varchar(32),
@UserID char(12),
@Notes varchar(255),
@Longnotes varchar(255),
@UserDef2 varchar(255),
@Ticketnumber varchar(64)


--Select accountid, Left(homephone ,3) as areacode
Select accountid, Left(homephone ,3) as areacode
into #temp
From sysdba.contact
--Create Activity
DECLARE C1 CURSOR FOR
SELECT A.AccountID, GetUTCDate() as CreateDate,
'ADMIN' as CreateUser, GetUTCDate() as ModifyDate,
'Admin' as ModifyUser, C.ContactID, '262146' as [Type],
'Welcome Call 1' as Category,
'Welcome Call 20 Queue €“ 02/01' as Description, C.HomePhone as PhoneNumber,
'U6UJ6A0001WB' as userid, 'Welcome Call' as Notes,
'Welcome Call' as LongNotes, 'WC' as userdef2,
ac.timezonecode AS TicketNumber
from sysdba.ACX_CHECKLIST cl
join sysdba.account a on a.accountid = cl.accountid
join #temp t on t.accountid = a.accountid
join sysdba.areacodexref ac on CAST(ac.areacode AS varchar) = CAST(t.areacode AS Varchar)
JOIN sysdba.contact c on c.accountid = a.accountID
where cl.SERVFEESCHEDULEDDATE between '12/1/2007' and '1/1/2008'

Open C1
--The stored procedure that puts unique codes in
EXEC sysdba.usp_GetNextKeyNested 5, '6UJ6', @ActivityID OUTPUT
INSERT INTO sysdba.activity (
ActivityID,
Accountid,
Createdate,
Createuser,
Modifydate,
Modifyuser,
Contactid,
[Type],
Category,
Description,
Phonenumber,
UserID,
Notes,
Longnotes,
UserDef2,
Ticketnumber)
VALUES (
@ActivityID,
@AccountID,
@Createdate,
@Createuser,
@Modifydate,
@Modifyuser,
@Contactid,
@Type,
@Category,
@Description,
@Phonenumber,
@UserID,
@Notes,
@Longnotes,
@UserDef2,
@Ticketnumber)
FETCH NEXT FROM c1
WHILE @@FETCH_STATUS = 0
BEGIN
FETCH NEXT FROM C1

END
CLOSE C1
DEALLOCATE C1