APPS.HR_PERSON_DELETE dependencies on PER_SPINAL_POINT_PLACEMENTS_F

Line 1084: from per_spinal_point_placements_f p

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

Line 2391: delete from per_spinal_point_placements_f p

2387: --
2388: hr_utility.set_location('HR_PERSON_DELETE.DELETE_A_PERSON', 32);
2389: --
2390: begin
2391: delete from per_spinal_point_placements_f p
2392: where p.assignment_id in (
2393: select ass.assignment_id
2394: from per_assignments_f ass
2395: where ass.person_id = P_PERSON_ID);