APPS.HR_PERSON_INTERNAL dependencies on PER_SECONDARY_ASS_STATUSES
Line 1230: from per_secondary_ass_statuses s
1226: into l_delete_permitted
1227: from sys.dual
1228: where not exists (
1229: select null 1230: from per_secondary_ass_statuses s 1231: where exists (
1232: select null
1233: from per_assignments_f a
1234: where a.person_id = P_PERSON_ID
Line 2605: delete from per_secondary_ass_statuses a
2601: end if;
2602: --
2603: begin
2604: -- 2605: delete from per_secondary_ass_statuses a 2606: where a.assignment_id in
2607: (select ass.assignment_id
2608: from per_assignments_f ass
2609: where ass.person_id = P_PERSON_ID);