APPS.PER_PEOPLE3_PKG dependencies on PER_PERIODS_OF_SERVICE

Line 336: from per_periods_of_service pps

332: --
333: -- Define Cursor.
334: --
335: cursor pps is select rowid,pps.*
336: from per_periods_of_service pps
337: where person_id = p_person_id
338: and date_start = p_hire_date
339: for update of date_start nowait;
340: --

Line 371: per_periods_of_service_pkg.update_row(p_row_id => pps_rec.rowid

367: l_adjusted_svc_date := pps_rec.adjusted_svc_date;
368: end if;
369: -- Now update the row;
370: --
371: per_periods_of_service_pkg.update_row(p_row_id => pps_rec.rowid
372: ,p_period_of_service_id => pps_rec.PERIOD_OF_SERVICE_ID
373: ,p_business_group_id => pps_rec.BUSINESS_GROUP_ID
374: ,p_person_id => pps_rec.PERSON_ID
375: ,p_date_start => p_new_hire_date