DBA Data[Home] [Help]

APPS.HR_AMEUTIL_SS dependencies on PER_PERIODS_OF_SERVICE

Line 1715: FROM per_periods_of_service ser

1711: SELECT ROUND(SUM(MONTHS_BETWEEN(
1712: decode(sign(p_eff_date-nvl(actual_termination_date, p_eff_date)),
1713: -1, trunc(p_eff_date), nvl(actual_termination_date, trunc(p_eff_date))),
1714: trunc(ser.date_start))/12), 2) yos
1715: FROM per_periods_of_service ser
1716: WHERE ser.person_id = p_person_id
1717: AND ser.date_start <= p_eff_date;
1718:
1719: BEGIN