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
		,'新設部門'
		,LAYER
		,UP_DEPT_CODE
		,'1'
		,UPDATE_USER_NAME
		,'2023-04-01 00:00:00'
	  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 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 DEPT_CODE IN ('A100','A200')
	  AND VALID_FLG = '1'
;