APPS.HR_PERSON_DELETE dependencies on PER_CONTACT_RELATIONSHIPS

Line 498: , per_contact_relationships c

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

Line 742: from per_contact_relationships r

738: into v_delete_permitted
739: from sys.dual
740: where not exists (
741: select null
742: from per_contact_relationships r
743: where r.person_id = P_PERSON_ID
744: or r.contact_person_id = P_PERSON_ID);
745: exception
746: when NO_DATA_FOUND then

Line 1330: from per_contact_relationships r

1326: into v_contact_elsewhere
1327: from sys.dual
1328: where exists (
1329: select null
1330: from per_contact_relationships r
1331: where r.contact_relationship_id <> P_CONTACT_RELATIONSHIP_ID
1332: and r.contact_person_id = P_CONTACT_PERSON_ID);
1333: exception
1334: when NO_DATA_FOUND then null;

Line 1407: from per_contact_relationships

1403: --
1404: cursor THIS_PERSONS_CONTACTS is
1405: select contact_person_id,
1406: contact_relationship_id
1407: from per_contact_relationships
1408: where person_id = P_PERSON_ID;
1409: --
1410: cursor LOCK_PERSON_ROWS is
1411: select person_id

Line 1964: , per_contact_relationships r

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

Line 2003: , per_contact_relationships r

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

Line 2042: , per_contact_relationships r

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

Line 2075: from per_contact_relationships r

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
2077: and c.contact_relationship_id = r.contact_relationship_id
2078: and exists (
2079: select null

Line 2100: from per_contact_relationships r

2096: begin
2097: delete from ben_covered_dependents_f c
2098: where c.contact_relationship_id in (
2099: select r.contact_relationship_id
2100: from per_contact_relationships r
2101: where r.contact_person_id = p_person_id
2102: );
2103: exception
2104: when NO_DATA_FOUND then

Line 2126: from per_contact_relationships r

2122: --
2123: begin
2124: select count(*)
2125: into v_dummy
2126: from per_contact_relationships r
2127: where r.person_id = P_PERSON_ID;
2128: --
2129: if v_dummy > 0 then
2130: for EACH_CONTACT in THIS_PERSONS_CONTACTS loop

Line 2132: delete from per_contact_relationships r

2128: --
2129: if v_dummy > 0 then
2130: for EACH_CONTACT in THIS_PERSONS_CONTACTS loop
2131: --
2132: delete from per_contact_relationships r
2133: where (r.person_id = P_PERSON_ID
2134: and r.contact_person_id = EACH_CONTACT.CONTACT_PERSON_ID)
2135: or (r.person_id = EACH_CONTACT.CONTACT_PERSON_ID
2136: and r.contact_person_id = P_PERSON_ID);

Line 2153: delete from per_contact_relationships r

2149: --
2150: hr_utility.set_location('HR_PERSON_DELETE.DELETE_A_PERSON', 24);
2151: --
2152: begin
2153: delete from per_contact_relationships r
2154: where r.contact_person_id = P_PERSON_ID;
2155: exception
2156: when NO_DATA_FOUND then
2157: hr_utility.set_location('HR_PERSON_DELETE.DELETE_A_PERSON', 2401);