DBA Data[Home] [Help]

APPS.HR_PERSON_DELETE dependencies on PER_COBRA_COVERAGE_BENEFITS

Line 1942: delete from per_cobra_coverage_benefits c2

1938: -- must be deleted first as PER_COBRA_COV_ENROLLMENTS has a
1939: -- contact_relationship_id which may be constrained later.
1940: --
1941: begin
1942: delete from per_cobra_coverage_benefits c2
1943: where c2.cobra_coverage_enrollment_id in (
1944: select c.cobra_coverage_enrollment_id
1945: from per_cobra_cov_enrollments c
1946: where exists (

Line 1960: delete from per_cobra_coverage_benefits c2

1956: --
1957: hr_utility.set_location('HR_PERSON_DELETE.DELETE_A_PERSON', 230);
1958: --
1959: begin
1960: delete from per_cobra_coverage_benefits c2
1961: where c2.cobra_coverage_enrollment_id in (
1962: select c.cobra_coverage_enrollment_id
1963: from per_cobra_cov_enrollments c
1964: , per_contact_relationships r