APPS.PAY_GB_RTI_FPS_ARCHIVE dependencies on SSP_MEDICALS

Line 1789: FROM ssp_medicals

1785: CURSOR csr_partner_details(c_person_id NUMBER)
1786: IS
1787: SELECT NVL(partner_name,''),
1788: partner_ni_number
1789: FROM ssp_medicals
1790: WHERE maternity_id IN
1791: (SELECT MAX(maternity_id)
1792: FROM per_absence_attendances
1793: WHERE person_id = c_person_id