DBA Data[Home] [Help]

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);