DBA Data[Home] [Help]

APPS.HR_PERSON_DELETE dependencies on PER_SECONDARY_ASS_STATUSES

Line 1042: from per_secondary_ass_statuses s

1038: into v_delete_permitted
1039: from sys.dual
1040: where not exists (
1041: select null
1042: from per_secondary_ass_statuses s
1043: where exists (
1044: select null
1045: from per_assignments_f a
1046: where a.person_id = P_PERSON_ID

Line 1925: delete from per_secondary_ass_statuses a

1921: --
1922: hr_utility.set_location('HR_PERSON_DELETE.DELETE_A_PERSON', 22);
1923: --
1924: begin
1925: delete from per_secondary_ass_statuses a
1926: where a.assignment_id in (
1927: select ass.assignment_id
1928: from per_assignments_f ass
1929: where ass.person_id = P_PERSON_ID);