737: SELECT per.date_of_birth
738: ,ast.per_system_status
739: FROM per_assignment_status_types ast
740: ,per_assignments_f asg
741: ,per_people_f per
742: WHERE asg.assignment_id = p_assignment_id
743: AND asg.person_id = per.person_id
744: AND p_effective_date BETWEEN asg.effective_start_date AND asg.effective_end_date
745: AND ast.assignment_status_type_id = asg.assignment_status_type_id