DBA Data[Home] [Help]

APPS.HR_PERSON_INTERNAL dependencies on PER_COBRA_COVERAGE_BENEFITS

Line 2681: delete from per_cobra_coverage_benefits c2

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

Line 2705: delete from per_cobra_coverage_benefits c2

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