INSERT INTO DEPARTMENT
 SELECT
  'B300' as DEPT_CODE, 
  '2023-04-01' as START_DATE, 
  NULL as END_DATE, 
  '新設部門' as DEPT_NAME, 
  d.LAYER as LAYER, 
  d.UP_DEPT_CODE as UP_DEPT_CODE,
  '1' as VALID_FLG, 
  d.UPDATE_USER_NAME as UPDATE_USER_NAME,
  '2023-04-01 00:00:00' as USER_UPDATE_DATETIME
 FROM
  DEPARTMENT d
 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
  VALID_FLG = '1'
  and DEPT_CODE in ('A100','A200')
;