455: SELECT pos.actual_termination_date
456: ,ppf.business_group_id
457: FROM per_periods_of_service pos
458: ,per_assignments_f paf
459: ,per_people_f ppf
460: WHERE pos.period_of_service_id = p_period_of_service_id
461: AND pos.period_of_service_id = paf.period_of_service_id
462: AND paf.person_id = ppf.person_id
463: AND p_effective_date BETWEEN ppf.effective_start_date