-- ABS-30985
ALTER TABLE DELIVERYVARIATIONS
DROP CONSTRAINT DELVAR_PACKINGNOTE_ID;

ALTER TABLE DELIVERYVARIATIONS ADD CONSTRAINT DELVAR_PACKINGNOTE_ID FOREIGN KEY
(PACKINGNOTE_ID) REFERENCES PACKINGNOTE (PACKINGNOTE_ID) ON DELETE CASCADE;

ALTER TABLE DELIVERYVARIATIONS
DROP CONSTRAINT DELVAR_CAUSENOTE_ID;

ALTER TABLE DELIVERYVARIATIONS ADD CONSTRAINT DELVAR_CAUSENOTE_ID FOREIGN KEY
(CAUSENOTE_ID) REFERENCES PACKINGNOTE (PACKINGNOTE_ID) ON DELETE CASCADE;