1265:
1266: CURSOR get_pps_months_cur IS
1267: SELECT sum(months_between(least(nvl(actual_termination_date + 1,
1268: p_effective_date + 1), p_effective_date + 1), date_start)) total_months
1269: FROM per_periods_of_service
1270: WHERE person_id = p_person_id
1271: AND date_start <= p_effective_date
1272: AND period_of_service_id <= p_period_of_service_id;
1273:
1304: CURSOR get_pps_years_cur IS
1305: SELECT sum(months_between
1306: (least(nvl(actual_termination_date + 1, p_effective_date + 1),
1307: p_effective_date + 1), date_start)) / 12 total_years
1308: FROM per_periods_of_service
1309: WHERE person_id = p_person_id
1310: AND date_start <= p_effective_date
1311: AND period_of_service_id <= p_period_of_service_id;
1312: