Inactive Organizations

To Inactive Organizations existing organizations from back end:

update hr_organization_information o3 set ORG_INFORMATION2='N' where ORG_INFORMATION1='INV'
and ORGANIZATION_ID in (
select ORGANIZATION_ID FROM hr_all_organization_units hao-- where NAME='CTG-MAT-AMCL'
where DATE_FROM<=to_date('9/24/2019','mm-dd-yyyy') and DATE_to is null
and NAME like 'HIP-%'
)


update hr_all_organization_units hao set DATE_TO =to_date(sysdate-1,'dd-mm-yyyy')
where DATE_FROM<=to_date('9/24/2019','mm-dd-yyyy') and DATE_TO is null and NAME like 'HIP-%'