APPS.IGS_EN_GEN_017 dependencies on IGS_PE_TYP_INSTANCES

Line 55: l_person_type igs_pe_typ_instances.person_type_code%TYPE;

51: || as part of validation impact CR ENCR034.
52: || (reverse chronological order - newest change first)
53: */
54: l_person_id igs_pe_person_base_v.person_id%TYPE;
55: l_person_type igs_pe_typ_instances.person_type_code%TYPE;
56: l_cal_type igs_ca_inst.cal_type%TYPE;
57: l_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
58: l_primary_code igs_ps_ver.course_cd%TYPE;
59: l_primary_version igs_ps_ver.version_number%TYPE;

Line 959: l_person_type igs_pe_typ_instances.person_type_code%TYPE;

955:
956: IS
957: -- local variables
958: l_person_id igs_pe_person.person_id%TYPE;
959: l_person_type igs_pe_typ_instances.person_type_code%TYPE;
960: l_error_message VARCHAR2(2000);
961: l_ret_status VARCHAR2(10);
962: l_primary_program_code igs_ps_ver.course_cd%TYPE;
963: l_primary_program_version igs_ps_ver.version_number%TYPE;

Line 1123: FROM igs_pe_typ_instances

1119: cursor to validate that the person number is a valid 'STUDENT' in the system
1120: */
1121: CURSOR c_vld_student (cp_person_id igs_pe_person_base_v.person_id%TYPE) IS
1122: SELECT person_type_code
1123: FROM igs_pe_typ_instances
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

Line 1132: l_person_type igs_pe_typ_instances.person_type_code%TYPE;

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;
1133:
1134: /*
1135: cursor to fetch the RESP_ID and RESP_APPL_ID against the user_id
1136: */