248: */
249:
250: CURSOR person_type_cur(cp_system_type igs_pe_person_types.system_type%TYPE) IS
251: SELECT ti.rowid,ti.*
252: FROM igs_pe_typ_instances_all ti,
253: igs_pe_person_types pt,
254: per_all_people_f ppf
255: WHERE ppf.party_id = ti.person_id AND
256: ti.person_type_code = pt.person_type_code AND
267:
268:
269: CURSOR ss_cur (cp_person_id HZ_PARTIES.PARTY_ID%TYPE) IS
270: SELECT ti.rowid,ti.*
271: FROM igs_pe_typ_instances_all ti,
272: igs_pe_person_types pt
273: WHERE ti.person_type_code = pt.person_type_code AND
274: pt.system_type = 'SS_ENROLL_STAFF' AND
275: ti.person_id = cp_person_id;