DBA Data[Home] [Help]

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