APPS.GHR_SF52_DO_UPDATE dependencies on PER_PERIODS_OF_SERVICE
Line 3055: from per_periods_of_service pds
3051:
3052: Cursor c_pds is
3053: select pds.period_of_service_id,
3054: pds.object_version_number 3055: from per_periods_of_service pds 3056: where pds.person_id = p_pa_request_rec.person_id
3057: and pds.date_start <= g_effective_date
3058: and pds.actual_termination_date is null
3059: order by 1 asc;