DBA Data[Home] [Help]

APPS.HR_PERSON_INTERNAL dependencies on PER_SPINAL_POINT_PLACEMENTS_F

Line 1307: from per_spinal_point_placements_f p

1303: into l_delete_permitted
1304: from sys.dual
1305: where not exists (
1306: select null
1307: from per_spinal_point_placements_f p
1308: where exists (
1309: select null
1310: from per_assignments_f a
1311: where a.person_id = P_PERSON_ID

Line 3182: delete from per_spinal_point_placements_f p

3178: end if;
3179: --
3180: begin
3181: --
3182: delete from per_spinal_point_placements_f p
3183: where p.assignment_id in
3184: (select ass.assignment_id
3185: from per_assignments_f ass
3186: where ass.person_id = P_PERSON_ID);