APPS.IGS_PE_NONIMG_FORM_PKG dependencies on IGS_PE_PERSON_TYPES

Line 162: CURSOR per_type(cp_system_type igs_pe_person_types.system_type%TYPE,cp_closed_ind igs_pe_person_types.closed_ind%TYPE)IS

158:
159: (reverse chronological order - newest change first)
160: ***************************************************************/
161:
162: CURSOR per_type(cp_system_type igs_pe_person_types.system_type%TYPE,cp_closed_ind igs_pe_person_types.closed_ind%TYPE)IS
163: SELECT person_type_code
164: FROM igs_pe_person_types
165: WHERE system_type = cp_system_type --'NONIMG_STUDENT'
166: AND closed_ind = cp_closed_ind; --'N';

Line 164: FROM igs_pe_person_types

160: ***************************************************************/
161:
162: CURSOR per_type(cp_system_type igs_pe_person_types.system_type%TYPE,cp_closed_ind igs_pe_person_types.closed_ind%TYPE)IS
163: SELECT person_type_code
164: FROM igs_pe_person_types
165: WHERE system_type = cp_system_type --'NONIMG_STUDENT'
166: AND closed_ind = cp_closed_ind; --'N';
167:
168: CURSOR person_type(cp_system_type igs_pe_person_types.system_type%TYPE)IS

Line 168: CURSOR person_type(cp_system_type igs_pe_person_types.system_type%TYPE)IS

164: FROM igs_pe_person_types
165: WHERE system_type = cp_system_type --'NONIMG_STUDENT'
166: AND closed_ind = cp_closed_ind; --'N';
167:
168: CURSOR person_type(cp_system_type igs_pe_person_types.system_type%TYPE)IS
169: SELECT typ.rowid,typ.*
170: FROM igs_pe_typ_instances_all typ , igs_pe_person_types per_typ
171: WHERE per_typ.system_type = cp_system_type --'NONIMG_STUDENT'
172: AND typ.person_id = new_references.person_id

Line 170: FROM igs_pe_typ_instances_all typ , igs_pe_person_types per_typ

166: AND closed_ind = cp_closed_ind; --'N';
167:
168: CURSOR person_type(cp_system_type igs_pe_person_types.system_type%TYPE)IS
169: SELECT typ.rowid,typ.*
170: FROM igs_pe_typ_instances_all typ , igs_pe_person_types per_typ
171: WHERE per_typ.system_type = cp_system_type --'NONIMG_STUDENT'
172: AND typ.person_id = new_references.person_id
173: AND typ.person_type_code = per_typ.person_type_code
174: AND typ.end_date IS NULL ;