I was able to grab the specific code that's causing the problem, here you go,

USE [ARCHIVE]

GO

/****** Object: StoredProcedure [dbo].[SP_Archive_Cleanup] Script Date: 09/20/2013 22:54:57 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

ALTER PROCEDURE [dbo].[SP_Archive_Cleanup] @TABLE VARCHAR(10)

AS

BEGIN

IF (@TABLE='ALL')

BEGIN

DELETE

FROM PRODUCTION.dbo.TABLE1

WHERE PK IN (SELECT PK FROM ARCHIVE.dbo.TABLE1)

DELETE

FROM PRODUCTION.dbo.TABLE2

WHERE PK IN (SELECT PK FROM ARCHIVE.dbo.TABLE2)

DELETE

FROM PRODUCTION.dbo.TABLE3

WHERE PK IN (SELECT PK FROM ARCHIVE.dbo.TABLE3)

DELETE

FROM PRODUCTION.dbo.TABLE4

WHERE PK IN (SELECT PK FROM ARCHIVE.dbo.TABLE4)

DELETE

FROM PRODUCTION.dbo.TABLE5

WHERE PK IN (SELECT PK FROM ARCHIVE.dbo.TABLE5)

DELETE

FROM PRODUCTION.dbo.TABLE6

WHERE PK IN (SELECT PK FROM ARCHIVE.dbo.TABLE6)

END

IF (@TABLE = 'TABLE1')

BEGIN

DELETE

FROM PRODUCTION.dbo.TABLE1

WHERE PK IN (SELECT PK FROM ARCHIVE.dbo.TABLE1)

END

IF (@TABLE = 'TABLE2')

BEGIN

DELETE

FROM PRODUCTION.dbo.TABLE2

WHERE PK IN (SELECT PK FROM ARCHIVE.dbo.TABLE2)

END

IF (@TABLE = 'TABLE3')

BEGIN

DELETE

FROM PRODUCTION.dbo.TABLE3

WHERE PK IN (SELECT PK FROM ARCHIVE.dbo.TABLE3)

END

IF (@TABLE ='TABLE4')

BEGIN

DELETE

FROM PRODUCTION.dbo.TABLE4

WHERE PK IN (SELECT PK FROM ARCHIVE.dbo.TABLE4)

END

IF (@TABLE = 'TABLE5')

BEGIN

DELETE

FROM PRODUCTION.dbo.TABLE5

WHERE PK IN (SELECT PK FROM ARCHIVE.dbo.TABLE5)

END

IF (@TABLE = 'TABLE6')

BEGIN

DELETE

FROM PRODUCTION.dbo.TABLE6

WHERE PK IN (SELECT PK FROM ARCHIVE.dbo.TABLE6)

END

END