Remove duplicate MER

Solution for bug 340730 Duplicate MER was entered.
See subtask 341656 Remove Duplicate MER for the exact queries that were run.

Identify and backup the applicant records.

select * from UA006_MEDICAL_EXAMINATION
where FAMILY_NAME_NM = 'familyname'
and upper(FIRST_NAME_NM) like upper('firstname%');

Select specific columns.

select MEDICAL_EXAMINATION_ID, MEDICAL_EXAMINATION_DTE, LICENCE_NUM, APPLICANT_PERSON_ID, FIRST_NAME_NM, FAMILY_NAME_NM, DATE_BIRTH_DTE, STAMP_NUMBER_TXT, DATE_CREATED_DTE, DATE_DELETED_DTE, DATE_LAST_UPDATE_DTE, DATE_EMER_SUBMITTED_DTE
from UA006_MEDICAL_EXAMINATION
where FAMILY_NAME_NM = 'familyname'
and upper(FIRST_NAME_NM) like upper('firstnsme%');

Remove the duplicate record by setting the DATE_DELETED_DTE to current date:

update UA006_MEDICAL_EXAMINATION
set DATE_DELETED_DTE = SYSDATE
where MEDICAL_EXAMINATION_ID = medical_examination_id and LICENCE_NUM = licence_num;

Commit the change to the database:
```
COMMIT;
```

Viewed the change:

--Viewed that change after the update statement was run
select MEDICAL_EXAMINATION_ID, MEDICAL_EXAMINATION_DTE, LICENCE_NUM, FIRST_NAME_NM, FAMILY_NAME_NM, STAMP_NUMBER_TXT, DATE_CREATED_DTE, DATE_DELETED_DTE, DATE_LAST_UPDATE_DTE
from UA006_MEDICAL_EXAMINATION
where MEDICAL_EXAMINATION_ID = medical_examination_id and LICENCE_NUM = licence_num;

Check for related records in UA016_ACTIVITY_CLUSTER:
(there were none for the bug I worked on. If there are, they should also be “removed”).

--check for related records in UA016_ACTIVITY_CLUSTER
select * from UA016_ACTIVITY_CLUSTER
where APPLICANT_PERSON_ID = applicant_person_id
and MEDICAL_EXAMINATION_ID = medical_examination_id;

Check for related records in UA033_APPLICANT_DOCUMENT:
(there were none for the bug I worked on. If there are, they should also be “removed”).
```
--check for related records in UA033_APPLICANT_DOCUMENT
select * from UA033_APPLICANT_DOCUMENT
where APPLICANT_PERSON_ID = applicant_person_id;
```