Query API to inactive Oracle Customer Sites

DECLARE
CURSOR C IS
select  CDC.CUSTOMER_ID,CDC.CUSTOMER_NAME,HCASA.* from stm_cust.CUST_DEACTIVE_CUST cdc,apps.hz_cust_accounts hca,apps.hz_cust_acct_sites_all hcasa
where cdc.customer_id = hca.cust_Account_id
and hca.cust_Account_id = hcasa.cust_Account_id
AND HCASA.STATUS = 'A'
and hcasa.org_id = 113
ORDER BY CUST_aCCT_SITE_ID;

BEGIN
FOR I IN C
LOOP
UPDATE apps.hz_cust_acct_sites_all
SET STATUS = 'I'
WHERE CUST_aCCT_SITE_ID = I.CUST_ACCT_SITE_ID
AND ORG_ID = 113
AND CUST_ACCOUNT_ID = I.CUST_ACCOUNT_ID;

COMMIT;
END LOOP;
END;