APPS.HR_PERSON_INTERNAL dependencies on PER_CONTACT_RELATIONSHIPS

Line 286: ,per_contact_relationships c

282: from sys.dual
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

Line 390: from per_contact_relationships r

386: into l_contact_elsewhere
387: from sys.dual
388: where exists
389: (select null
390: from per_contact_relationships r
391: where r.contact_relationship_id <> P_CONTACT_RELATIONSHIP_ID
392: and r.contact_person_id = P_CONTACT_PERSON_ID);
393: --
394: exception

Line 867: from per_contact_relationships r

863: into l_delete_permitted
864: from sys.dual
865: where not exists (
866: select null
867: from per_contact_relationships r
868: where r.person_id = P_PERSON_ID
869: or r.contact_person_id = P_PERSON_ID);
870: --
871: exception

Line 1948: FROM per_contact_relationships

1944: --
1945: CURSOR csr_this_persons_contacts IS
1946: SELECT contact_person_id,
1947: contact_relationship_id
1948: FROM per_contact_relationships
1949: WHERE person_id = P_PERSON_ID;
1950: --
1951: CURSOR csr_lock_person_rows IS
1952: SELECT person_id

Line 2656: ,per_contact_relationships r

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
2660: (select null

Line 2707: ,per_contact_relationships r

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
2711: (select null

Line 2758: ,per_contact_relationships r

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
2762: (select null

Line 2803: from per_contact_relationships r

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
2805: and c.contact_relationship_id = r.contact_relationship_id
2806: and exists
2807: (select null

Line 2834: from per_contact_relationships r

2830: --
2831: delete from ben_covered_dependents_f c
2832: where c.contact_relationship_id in
2833: (select r.contact_relationship_id
2834: from per_contact_relationships r
2835: where r.contact_person_id = p_person_id
2836: );
2837: --
2838: exception

Line 2865: from per_contact_relationships r

2861: begin
2862: --
2863: select count(*)
2864: into l_dummy
2865: from per_contact_relationships r
2866: where r.person_id = P_PERSON_ID;
2867: --
2868: if l_dummy > 0 then
2869: for EACH_CONTACT in csr_this_persons_contacts loop

Line 2871: delete from per_contact_relationships r

2867: --
2868: if l_dummy > 0 then
2869: for EACH_CONTACT in csr_this_persons_contacts loop
2870: --
2871: delete from per_contact_relationships r
2872: where (r.person_id = P_PERSON_ID
2873: and r.contact_person_id = EACH_CONTACT.CONTACT_PERSON_ID)
2874: or (r.person_id = EACH_CONTACT.CONTACT_PERSON_ID
2875: and r.contact_person_id = P_PERSON_ID);

Line 2899: delete from per_contact_relationships r

2895: end if;
2896: --
2897: begin
2898: --
2899: delete from per_contact_relationships r
2900: where r.contact_person_id = P_PERSON_ID;
2901: --
2902: exception
2903: when NO_DATA_FOUND then