DBA Data[Home] [Help]

APPS.HR_PERSON_INTERNAL dependencies on PER_COBRA_COVERAGE_BENEFITS

Line 2628: delete from per_cobra_coverage_benefits c2

2624: -- contact_relationship_id which may be constrained later.
2625: --
2626: begin
2627: --
2628: delete from per_cobra_coverage_benefits c2
2629: where c2.cobra_coverage_enrollment_id in
2630: (select c.cobra_coverage_enrollment_id
2631: from per_cobra_cov_enrollments c
2632: where exists

Line 2652: delete from per_cobra_coverage_benefits c2

2648: end if;
2649: --
2650: begin
2651: --
2652: delete from per_cobra_coverage_benefits c2
2653: where c2.cobra_coverage_enrollment_id in
2654: (select c.cobra_coverage_enrollment_id
2655: from per_cobra_cov_enrollments c
2656: ,per_contact_relationships r