How to inactivate the Other Classifications for a Department using HDL

Summary:

How to inactivate the Other Classifications for a Department using HDL

Content (required):

I tried using the HDL to make the other classification as inactive but it's loading successfully but still display the same in the UI.

HDL:

METADATA|OrgUnitClassification|OrganizationId|OrgUnitClassificationId|EffectiveStartDate|EffectiveEndDate|Status

MERGE|OrgUnitClassification|300000006651769|300000007346934|2023/04/01||I

MERGE|OrgUnitClassification|300000006651769|300000007346931|2023/04/01||I

Code used to fetch the Organization Id and Organization Unit Classification ID.

select

hrorg.ORGANIZATION_ID orgid,

hrorgtl.NAME orgname,

houc.ORG_UNIT_CLASSIFICATION_ID orgunitclass,

hoctl.classification_name Orgunitclassificationname,

hoctl.CLASSIFICATION_CODE orgunitclasscode

from

hr_all_organization_units_f hrorg,

   hr_organization_units_f_tl hrorgtl,

   hr_org_unit_classifications_f houc,