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 IN ('A100')
  AND END_DATE IS NULL ;



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')
  AND END_DATE IS NULL;
 


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';