APPS.PER_ASG_MIGRATION dependencies on PER_PERIODS_OF_PLACEMENT

Line 11: -- projected_assignment_end from values in per_periods_of_placement.

7: --
8: --
9: -- Description:
10: -- This procedure migrates a chunk of Assignment records, populating the column
11: -- projected_assignment_end from values in per_periods_of_placement.
12: --
13: -- Don't update the row if there is any DT instance for this PKid or any in the
14: -- same placement which have projected_assignment_end populated with non-null value
15: --

Line 34: from per_periods_of_placement

30: projDates projectedEndDateTab;
31: --
32: cursor csr_projected_end is
33: select date_start,person_id,projected_termination_date
34: from per_periods_of_placement
35: where period_of_placement_id between p_start_pkid and p_end_pkid
36: and projected_termination_date is not null;
37: --
38: l_rows_processed number := 0;