APPS.HR_PERSON_DELETE dependencies on PER_SPINAL_POINT_PLACEMENTS_F

Line 1083: from per_spinal_point_placements_f p

1079: into v_delete_permitted
1080: from sys.dual
1081: where not exists (
1082: select null
1083: from per_spinal_point_placements_f p
1084: where exists (
1085: select null
1086: from per_assignments_f a
1087: where a.person_id = P_PERSON_ID

Line 2320: delete from per_spinal_point_placements_f p

2316: --
2317: hr_utility.set_location('HR_PERSON_DELETE.DELETE_A_PERSON', 32);
2318: --
2319: begin
2320: delete from per_spinal_point_placements_f p
2321: where p.assignment_id in (
2322: select ass.assignment_id
2323: from per_assignments_f ass
2324: where ass.person_id = P_PERSON_ID);