457: --
458:
459: CURSOR c_pps_start_dt IS
460: SELECT pps.date_start
461: FROM per_periods_of_service pps
462: WHERE pps.period_of_service_id = p_period_of_service_id
463: AND pps.person_id = p_person_id;
464:
465: l_ret_val date;
516: --
517:
518: CURSOR c_pps_end_dt IS
519: SELECT NVL(pps.actual_termination_date,TO_DATE('12/31/4712','MM/DD/YYYY'))
520: FROM per_periods_of_service pps
521: WHERE pps.period_of_service_id = p_period_of_service_id
522: AND pps.person_id = p_person_id;
523:
524: l_ret_val date;