APPS.HR_LEAVING_REASON_MIG dependencies on PER_PERIODS_OF_SERVICE

Line 25: l_object_version_number per_periods_of_service.object_version_number%TYPE;

21: -- Declare cursors and local variables
22: --
23: l_proc VARCHAR2(72) := g_package||'leave_reas_mig';
24: l_leaving_reason VARCHAR(30) := p_seeded_leaving_reason;
25: l_object_version_number per_periods_of_service.object_version_number%TYPE;
26: l_count NUMBER := 0;
27: l_total_records NUMBER;
28: l_effective_date DATE := fnd_date.canonical_to_date(p_date);
29: --

Line 37: from per_periods_of_service pos

33: --
34:
35: cursor csr_pds is
36: select pos.period_of_service_id , pos.object_version_number
37: from per_periods_of_service pos
38: where pos.leaving_reason = p_existing_leaving_reason
39: order by pos.period_of_service_id;
40:
41: --