APPS.HR_PERSON_INTERNAL dependencies on PER_ASSIGNMENT_EXTRA_INFO
Line 1206: from per_assignment_extra_info i
1202: into l_delete_permitted
1203: from sys.dual
1204: where not exists (
1205: select null 1206: from per_assignment_extra_info i 1207: where exists (
1208: select null
1209: from per_assignments_f a
1210: where a.person_id = P_PERSON_ID
Line 2586: delete from per_assignment_extra_info a
2582: end if;
2583: --
2584: begin
2585: -- 2586: delete from per_assignment_extra_info a 2587: where a.assignment_id in
2588: (select ass.assignment_id
2589: from per_assignments_f ass
2590: where ass.person_id = P_PERSON_ID);