Thanks for your help Chris and John!
I was able to make this work using the code below.

declare @objcursor as cursor 
declare @delquery as nvarchar(max)
declare @vsql as...

Yes John. I understand this can be done through a simple DELETE statement. The actual code we had earlier was the same, but now as we are generalizing the process...

Thanks for your reply! 
Not really. As mentioned, there is more code to this script which I might not be able to include here.
I will be passing an ID...