APPS.HR_MEE_VIEWS_GEN dependencies on PER_PERIODS_OF_SERVICE

Line 995: FROM per_periods_of_service ser

991: SELECT ROUND(SUM(MONTHS_BETWEEN(
992: decode(sign(p_eff_date-nvl(actual_termination_date, p_eff_date)),
993: -1, trunc(p_eff_date), nvl(actual_termination_date, trunc(p_eff_date))),
994: trunc(ser.date_start))/12), 2) yos
995: FROM per_periods_of_service ser
996: WHERE ser.person_id = p_person_id
997: AND ser.date_start <= p_eff_date;
998:
999: BEGIN

Line 1062: FROM per_periods_of_service ser

1058: SELECT ROUND(MONTHS_BETWEEN(
1059: decode(sign(p_eff_date-nvl(actual_termination_date, p_eff_date)),
1060: -1, trunc(p_eff_date), nvl(actual_termination_date, trunc(p_eff_date))),
1061: trunc(ser.adjusted_svc_date))/12, 2) ayos
1062: FROM per_periods_of_service ser
1063: WHERE ser.person_id = p_person_id
1064: AND p_eff_date between ser.date_start and nvl(ser.actual_termination_date, p_eff_date);
1065:
1066: BEGIN