insert into DEPARTMENT
select  'B300' as DEPT_CODE,
        '2023-04-01' as START_DATE,
        NULL as END_DATE,
        '新設部門' as DEPT_NAME,
        LAYER,
        UP_DEPT_CODE,
        '1' as VALID_FLG,
        UPDATE_USER_NAME,
        '2023-04-01 00:00:00' as USER_UPDATE_DATETIME
from    DEPARTMENT
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 = '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'
;