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'
        ,'2023-04-01'
        ,NULL
        ,'新設部門'
        ,d.LAYER
        ,d.UP_DEPT_CODE
        ,'1'
        ,d.UPDATE_USER_NAME
        ,'2023-04-01 00:00:00'
FROM DEPARTMENT d
WHERE d.DEPT_CODE = 'A100';
--select * from DEPARTMENT where dept_code = 'B300'

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');
--select * from DEPARTMENT where dept_code in ('A100','A200','B300')

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