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 valid_flg = '1' and DEPT_CODE IN ('A100', 'A200');