APPS.HR_PERSON_DELETE dependencies on HR_ASSIGNMENT_SET_AMENDMENTS

Line 409: hr_assignment_set_amendments asa

405: from sys.dual
406: where not exists (
407: select null
408: from per_assignments_f ass,
409: hr_assignment_set_amendments asa
410: where asa.assignment_id = ass.assignment_id
411: and ass.person_id = P_PERSON_ID
412: and asa.include_or_exclude = 'I'
413: and not exists (

Line 415: from hr_assignment_set_amendments asa2

411: and ass.person_id = P_PERSON_ID
412: and asa.include_or_exclude = 'I'
413: and not exists (
414: select null
415: from hr_assignment_set_amendments asa2
416: where asa2.assignment_set_id = asa.assignment_set_id
417: and asa2.assignment_id <> asa.assignment_id)
418: );
419: EXCEPTION

Line 2362: -- hr_assignment_set_amendments in weak_predel_validation.

2358: --
2359: hr_utility.set_location('HR_PERSON_DELETE.DELETE_A_PERSON', 30);
2360: --
2361: -- Validation has already been performed against
2362: -- hr_assignment_set_amendments in weak_predel_validation.
2363: --
2364: begin
2365: delete from hr_assignment_set_amendments h
2366: where h.assignment_id in (

Line 2365: delete from hr_assignment_set_amendments h

2361: -- Validation has already been performed against
2362: -- hr_assignment_set_amendments in weak_predel_validation.
2363: --
2364: begin
2365: delete from hr_assignment_set_amendments h
2366: where h.assignment_id in (
2367: select ass.assignment_id
2368: from per_assignments_f ass
2369: where ass.person_id = P_PERSON_ID);