[Home] [Help]
470: partner_ni_number
471: FROM ssp_medicals
472: WHERE maternity_id IN
473: (SELECT MAX(maternity_id)
474: FROM per_absence_attendances
475: WHERE person_id = c_person_id
476: AND ABSENCE_ATTENDANCE_TYPE_ID IN
477: (SELECT ABSENCE_ATTENDANCE_TYPE_ID
478: FROM per_absence_attendance_types