insert into department
select
    'B300'
    ,'2023-04-01'
    ,NULL
    ,'新設部門'
    ,A100.layer
    ,A100.up_dept_code
    ,'1'
    ,A100.UPDATE_USER_NAME
    ,'2023-04-01 00:00:00'
from department as A100
where dept_code='A100';

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 in ('A100','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 in ('A100','A200')
and valid_flg ='1';