DECLARE @REQ_ID VARCHAR(15)
SELECT @REQ_ID = trd.REQ_ID FROM TR_REQUEST_DOC trd WHERE trd.REQ_CODE='PUR/2023/000627'
DECLARE @FROM1 VARCHAR(800) = 'FROM TR_REQUEST_DOC trd WHERE trd.REQ_ID = '''+ @REQ_ID + '''';
DECLARE @FROM2 VARCHAR(800) = 'FROM PL_REQUEST_PROCESS prp WHERE prp.REQ_ID = '''+ @REQ_ID + '''';
DECLARE @FROM3 VARCHAR(800) = 'FROM PL_REQUEST_PROCESS_CHILD prpc WHERE prpc.PROCESS_ID IN (SELECT ID FROM PL_REQUEST_PROCESS prp WHERE prp.REQ_ID = '''+ @REQ_ID + ''')';

EXEC dbo.sp_generate_inserts @table_name = 'TR_REQUEST_DOC', -- varchar(776)
@from = @FROM1 -- varchar(800)

EXEC dbo.sp_generate_inserts @table_name = 'PL_REQUEST_PROCESS', -- varchar(776)
@from = @FROM2 -- varchar(800)

EXEC dbo.sp_generate_inserts @table_name = 'PL_REQUEST_PROCESS_CHILD', -- varchar(776)
@from = @FROM3 -- varchar(800)