[Home] [Help]
APPS.HRI_BPL_PERIOD_OF_WORK dependencies on PER_PERIODS_OF_SERVICE
Line 401: FROM per_periods_of_service
397: p_effective_date + 1),
398: p_effective_date + 1),
399: date_start)) total_months
400: ,MAX(date_start) latest_hire_date
401: FROM per_periods_of_service
402: WHERE person_id = p_person_id
403: AND date_start <= p_effective_date;
404:
405: BEGIN