DELETE FROM PL_REQUEST_PROCESS WHERE REQ_ID IN (SELECT REQ_ID FROM TR_REQUEST_DOC)
DELETE FROM PL_REQUEST_PROCESS_CHILD WHERE REQ_ID IN (SELECT REQ_ID FROM TR_REQUEST_DOC)
DELETE FROM PL_PROCESS WHERE REQ_ID IN (SELECT REQ_ID FROM TR_REQUEST_DOC)




EXEC dbo.sp_generate_inserts @table_name = 'PL_REQUEST_PROCESS', -- varchar(776)
@from = 'FROM PL_REQUEST_PROCESS WHERE REQ_ID IN (SELECT REQ_ID FROM TR_REQUEST_DOC)' -- varchar(800)

EXEC dbo.sp_generate_inserts @table_name = 'PL_REQUEST_PROCESS_CHILD', -- varchar(776)
@from = 'FROM PL_REQUEST_PROCESS_CHILD WHERE REQ_ID IN (SELECT REQ_ID FROM TR_REQUEST_DOC)' -- varchar(800)

EXEC dbo.sp_generate_inserts @table_name = 'PL_PROCESS', -- varchar(776)
@from = 'FROM PL_PROCESS WHERE REQ_ID IN (SELECT REQ_ID FROM TR_REQUEST_DOC)' -- varchar(800)