APPS.HR_PERSON_DELETE dependencies on PER_COBRA_COV_ENROLLMENTS

Line 499: , per_cobra_cov_enrollments e

495: where not exists (
496: select null
497: from per_assignments_f a
498: , per_contact_relationships c
499: , per_cobra_cov_enrollments e
500: where a.person_id = P_PERSON_ID
501: and a.assignment_id = e.assignment_id
502: and c.person_id = P_PERSON_ID
503: and c.contact_relationship_id = e.contact_relationship_id);

Line 1123: from per_cobra_cov_enrollments c

1119: into v_delete_permitted
1120: from sys.dual
1121: where not exists (
1122: select null
1123: from per_cobra_cov_enrollments c
1124: where exists (
1125: select null
1126: from per_assignments_f a
1127: where a.person_id = P_PERSON_ID

Line 1938: -- must be deleted first as PER_COBRA_COV_ENROLLMENTS has a

1934: --
1935: hr_utility.set_location('HR_PERSON_DELETE.DELETE_A_PERSON', 23);
1936: --
1937: -- Delete COBRA references and then any contact relationships. COBRA
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

Line 1945: from per_cobra_cov_enrollments c

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 (
1947: select null
1948: from per_assignments_f ass
1949: where ass.assignment_id = c.assignment_id

Line 1963: from per_cobra_cov_enrollments c

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
1965: where r.contact_person_id = P_PERSON_ID
1966: and c.contact_relationship_id = r.contact_relationship_id
1967: and exists (

Line 1984: from per_cobra_cov_enrollments c

1980: begin
1981: delete from per_cobra_coverage_statuses c2
1982: where c2.cobra_coverage_enrollment_id in (
1983: select c.cobra_coverage_enrollment_id
1984: from per_cobra_cov_enrollments c
1985: where exists (
1986: select null
1987: from per_assignments_f ass
1988: where ass.assignment_id = c.assignment_id

Line 2002: from per_cobra_cov_enrollments c

1998: begin
1999: delete from per_cobra_coverage_statuses c2
2000: where c2.cobra_coverage_enrollment_id in (
2001: select c.cobra_coverage_enrollment_id
2002: from per_cobra_cov_enrollments c
2003: , per_contact_relationships r
2004: where r.contact_person_id = P_PERSON_ID
2005: and c.contact_relationship_id = r.contact_relationship_id
2006: and exists (

Line 2023: from per_cobra_cov_enrollments c

2019: begin
2020: delete from per_sched_cobra_payments c2
2021: where c2.cobra_coverage_enrollment_id in (
2022: select c.cobra_coverage_enrollment_id
2023: from per_cobra_cov_enrollments c
2024: where exists (
2025: select null
2026: from per_assignments_f ass
2027: where ass.assignment_id = c.assignment_id

Line 2041: from per_cobra_cov_enrollments c

2037: begin
2038: delete from per_sched_cobra_payments c2
2039: where c2.cobra_coverage_enrollment_id in (
2040: select c.cobra_coverage_enrollment_id
2041: from per_cobra_cov_enrollments c
2042: , per_contact_relationships r
2043: where r.contact_person_id = P_PERSON_ID
2044: and c.contact_relationship_id = r.contact_relationship_id
2045: and exists (

Line 2059: delete from per_cobra_cov_enrollments c

2055: --
2056: hr_utility.set_location('HR_PERSON_DELETE.DELETE_A_PERSON', 235);
2057: --
2058: begin
2059: delete from per_cobra_cov_enrollments c
2060: where c.assignment_id in (
2061: select ass.assignment_id
2062: from per_assignments_f ass
2063: where ass.person_id = P_PERSON_ID);

Line 2072: delete from per_cobra_cov_enrollments c

2068: --
2069: hr_utility.set_location('HR_PERSON_DELETE.DELETE_A_PERSON', 236);
2070: --
2071: begin
2072: delete from per_cobra_cov_enrollments c
2073: where exists
2074: (select null
2075: from per_contact_relationships r
2076: where r.contact_person_id = P_PERSON_ID