APPS.PER_ASG_MIGRATION dependencies on PER_ALL_ASSIGNMENTS_F

Line 47: update per_all_assignments_f paf1

43: fetch csr_projected_end BULK COLLECT INTO startDates,personIds,projDates;
44: --
45: if personIds.COUNT > 0 then
46: FORALL i in personIds.FIRST..personIds.LAST
47: update per_all_assignments_f paf1
48: set paf1.projected_assignment_end = projDates(i)
49: where paf1.period_of_placement_date_start = startDates(i)
50: and paf1.person_id = personIds(i)
51: and not exists (select null

Line 52: from per_all_assignments_f paf2

48: set paf1.projected_assignment_end = projDates(i)
49: where paf1.period_of_placement_date_start = startDates(i)
50: and paf1.person_id = personIds(i)
51: and not exists (select null
52: from per_all_assignments_f paf2
53: where paf1.assignment_id
54: = paf2.assignment_id
55: and paf2.projected_assignment_end is not null);
56: --