insert into department values(
    "B300",
    "2023-04-01",
    NULL,
    "新設部門",
    (select layer from department where dept_code = "A100"),
    (select up_dept_code from department where dept_code = "A100"),
    "1",
    (select update_user_name from department where dept_code = "A100"),
    "2023-04-01 00:00:00"
);

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
    valid_flg = "1"
and dept_code = "A100"
or  dept_code = "A200";