APPS.IGS_PE_NONIMG_STAT_PKG dependencies on IGS_PE_PERSON_TYPES

Line 102: FROM igs_pe_typ_instances_all typ , igs_pe_person_types per_typ

98: DECLARE
99:
100: CURSOR person_type(l_person_id igs_pe_ev_form.person_id%TYPE) IS
101: SELECT typ.rowid,typ.*
102: FROM igs_pe_typ_instances_all typ , igs_pe_person_types per_typ
103: WHERE typ.person_id = l_person_id
104: AND per_typ.system_type = 'NONIMG_STUDENT'
105: AND typ.person_type_code = per_typ.person_type_code
106: AND typ.end_date IS NULL ;