455: SELECT past.per_system_status
456: ,p.effective_start_date
457: ,p.effective_end_date
458: FROM per_all_assignments_f p
459: ,per_assignment_status_types past
460: WHERE p.business_group_id = g_business_group_id
461: AND p.effective_start_date =
462: (SELECT MAX (p1.effective_start_date)
463: FROM per_all_assignments_f p1
460: WHERE p.business_group_id = g_business_group_id
461: AND p.effective_start_date =
462: (SELECT MAX (p1.effective_start_date)
463: FROM per_all_assignments_f p1
464: ,per_assignment_status_types past1
465: WHERE p1.assignment_id = p.assignment_id
466: AND past1.assignment_status_type_id = p1.assignment_status_type_id
467: AND past1.per_system_status IN ('ACTIVE_ASSIGN' )
468: )