INSERT INTO DEPARTMENT 
	select 'B300' as DEPT_CODE
		,'2023-04-01'
		,NULL
		,'新設部門'
		,LAYER
		,UP_DEPT_CODE
		,'1'
		,UPDATE_USER_NAME
		,'2023-04-01 00:00:00'
	from DEPARTMENT 
	where DEPT_CODE = 'A100'
;
--select * from DEPARTMENT where DEPT_CODE = 'B300';

--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')
;
--select * from DEPARTMENT 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 VALID_FLG = '1' and DEPT_CODE in ('A100','A200');