APPS.PER_FR_TERMINATION_UPG_PKG dependencies on PER_PERIODS_OF_SERVICE

Line 12: FROM per_periods_of_service pds

8: l.lookup_code,
9: p.employee_number,
10: p.full_name,
11: pds.date_start
12: FROM per_periods_of_service pds
13: , per_all_people_f p
14: , hr_lookups l
15: WHERE pds.business_group_id = p_business_group_id
16: AND pds.pds_information2 is not null

Line 85: update per_periods_of_service

81: hr_utility.trace(l_pds.period_of_service_id);
82:
83: SAVEPOINT start_insert;
84:
85: update per_periods_of_service
86: set leaving_reason = pds_information2
87: , pds_information2 = null
88: where period_of_service_id = l_pds.period_of_service_id;
89: