2677: -- contact_relationship_id which may be constrained later.
2678: --
2679: begin
2680: --
2681: delete from per_cobra_coverage_benefits c2
2682: where c2.cobra_coverage_enrollment_id in
2683: (select c.cobra_coverage_enrollment_id
2684: from per_cobra_cov_enrollments c
2685: where exists
2701: end if;
2702: --
2703: begin
2704: --
2705: delete from per_cobra_coverage_benefits c2
2706: where c2.cobra_coverage_enrollment_id in
2707: (select c.cobra_coverage_enrollment_id
2708: from per_cobra_cov_enrollments c
2709: ,per_contact_relationships r