INSERT 
INTO department
SELECT
    'B300'
    , '2023-04-01'
    , NULL
    , '新設部門'
    , layer
    , up_dept_code
    , '1'
    , update_user_name
    , '2023-04-01 00:00:00' 
FROM
    department 
WHERE
    dept_code = 'A100' 
GROUP BY
    dept_code
;

UPDATE department 
SET
    end_date = '2023-03-31'
    , valid_flg = '0'
    , update_user_name = 'ORG_CHG'
    , user_update_datetime = '2023-03-31 23:59:59' 
WHERE
    dept_code = 'A100' 
    OR  dept_code = 'A200'
;

UPDATE emp 
SET
    dept_code = 'B300'
    , start_date = '2023-04-01'
    , update_user_name = 'ORG_CHG'
    , user_update_datetime = '2023-04-01 00:00:00' 
WHERE
    dept_code = 'A100' 
    OR dept_code = 'A200'
    AND valid_flg = '1'
;