ACT_HI_VARINST Query on 4.2.6

 INSERT INTO ACT_HI_VARINST(
  ID_,
  PROC_INST_ID_,
  EXECUTION_ID_,
  TASK_ID_,
  NAME_,
  VAR_TYPE_,
  REV_,
  BYTEARRAY_ID_,
  DOUBLE_,
  LONG_,
  TEXT_,
  TEXT2_
)
SELECT
nextval('VARINST_ID_SEQ'),
PROC_INST_ID_,
EXECUTION_ID_,
TASK_ID_,
NAME_,
VAR_TYPE_,
REV_,
BYTEARRAY_ID_,
DOUBLE_,
LONG_,
TEXT_,
TEXT2_
FROM ACT_HI_DETAIL AHD
WHERE AHD.PROC_INST_ID_ not in (select PROC_INST_ID_ from ACT_HI_VARINST)
AND
(AHD.PROC_INST_ID_ , AHD.NAME_, AHD.REV_, AHD.time_) IN
(SELECT PROC_INST_ID_, NAME_, MAX(REV_), MAX(time_)
FROM ACT_HI_DETAIL
GROUP BY PROC_INST_ID_ , NAME_)