-- 処理1 =======================================

insert 
into DEPARTMENT
( DEPT_CODE
, START_DATE
, END_DATE
, DEPT_NAME
, LAYER
, UP_DEPT_CODE
, VALID_FLG
, UPDATE_USER_NAME
, USER_UPDATE_DATETIME)

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';

-- 処理2 =======================================

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');

-- 処理3 =======================================

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';