APPS.HR_PERSON_INTERNAL dependencies on PER_SECONDARY_ASS_STATUSES

Line 1259: from per_secondary_ass_statuses s

1255: into l_delete_permitted
1256: from sys.dual
1257: where not exists (
1258: select null
1259: from per_secondary_ass_statuses s
1260: where exists (
1261: select null
1262: from per_assignments_f a
1263: where a.person_id = P_PERSON_ID

Line 2658: delete from per_secondary_ass_statuses a

2654: end if;
2655: --
2656: begin
2657: --
2658: delete from per_secondary_ass_statuses a
2659: where a.assignment_id in
2660: (select ass.assignment_id
2661: from per_assignments_f ass
2662: where ass.person_id = P_PERSON_ID);