467: CURSOR csr_partner_details(c_person_id NUMBER)
468: IS
469: SELECT NVL(partner_name,''),
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