APPS.HR_MEE_VIEWS_GEN dependencies on PER_PERIODS_OF_SERVICE

Line 952: FROM per_periods_of_service ser

948: SELECT ROUND(SUM(MONTHS_BETWEEN(
949: decode(sign(p_eff_date-nvl(actual_termination_date, p_eff_date)),
950: -1, trunc(p_eff_date), nvl(actual_termination_date, trunc(p_eff_date))),
951: trunc(ser.date_start))/12), 2) yos
952: FROM per_periods_of_service ser
953: WHERE ser.person_id = p_person_id
954: AND ser.date_start <= p_eff_date;
955:
956: BEGIN

Line 1019: FROM per_periods_of_service ser

1015: SELECT ROUND(MONTHS_BETWEEN(
1016: decode(sign(p_eff_date-nvl(actual_termination_date, p_eff_date)),
1017: -1, trunc(p_eff_date), nvl(actual_termination_date, trunc(p_eff_date))),
1018: trunc(ser.adjusted_svc_date))/12, 2) ayos
1019: FROM per_periods_of_service ser
1020: WHERE ser.person_id = p_person_id
1021: AND p_eff_date between ser.date_start and nvl(ser.actual_termination_date, p_eff_date);
1022:
1023: BEGIN