APPS.HR_PERSON_DELETE dependencies on PER_CONTACT_RELATIONSHIPS

Line 499: , per_contact_relationships c

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

Line 743: from per_contact_relationships r

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

Line 1331: from per_contact_relationships r

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

Line 1408: from per_contact_relationships

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

Line 2035: , per_contact_relationships r

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

Line 2074: , per_contact_relationships r

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

Line 2113: , per_contact_relationships r

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

Line 2146: from per_contact_relationships r

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
2148: and c.contact_relationship_id = r.contact_relationship_id
2149: and exists (
2150: select null

Line 2171: from per_contact_relationships r

2167: begin
2168: delete from ben_covered_dependents_f c
2169: where c.contact_relationship_id in (
2170: select r.contact_relationship_id
2171: from per_contact_relationships r
2172: where r.contact_person_id = p_person_id
2173: );
2174: exception
2175: when NO_DATA_FOUND then

Line 2197: from per_contact_relationships r

2193: --
2194: begin
2195: select count(*)
2196: into v_dummy
2197: from per_contact_relationships r
2198: where r.person_id = P_PERSON_ID;
2199: --
2200: if v_dummy > 0 then
2201: for EACH_CONTACT in THIS_PERSONS_CONTACTS loop

Line 2203: delete from per_contact_relationships r

2199: --
2200: if v_dummy > 0 then
2201: for EACH_CONTACT in THIS_PERSONS_CONTACTS loop
2202: --
2203: delete from per_contact_relationships r
2204: where (r.person_id = P_PERSON_ID
2205: and r.contact_person_id = EACH_CONTACT.CONTACT_PERSON_ID)
2206: or (r.person_id = EACH_CONTACT.CONTACT_PERSON_ID
2207: and r.contact_person_id = P_PERSON_ID);

Line 2224: delete from per_contact_relationships r

2220: --
2221: hr_utility.set_location('HR_PERSON_DELETE.DELETE_A_PERSON', 24);
2222: --
2223: begin
2224: delete from per_contact_relationships r
2225: where r.contact_person_id = P_PERSON_ID;
2226: exception
2227: when NO_DATA_FOUND then
2228: hr_utility.set_location('HR_PERSON_DELETE.DELETE_A_PERSON', 2401);