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' as dept_code
    ,'2023-04-01' as start_date
    ,null as end_date
    ,'新設部門' as dept_name
    ,Layer
    ,up_dept_code
    ,'1' as valid_flg
    ,update_user_name
    ,'2023-04-01 00:00:00' as user_update_datetime
from
    DEPARTMENT
where
    DEPT_CODE='A100'
;


update DEPARTMENT
set (
end_date
,valid_flg
,update_user_name
,user_update_datetime
)
=(
'2023-03-31'
,'0'
,'ORG_CHG'
,'2023-03-31 23:59:59'
)
where
    DEPT_CODE in ('A100', 'A200')
;


update EMP
set (
dept_code
,start_date
,update_user_name
,user_update_datetime
)
=(
'B300'
,'2023-04-01'
,'ORG_CHG'
,'2023-04-01 00:00:00'
)
where
    DEPT_CODE in ('A100', 'A200')
    and valid_flg='1'
;