APPS.PER_ASG_MIGRATION SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 33

select date_start,person_id,projected_termination_date
from   per_periods_of_placement
where  period_of_placement_id between p_start_pkid and p_end_pkid
and    projected_termination_date is not null;

Line: 47

    update per_all_assignments_f paf1
    set    paf1.projected_assignment_end = projDates(i)
    where  paf1.period_of_placement_date_start = startDates(i)
    and    paf1.person_id = personIds(i)
    and    not exists (select null
		       from   per_all_assignments_f paf2
		       where  paf1.assignment_id
			    = paf2.assignment_id
		       and    paf2.projected_assignment_end is not null);