DBA Data[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