APPS.IGS_PE_NONIMG_STAT_PKG dependencies on IGS_PE_TYP_INSTANCES_ALL

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 ;

Line 117: l_end_method igs_pe_typ_instances_all.end_method%TYPE;

113:
114: l_form c_get_form_values%ROWTYPE;
115: l_form_status igs_pe_nonimg_form.form_status%TYPE;
116: l_end_date DATE;
117: l_end_method igs_pe_typ_instances_all.end_method%TYPE;
118: lv_userid NUMBER;
119: l_person_type person_type%ROWTYPE;
120:
121: