--処理1
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'
;
--処理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'
,	UPDATE_USER_NAME = 'ORG_CHG'
,	USER_UPDATE_DATETIME = '2023-04-01 00:00:00'
WHERE
	DEPT_CODE IN ('A100','A200')
AND	VALID_FLG = '1'