DBA Data[Home] [Help]

APPS.HR_PERSON_INTERNAL dependencies on PER_ASSIGNMENT_EXTRA_INFO

Line 1235: from per_assignment_extra_info i

1231: into l_delete_permitted
1232: from sys.dual
1233: where not exists (
1234: select null
1235: from per_assignment_extra_info i
1236: where exists (
1237: select null
1238: from per_assignments_f a
1239: where a.person_id = P_PERSON_ID

Line 2639: delete from per_assignment_extra_info a

2635: end if;
2636: --
2637: begin
2638: --
2639: delete from per_assignment_extra_info a
2640: where a.assignment_id in
2641: (select ass.assignment_id
2642: from per_assignments_f ass
2643: where ass.person_id = P_PERSON_ID);