[Home] [Help]
APPS.HR_AMEUTIL_SS dependencies on PER_PERIODS_OF_SERVICE
Line 1717: FROM per_periods_of_service ser
1713: SELECT ROUND(SUM(MONTHS_BETWEEN(
1714: decode(sign(p_eff_date-nvl(actual_termination_date, p_eff_date)),
1715: -1, trunc(p_eff_date), nvl(actual_termination_date, trunc(p_eff_date))),
1716: trunc(ser.date_start))/12), 2) yos
1717: FROM per_periods_of_service ser
1718: WHERE ser.person_id = p_person_id
1719: AND ser.date_start <= p_eff_date;
1720:
1721: BEGIN