APPS.IGS_EN_GEN_017 dependencies on IGS_PE_PERSON_TYPES

Line 353: l_person_type igs_pe_person_types.person_type_code%TYPE;

349: || Change History :
350: || Who When What
351: */
352: l_person_id igs_pe_person.person_id%TYPE;
353: l_person_type igs_pe_person_types.person_type_code%TYPE;
354: l_cal_type igs_ca_inst.cal_type%TYPE;
355: l_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
356: l_program_cd igs_en_su_attempt_all.course_cd%TYPE;
357: l_primary_code igs_en_su_attempt_all.course_cd%TYPE;

Line 1128: FROM igs_pe_person_types

1124: WHERE person_id = cp_person_id
1125: AND ( end_date IS NULL OR end_date > SYSDATE )
1126: AND person_type_code IN (
1127: SELECT person_type_code
1128: FROM igs_pe_person_types
1129: WHERE system_type = 'STUDENT'
1130: AND closed_ind = 'N'
1131: );
1132: l_person_type igs_pe_typ_instances.person_type_code%TYPE;