APPS.HR_PERSON_DELETE dependencies on PER_COBRA_COV_ENROLLMENTS

Line 500: , per_cobra_cov_enrollments e

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

Line 1124: from per_cobra_cov_enrollments c

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

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

2005: --
2006: hr_utility.set_location('HR_PERSON_DELETE.DELETE_A_PERSON', 23);
2007: --
2008: -- Delete COBRA references and then any contact relationships. COBRA
2009: -- must be deleted first as PER_COBRA_COV_ENROLLMENTS has a
2010: -- contact_relationship_id which may be constrained later.
2011: --
2012: begin
2013: delete from per_cobra_coverage_benefits c2

Line 2016: from per_cobra_cov_enrollments c

2012: begin
2013: delete from per_cobra_coverage_benefits c2
2014: where c2.cobra_coverage_enrollment_id in (
2015: select c.cobra_coverage_enrollment_id
2016: from per_cobra_cov_enrollments c
2017: where exists (
2018: select null
2019: from per_assignments_f ass
2020: where ass.assignment_id = c.assignment_id

Line 2034: from per_cobra_cov_enrollments c

2030: begin
2031: delete from per_cobra_coverage_benefits c2
2032: where c2.cobra_coverage_enrollment_id in (
2033: select c.cobra_coverage_enrollment_id
2034: from per_cobra_cov_enrollments c
2035: , per_contact_relationships r
2036: where r.contact_person_id = P_PERSON_ID
2037: and c.contact_relationship_id = r.contact_relationship_id
2038: and exists (

Line 2055: from per_cobra_cov_enrollments c

2051: begin
2052: delete from per_cobra_coverage_statuses c2
2053: where c2.cobra_coverage_enrollment_id in (
2054: select c.cobra_coverage_enrollment_id
2055: from per_cobra_cov_enrollments c
2056: where exists (
2057: select null
2058: from per_assignments_f ass
2059: where ass.assignment_id = c.assignment_id

Line 2073: from per_cobra_cov_enrollments c

2069: begin
2070: delete from per_cobra_coverage_statuses c2
2071: where c2.cobra_coverage_enrollment_id in (
2072: select c.cobra_coverage_enrollment_id
2073: from per_cobra_cov_enrollments c
2074: , per_contact_relationships r
2075: where r.contact_person_id = P_PERSON_ID
2076: and c.contact_relationship_id = r.contact_relationship_id
2077: and exists (

Line 2094: from per_cobra_cov_enrollments c

2090: begin
2091: delete from per_sched_cobra_payments c2
2092: where c2.cobra_coverage_enrollment_id in (
2093: select c.cobra_coverage_enrollment_id
2094: from per_cobra_cov_enrollments c
2095: where exists (
2096: select null
2097: from per_assignments_f ass
2098: where ass.assignment_id = c.assignment_id

Line 2112: from per_cobra_cov_enrollments c

2108: begin
2109: delete from per_sched_cobra_payments c2
2110: where c2.cobra_coverage_enrollment_id in (
2111: select c.cobra_coverage_enrollment_id
2112: from per_cobra_cov_enrollments c
2113: , per_contact_relationships r
2114: where r.contact_person_id = P_PERSON_ID
2115: and c.contact_relationship_id = r.contact_relationship_id
2116: and exists (

Line 2130: delete from per_cobra_cov_enrollments c

2126: --
2127: hr_utility.set_location('HR_PERSON_DELETE.DELETE_A_PERSON', 235);
2128: --
2129: begin
2130: delete from per_cobra_cov_enrollments c
2131: where c.assignment_id in (
2132: select ass.assignment_id
2133: from per_assignments_f ass
2134: where ass.person_id = P_PERSON_ID);

Line 2143: delete from per_cobra_cov_enrollments c

2139: --
2140: hr_utility.set_location('HR_PERSON_DELETE.DELETE_A_PERSON', 236);
2141: --
2142: begin
2143: delete from per_cobra_cov_enrollments c
2144: where exists
2145: (select null
2146: from per_contact_relationships r
2147: where r.contact_person_id = P_PERSON_ID