[Home] [Help]
247: FROM igs_pe_person_types
248: WHERE rank = ( SELECT MIN(rank)
249: FROM igs_pe_person_types
250: WHERE person_type_code IN ( SELECT person_type_code
251: FROM igs_pe_typ_instances_all
252: WHERE person_id = p_person_id
253: )
254: AND system_type = 'SS_ENROLL_STAFF'
255: AND closed_ind = 'N'