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 896: from per_contact_relationships r

892: into l_delete_permitted
893: from sys.dual
894: where not exists (
895: select null
896: from per_contact_relationships r
897: where r.person_id = P_PERSON_ID
898: or r.contact_person_id = P_PERSON_ID);
899: --
900: exception

Line 1979: FROM per_contact_relationships

1975: --
1976: CURSOR csr_this_persons_contacts IS
1977: SELECT contact_person_id,
1978: contact_relationship_id
1979: FROM per_contact_relationships
1980: WHERE person_id = P_PERSON_ID;
1981: --
1982: CURSOR csr_lock_person_rows IS
1983: SELECT person_id

Line 2709: ,per_contact_relationships r

2705: delete from per_cobra_coverage_benefits c2
2706: where c2.cobra_coverage_enrollment_id in
2707: (select c.cobra_coverage_enrollment_id
2708: from per_cobra_cov_enrollments c
2709: ,per_contact_relationships r
2710: where r.contact_person_id = P_PERSON_ID
2711: and c.contact_relationship_id = r.contact_relationship_id
2712: and exists
2713: (select null

Line 2760: ,per_contact_relationships r

2756: delete from per_cobra_coverage_statuses c2
2757: where c2.cobra_coverage_enrollment_id in
2758: (select c.cobra_coverage_enrollment_id
2759: from per_cobra_cov_enrollments c
2760: ,per_contact_relationships r
2761: where r.contact_person_id = P_PERSON_ID
2762: and c.contact_relationship_id = r.contact_relationship_id
2763: and exists
2764: (select null

Line 2811: ,per_contact_relationships r

2807: delete from per_sched_cobra_payments c2
2808: where c2.cobra_coverage_enrollment_id in
2809: (select c.cobra_coverage_enrollment_id
2810: from per_cobra_cov_enrollments c
2811: ,per_contact_relationships r
2812: where r.contact_person_id = P_PERSON_ID
2813: and c.contact_relationship_id = r.contact_relationship_id
2814: and exists
2815: (select null

Line 2856: from per_contact_relationships r

2852: --
2853: delete from per_cobra_cov_enrollments c
2854: where exists
2855: (select null
2856: from per_contact_relationships r
2857: where r.contact_person_id = P_PERSON_ID
2858: and c.contact_relationship_id = r.contact_relationship_id
2859: and exists
2860: (select null

Line 2887: from per_contact_relationships r

2883: --
2884: delete from ben_covered_dependents_f c
2885: where c.contact_relationship_id in
2886: (select r.contact_relationship_id
2887: from per_contact_relationships r
2888: where r.contact_person_id = p_person_id
2889: );
2890: --
2891: exception

Line 2918: from per_contact_relationships r

2914: begin
2915: --
2916: select count(*)
2917: into l_dummy
2918: from per_contact_relationships r
2919: where r.person_id = P_PERSON_ID;
2920: --
2921: if l_dummy > 0 then
2922: for EACH_CONTACT in csr_this_persons_contacts loop

Line 2924: delete from per_contact_relationships r

2920: --
2921: if l_dummy > 0 then
2922: for EACH_CONTACT in csr_this_persons_contacts loop
2923: --
2924: delete from per_contact_relationships r
2925: where (r.person_id = P_PERSON_ID
2926: and r.contact_person_id = EACH_CONTACT.CONTACT_PERSON_ID)
2927: or (r.person_id = EACH_CONTACT.CONTACT_PERSON_ID
2928: and r.contact_person_id = P_PERSON_ID);

Line 2952: delete from per_contact_relationships r

2948: end if;
2949: --
2950: begin
2951: --
2952: delete from per_contact_relationships r
2953: where r.contact_person_id = P_PERSON_ID;
2954: --
2955: exception
2956: when NO_DATA_FOUND then