-- 1
INSERT INTO
	DEPARTMENT
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'
;

-- 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'
WHERE
	VALID_FLG = '1'
;