BEGIN
  CALL PREPARE_FOR_DATA_MODIFICATION('ASV_KGRKO_BRANCH');
  FOR c1 AS tmp_cur CURSOR WITH HOLD FOR
  SELECT
    kb.KGRKO_BRANCH_ID,
    km.KGRKO_MAIN_ID
  FROM ASV_KGRKO_BRANCH kb JOIN ASV_KGRKO_MAIN km ON km.KGRKO_MAIN_REGN = kb.KGRKO_BRANCH_RNBN
  WHERE kb.KGRKO_MAIN_ID IS NULL AND KGRKO_BRANCH_RNBN IS NOT NULL AND KGRKO_MAIN_END_DATE IS NULL
  DO
    UPDATE ASV_KGRKO_BRANCH
    SET
      KGRKO_MAIN_ID = c1.KGRKO_MAIN_ID
    WHERE
      KGRKO_BRANCH_ID = c1.KGRKO_BRANCH_ID;
  END FOR;
  COMMIT;
END;