APPS.HR_PERSON_INTERNAL dependencies on PER_COBRA_COV_ENROLLMENTS

Line 287: ,per_cobra_cov_enrollments e

283: where not exists
284: (select null
285: from per_assignments_f a
286: ,per_contact_relationships c
287: ,per_cobra_cov_enrollments e
288: where a.person_id = P_PERSON_ID
289: and a.assignment_id = e.assignment_id
290: and c.person_id = P_PERSON_ID
291: and c.contact_relationship_id = e.contact_relationship_id);

Line 1326: from per_cobra_cov_enrollments c

1322: into l_delete_permitted
1323: from sys.dual
1324: where not exists (
1325: select null
1326: from per_cobra_cov_enrollments c
1327: where exists (
1328: select null
1329: from per_assignments_f a
1330: where a.person_id = P_PERSON_ID

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

2619: hr_utility.set_location(l_proc, 460);
2620: end if;
2621: --
2622: -- Delete COBRA references and then any contact relationships. COBRA
2623: -- must be deleted first as PER_COBRA_COV_ENROLLMENTS has a
2624: -- contact_relationship_id which may be constrained later.
2625: --
2626: begin
2627: --

Line 2631: from per_cobra_cov_enrollments c

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
2633: (select null
2634: from per_assignments_f ass
2635: where ass.assignment_id = c.assignment_id

Line 2655: from per_cobra_cov_enrollments c

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
2657: where r.contact_person_id = P_PERSON_ID
2658: and c.contact_relationship_id = r.contact_relationship_id
2659: and exists

Line 2682: from per_cobra_cov_enrollments c

2678: --
2679: delete from per_cobra_coverage_statuses c2
2680: where c2.cobra_coverage_enrollment_id in
2681: (select c.cobra_coverage_enrollment_id
2682: from per_cobra_cov_enrollments c
2683: where exists
2684: (select null
2685: from per_assignments_f ass
2686: where ass.assignment_id = c.assignment_id

Line 2706: from per_cobra_cov_enrollments c

2702: --
2703: delete from per_cobra_coverage_statuses c2
2704: where c2.cobra_coverage_enrollment_id in
2705: (select c.cobra_coverage_enrollment_id
2706: from per_cobra_cov_enrollments c
2707: ,per_contact_relationships r
2708: where r.contact_person_id = P_PERSON_ID
2709: and c.contact_relationship_id = r.contact_relationship_id
2710: and exists

Line 2733: from per_cobra_cov_enrollments c

2729: --
2730: delete from per_sched_cobra_payments c2
2731: where c2.cobra_coverage_enrollment_id in
2732: (select c.cobra_coverage_enrollment_id
2733: from per_cobra_cov_enrollments c
2734: where exists
2735: (select null
2736: from per_assignments_f ass
2737: where ass.assignment_id = c.assignment_id

Line 2757: from per_cobra_cov_enrollments c

2753: --
2754: delete from per_sched_cobra_payments c2
2755: where c2.cobra_coverage_enrollment_id in
2756: (select c.cobra_coverage_enrollment_id
2757: from per_cobra_cov_enrollments c
2758: ,per_contact_relationships r
2759: where r.contact_person_id = P_PERSON_ID
2760: and c.contact_relationship_id = r.contact_relationship_id
2761: and exists

Line 2781: delete from per_cobra_cov_enrollments c

2777: end if;
2778: --
2779: begin
2780: --
2781: delete from per_cobra_cov_enrollments c
2782: where c.assignment_id in
2783: (select ass.assignment_id
2784: from per_assignments_f ass
2785: where ass.person_id = P_PERSON_ID);

Line 2800: delete from per_cobra_cov_enrollments c

2796: end if;
2797: --
2798: begin
2799: --
2800: delete from per_cobra_cov_enrollments c
2801: where exists
2802: (select null
2803: from per_contact_relationships r
2804: where r.contact_person_id = P_PERSON_ID