DBA Data[Home] [Help]

APPS.IGS_PE_NONIMG_STAT_PKG dependencies on IGS_PE_EV_FORM

Line 100: CURSOR person_type(l_person_id igs_pe_ev_form.person_id%TYPE) IS

96:
97: BEGIN
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'