INSERT INTO DEPARTMENT VALUES('B300', '2023-04-01', NULL, '新設部門', 0, '1', '1', NULL, '2023-04-01 00:00:00');
UPDATE DEPARTMENT SET LAYER = (SELECT LAYER FROM DEPARTMENT WHERE DEPT_CODE = 'A100');
UPDATE DEPARTMENT SET UP_DEPT_CODE = (SELECT UP_DEPT_CODE  FROM DEPARTMENT WHERE DEPT_CODE = 'A100');
UPDATE DEPARTMENT SET UPDATE_USER_NAME = (SELECT UPDATE_USER_NAME FROM DEPARTMENT WHERE DEPT_CODE = 'A100');

UPDATE DEPARTMENT SET END_DATE = '2023-03-31' WHERE DEPT_CODE IN ('A100', 'A200');
UPDATE DEPARTMENT SET VALID_FLG = '0' WHERE DEPT_CODE IN ('A100', 'A200');
UPDATE DEPARTMENT SET UPDATE_USER_NAME = 'ORG_CHG' WHERE DEPT_CODE IN ('A100', 'A200');
UPDATE DEPARTMENT SET 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');