While testing I see a couple of items missing:

Msg 208, Level 16, State 1, Line 1

Invalid object name 'RN_UPD'. (RN_UPD Table is Missing)

Msg 208, Level 16, State 1, Line 2

Invalid object name 'dbo.Load_RN'. (Load_RN Table is Missing)

Msg 208, Level 16, State 1, Line 2

Invalid object name 'dbo.GetNextWednesdaysDate'. (GetNextWednesdaysDate SP is Missing)

Can you please add it? thanks!