76: TYPE c_pend_futCurTyp IS REF CURSOR;
77: c_pend_fut c_pend_futCurTyp;
78:
79: TYPE c_pend_futrecTyp IS RECORD (rowid igs_ad_ps_appl_inst.ROW_ID%TYPE,
80: person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
81: admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
82: nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
83: sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE,
84: predicted_gpa igs_ad_ps_appl_inst_all.predicted_gpa%TYPE,
77: c_pend_fut c_pend_futCurTyp;
78:
79: TYPE c_pend_futrecTyp IS RECORD (rowid igs_ad_ps_appl_inst.ROW_ID%TYPE,
80: person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
81: admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
82: nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
83: sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE,
84: predicted_gpa igs_ad_ps_appl_inst_all.predicted_gpa%TYPE,
85: academic_index igs_ad_ps_appl_inst_all.academic_index%TYPE,
78:
79: TYPE c_pend_futrecTyp IS RECORD (rowid igs_ad_ps_appl_inst.ROW_ID%TYPE,
80: person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
81: admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
82: nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
83: sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE,
84: predicted_gpa igs_ad_ps_appl_inst_all.predicted_gpa%TYPE,
85: academic_index igs_ad_ps_appl_inst_all.academic_index%TYPE,
86: adm_cal_type igs_ad_ps_appl_inst_all.adm_cal_type%TYPE,
79: TYPE c_pend_futrecTyp IS RECORD (rowid igs_ad_ps_appl_inst.ROW_ID%TYPE,
80: person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
81: admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
82: nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
83: sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE,
84: predicted_gpa igs_ad_ps_appl_inst_all.predicted_gpa%TYPE,
85: academic_index igs_ad_ps_appl_inst_all.academic_index%TYPE,
86: adm_cal_type igs_ad_ps_appl_inst_all.adm_cal_type%TYPE,
87: app_file_location igs_ad_ps_appl_inst_all.app_file_location%TYPE,
80: person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
81: admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
82: nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
83: sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE,
84: predicted_gpa igs_ad_ps_appl_inst_all.predicted_gpa%TYPE,
85: academic_index igs_ad_ps_appl_inst_all.academic_index%TYPE,
86: adm_cal_type igs_ad_ps_appl_inst_all.adm_cal_type%TYPE,
87: app_file_location igs_ad_ps_appl_inst_all.app_file_location%TYPE,
88: adm_ci_sequence_number igs_ad_ps_appl_inst_all.adm_ci_sequence_number%TYPE,
81: admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
82: nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
83: sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE,
84: predicted_gpa igs_ad_ps_appl_inst_all.predicted_gpa%TYPE,
85: academic_index igs_ad_ps_appl_inst_all.academic_index%TYPE,
86: adm_cal_type igs_ad_ps_appl_inst_all.adm_cal_type%TYPE,
87: app_file_location igs_ad_ps_appl_inst_all.app_file_location%TYPE,
88: adm_ci_sequence_number igs_ad_ps_appl_inst_all.adm_ci_sequence_number%TYPE,
89: course_cd igs_ad_ps_appl_inst_all.course_cd%TYPE,
82: nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
83: sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE,
84: predicted_gpa igs_ad_ps_appl_inst_all.predicted_gpa%TYPE,
85: academic_index igs_ad_ps_appl_inst_all.academic_index%TYPE,
86: adm_cal_type igs_ad_ps_appl_inst_all.adm_cal_type%TYPE,
87: app_file_location igs_ad_ps_appl_inst_all.app_file_location%TYPE,
88: adm_ci_sequence_number igs_ad_ps_appl_inst_all.adm_ci_sequence_number%TYPE,
89: course_cd igs_ad_ps_appl_inst_all.course_cd%TYPE,
90: app_source_id igs_ad_ps_appl_inst_all.app_source_id%TYPE,
83: sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE,
84: predicted_gpa igs_ad_ps_appl_inst_all.predicted_gpa%TYPE,
85: academic_index igs_ad_ps_appl_inst_all.academic_index%TYPE,
86: adm_cal_type igs_ad_ps_appl_inst_all.adm_cal_type%TYPE,
87: app_file_location igs_ad_ps_appl_inst_all.app_file_location%TYPE,
88: adm_ci_sequence_number igs_ad_ps_appl_inst_all.adm_ci_sequence_number%TYPE,
89: course_cd igs_ad_ps_appl_inst_all.course_cd%TYPE,
90: app_source_id igs_ad_ps_appl_inst_all.app_source_id%TYPE,
91: crv_version_number igs_ad_ps_appl_inst_all.crv_version_number%TYPE,
84: predicted_gpa igs_ad_ps_appl_inst_all.predicted_gpa%TYPE,
85: academic_index igs_ad_ps_appl_inst_all.academic_index%TYPE,
86: adm_cal_type igs_ad_ps_appl_inst_all.adm_cal_type%TYPE,
87: app_file_location igs_ad_ps_appl_inst_all.app_file_location%TYPE,
88: adm_ci_sequence_number igs_ad_ps_appl_inst_all.adm_ci_sequence_number%TYPE,
89: course_cd igs_ad_ps_appl_inst_all.course_cd%TYPE,
90: app_source_id igs_ad_ps_appl_inst_all.app_source_id%TYPE,
91: crv_version_number igs_ad_ps_appl_inst_all.crv_version_number%TYPE,
92: waitlist_rank igs_ad_ps_appl_inst_all.waitlist_rank%TYPE,
85: academic_index igs_ad_ps_appl_inst_all.academic_index%TYPE,
86: adm_cal_type igs_ad_ps_appl_inst_all.adm_cal_type%TYPE,
87: app_file_location igs_ad_ps_appl_inst_all.app_file_location%TYPE,
88: adm_ci_sequence_number igs_ad_ps_appl_inst_all.adm_ci_sequence_number%TYPE,
89: course_cd igs_ad_ps_appl_inst_all.course_cd%TYPE,
90: app_source_id igs_ad_ps_appl_inst_all.app_source_id%TYPE,
91: crv_version_number igs_ad_ps_appl_inst_all.crv_version_number%TYPE,
92: waitlist_rank igs_ad_ps_appl_inst_all.waitlist_rank%TYPE,
93: location_cd igs_ad_ps_appl_inst_all.location_cd%TYPE,
86: adm_cal_type igs_ad_ps_appl_inst_all.adm_cal_type%TYPE,
87: app_file_location igs_ad_ps_appl_inst_all.app_file_location%TYPE,
88: adm_ci_sequence_number igs_ad_ps_appl_inst_all.adm_ci_sequence_number%TYPE,
89: course_cd igs_ad_ps_appl_inst_all.course_cd%TYPE,
90: app_source_id igs_ad_ps_appl_inst_all.app_source_id%TYPE,
91: crv_version_number igs_ad_ps_appl_inst_all.crv_version_number%TYPE,
92: waitlist_rank igs_ad_ps_appl_inst_all.waitlist_rank%TYPE,
93: location_cd igs_ad_ps_appl_inst_all.location_cd%TYPE,
94: attent_other_inst_cd igs_ad_ps_appl_inst_all.attent_other_inst_cd%TYPE,
87: app_file_location igs_ad_ps_appl_inst_all.app_file_location%TYPE,
88: adm_ci_sequence_number igs_ad_ps_appl_inst_all.adm_ci_sequence_number%TYPE,
89: course_cd igs_ad_ps_appl_inst_all.course_cd%TYPE,
90: app_source_id igs_ad_ps_appl_inst_all.app_source_id%TYPE,
91: crv_version_number igs_ad_ps_appl_inst_all.crv_version_number%TYPE,
92: waitlist_rank igs_ad_ps_appl_inst_all.waitlist_rank%TYPE,
93: location_cd igs_ad_ps_appl_inst_all.location_cd%TYPE,
94: attent_other_inst_cd igs_ad_ps_appl_inst_all.attent_other_inst_cd%TYPE,
95: attendance_mode igs_ad_ps_appl_inst_all.attendance_mode%TYPE,
88: adm_ci_sequence_number igs_ad_ps_appl_inst_all.adm_ci_sequence_number%TYPE,
89: course_cd igs_ad_ps_appl_inst_all.course_cd%TYPE,
90: app_source_id igs_ad_ps_appl_inst_all.app_source_id%TYPE,
91: crv_version_number igs_ad_ps_appl_inst_all.crv_version_number%TYPE,
92: waitlist_rank igs_ad_ps_appl_inst_all.waitlist_rank%TYPE,
93: location_cd igs_ad_ps_appl_inst_all.location_cd%TYPE,
94: attent_other_inst_cd igs_ad_ps_appl_inst_all.attent_other_inst_cd%TYPE,
95: attendance_mode igs_ad_ps_appl_inst_all.attendance_mode%TYPE,
96: edu_goal_prior_enroll_id igs_ad_ps_appl_inst_all.edu_goal_prior_enroll_id%TYPE,
89: course_cd igs_ad_ps_appl_inst_all.course_cd%TYPE,
90: app_source_id igs_ad_ps_appl_inst_all.app_source_id%TYPE,
91: crv_version_number igs_ad_ps_appl_inst_all.crv_version_number%TYPE,
92: waitlist_rank igs_ad_ps_appl_inst_all.waitlist_rank%TYPE,
93: location_cd igs_ad_ps_appl_inst_all.location_cd%TYPE,
94: attent_other_inst_cd igs_ad_ps_appl_inst_all.attent_other_inst_cd%TYPE,
95: attendance_mode igs_ad_ps_appl_inst_all.attendance_mode%TYPE,
96: edu_goal_prior_enroll_id igs_ad_ps_appl_inst_all.edu_goal_prior_enroll_id%TYPE,
97: attendance_type igs_ad_ps_appl_inst_all.attendance_type%TYPE,
90: app_source_id igs_ad_ps_appl_inst_all.app_source_id%TYPE,
91: crv_version_number igs_ad_ps_appl_inst_all.crv_version_number%TYPE,
92: waitlist_rank igs_ad_ps_appl_inst_all.waitlist_rank%TYPE,
93: location_cd igs_ad_ps_appl_inst_all.location_cd%TYPE,
94: attent_other_inst_cd igs_ad_ps_appl_inst_all.attent_other_inst_cd%TYPE,
95: attendance_mode igs_ad_ps_appl_inst_all.attendance_mode%TYPE,
96: edu_goal_prior_enroll_id igs_ad_ps_appl_inst_all.edu_goal_prior_enroll_id%TYPE,
97: attendance_type igs_ad_ps_appl_inst_all.attendance_type%TYPE,
98: decision_make_id igs_ad_ps_appl_inst_all.decision_make_id%TYPE,
91: crv_version_number igs_ad_ps_appl_inst_all.crv_version_number%TYPE,
92: waitlist_rank igs_ad_ps_appl_inst_all.waitlist_rank%TYPE,
93: location_cd igs_ad_ps_appl_inst_all.location_cd%TYPE,
94: attent_other_inst_cd igs_ad_ps_appl_inst_all.attent_other_inst_cd%TYPE,
95: attendance_mode igs_ad_ps_appl_inst_all.attendance_mode%TYPE,
96: edu_goal_prior_enroll_id igs_ad_ps_appl_inst_all.edu_goal_prior_enroll_id%TYPE,
97: attendance_type igs_ad_ps_appl_inst_all.attendance_type%TYPE,
98: decision_make_id igs_ad_ps_appl_inst_all.decision_make_id%TYPE,
99: unit_set_cd igs_ad_ps_appl_inst_all.unit_set_cd%TYPE,
92: waitlist_rank igs_ad_ps_appl_inst_all.waitlist_rank%TYPE,
93: location_cd igs_ad_ps_appl_inst_all.location_cd%TYPE,
94: attent_other_inst_cd igs_ad_ps_appl_inst_all.attent_other_inst_cd%TYPE,
95: attendance_mode igs_ad_ps_appl_inst_all.attendance_mode%TYPE,
96: edu_goal_prior_enroll_id igs_ad_ps_appl_inst_all.edu_goal_prior_enroll_id%TYPE,
97: attendance_type igs_ad_ps_appl_inst_all.attendance_type%TYPE,
98: decision_make_id igs_ad_ps_appl_inst_all.decision_make_id%TYPE,
99: unit_set_cd igs_ad_ps_appl_inst_all.unit_set_cd%TYPE,
100: decision_date igs_ad_ps_appl_inst_all.decision_date%TYPE,
93: location_cd igs_ad_ps_appl_inst_all.location_cd%TYPE,
94: attent_other_inst_cd igs_ad_ps_appl_inst_all.attent_other_inst_cd%TYPE,
95: attendance_mode igs_ad_ps_appl_inst_all.attendance_mode%TYPE,
96: edu_goal_prior_enroll_id igs_ad_ps_appl_inst_all.edu_goal_prior_enroll_id%TYPE,
97: attendance_type igs_ad_ps_appl_inst_all.attendance_type%TYPE,
98: decision_make_id igs_ad_ps_appl_inst_all.decision_make_id%TYPE,
99: unit_set_cd igs_ad_ps_appl_inst_all.unit_set_cd%TYPE,
100: decision_date igs_ad_ps_appl_inst_all.decision_date%TYPE,
101: attribute_category igs_ad_ps_appl_inst_all.attribute_category%TYPE,
94: attent_other_inst_cd igs_ad_ps_appl_inst_all.attent_other_inst_cd%TYPE,
95: attendance_mode igs_ad_ps_appl_inst_all.attendance_mode%TYPE,
96: edu_goal_prior_enroll_id igs_ad_ps_appl_inst_all.edu_goal_prior_enroll_id%TYPE,
97: attendance_type igs_ad_ps_appl_inst_all.attendance_type%TYPE,
98: decision_make_id igs_ad_ps_appl_inst_all.decision_make_id%TYPE,
99: unit_set_cd igs_ad_ps_appl_inst_all.unit_set_cd%TYPE,
100: decision_date igs_ad_ps_appl_inst_all.decision_date%TYPE,
101: attribute_category igs_ad_ps_appl_inst_all.attribute_category%TYPE,
102: attribute1 igs_ad_ps_appl_inst_all.attribute1%TYPE,
95: attendance_mode igs_ad_ps_appl_inst_all.attendance_mode%TYPE,
96: edu_goal_prior_enroll_id igs_ad_ps_appl_inst_all.edu_goal_prior_enroll_id%TYPE,
97: attendance_type igs_ad_ps_appl_inst_all.attendance_type%TYPE,
98: decision_make_id igs_ad_ps_appl_inst_all.decision_make_id%TYPE,
99: unit_set_cd igs_ad_ps_appl_inst_all.unit_set_cd%TYPE,
100: decision_date igs_ad_ps_appl_inst_all.decision_date%TYPE,
101: attribute_category igs_ad_ps_appl_inst_all.attribute_category%TYPE,
102: attribute1 igs_ad_ps_appl_inst_all.attribute1%TYPE,
103: attribute2 igs_ad_ps_appl_inst_all.attribute2%TYPE,
96: edu_goal_prior_enroll_id igs_ad_ps_appl_inst_all.edu_goal_prior_enroll_id%TYPE,
97: attendance_type igs_ad_ps_appl_inst_all.attendance_type%TYPE,
98: decision_make_id igs_ad_ps_appl_inst_all.decision_make_id%TYPE,
99: unit_set_cd igs_ad_ps_appl_inst_all.unit_set_cd%TYPE,
100: decision_date igs_ad_ps_appl_inst_all.decision_date%TYPE,
101: attribute_category igs_ad_ps_appl_inst_all.attribute_category%TYPE,
102: attribute1 igs_ad_ps_appl_inst_all.attribute1%TYPE,
103: attribute2 igs_ad_ps_appl_inst_all.attribute2%TYPE,
104: attribute3 igs_ad_ps_appl_inst_all.attribute3%TYPE,
97: attendance_type igs_ad_ps_appl_inst_all.attendance_type%TYPE,
98: decision_make_id igs_ad_ps_appl_inst_all.decision_make_id%TYPE,
99: unit_set_cd igs_ad_ps_appl_inst_all.unit_set_cd%TYPE,
100: decision_date igs_ad_ps_appl_inst_all.decision_date%TYPE,
101: attribute_category igs_ad_ps_appl_inst_all.attribute_category%TYPE,
102: attribute1 igs_ad_ps_appl_inst_all.attribute1%TYPE,
103: attribute2 igs_ad_ps_appl_inst_all.attribute2%TYPE,
104: attribute3 igs_ad_ps_appl_inst_all.attribute3%TYPE,
105: attribute4 igs_ad_ps_appl_inst_all.attribute4%TYPE,
98: decision_make_id igs_ad_ps_appl_inst_all.decision_make_id%TYPE,
99: unit_set_cd igs_ad_ps_appl_inst_all.unit_set_cd%TYPE,
100: decision_date igs_ad_ps_appl_inst_all.decision_date%TYPE,
101: attribute_category igs_ad_ps_appl_inst_all.attribute_category%TYPE,
102: attribute1 igs_ad_ps_appl_inst_all.attribute1%TYPE,
103: attribute2 igs_ad_ps_appl_inst_all.attribute2%TYPE,
104: attribute3 igs_ad_ps_appl_inst_all.attribute3%TYPE,
105: attribute4 igs_ad_ps_appl_inst_all.attribute4%TYPE,
106: attribute5 igs_ad_ps_appl_inst_all.attribute5%TYPE,
99: unit_set_cd igs_ad_ps_appl_inst_all.unit_set_cd%TYPE,
100: decision_date igs_ad_ps_appl_inst_all.decision_date%TYPE,
101: attribute_category igs_ad_ps_appl_inst_all.attribute_category%TYPE,
102: attribute1 igs_ad_ps_appl_inst_all.attribute1%TYPE,
103: attribute2 igs_ad_ps_appl_inst_all.attribute2%TYPE,
104: attribute3 igs_ad_ps_appl_inst_all.attribute3%TYPE,
105: attribute4 igs_ad_ps_appl_inst_all.attribute4%TYPE,
106: attribute5 igs_ad_ps_appl_inst_all.attribute5%TYPE,
107: attribute6 igs_ad_ps_appl_inst_all.attribute6%TYPE,
100: decision_date igs_ad_ps_appl_inst_all.decision_date%TYPE,
101: attribute_category igs_ad_ps_appl_inst_all.attribute_category%TYPE,
102: attribute1 igs_ad_ps_appl_inst_all.attribute1%TYPE,
103: attribute2 igs_ad_ps_appl_inst_all.attribute2%TYPE,
104: attribute3 igs_ad_ps_appl_inst_all.attribute3%TYPE,
105: attribute4 igs_ad_ps_appl_inst_all.attribute4%TYPE,
106: attribute5 igs_ad_ps_appl_inst_all.attribute5%TYPE,
107: attribute6 igs_ad_ps_appl_inst_all.attribute6%TYPE,
108: attribute7 igs_ad_ps_appl_inst_all.attribute7%TYPE,
101: attribute_category igs_ad_ps_appl_inst_all.attribute_category%TYPE,
102: attribute1 igs_ad_ps_appl_inst_all.attribute1%TYPE,
103: attribute2 igs_ad_ps_appl_inst_all.attribute2%TYPE,
104: attribute3 igs_ad_ps_appl_inst_all.attribute3%TYPE,
105: attribute4 igs_ad_ps_appl_inst_all.attribute4%TYPE,
106: attribute5 igs_ad_ps_appl_inst_all.attribute5%TYPE,
107: attribute6 igs_ad_ps_appl_inst_all.attribute6%TYPE,
108: attribute7 igs_ad_ps_appl_inst_all.attribute7%TYPE,
109: attribute8 igs_ad_ps_appl_inst_all.attribute8%TYPE,
102: attribute1 igs_ad_ps_appl_inst_all.attribute1%TYPE,
103: attribute2 igs_ad_ps_appl_inst_all.attribute2%TYPE,
104: attribute3 igs_ad_ps_appl_inst_all.attribute3%TYPE,
105: attribute4 igs_ad_ps_appl_inst_all.attribute4%TYPE,
106: attribute5 igs_ad_ps_appl_inst_all.attribute5%TYPE,
107: attribute6 igs_ad_ps_appl_inst_all.attribute6%TYPE,
108: attribute7 igs_ad_ps_appl_inst_all.attribute7%TYPE,
109: attribute8 igs_ad_ps_appl_inst_all.attribute8%TYPE,
110: attribute9 igs_ad_ps_appl_inst_all.attribute9%TYPE,
103: attribute2 igs_ad_ps_appl_inst_all.attribute2%TYPE,
104: attribute3 igs_ad_ps_appl_inst_all.attribute3%TYPE,
105: attribute4 igs_ad_ps_appl_inst_all.attribute4%TYPE,
106: attribute5 igs_ad_ps_appl_inst_all.attribute5%TYPE,
107: attribute6 igs_ad_ps_appl_inst_all.attribute6%TYPE,
108: attribute7 igs_ad_ps_appl_inst_all.attribute7%TYPE,
109: attribute8 igs_ad_ps_appl_inst_all.attribute8%TYPE,
110: attribute9 igs_ad_ps_appl_inst_all.attribute9%TYPE,
111: attribute10 igs_ad_ps_appl_inst_all.attribute10%TYPE,
104: attribute3 igs_ad_ps_appl_inst_all.attribute3%TYPE,
105: attribute4 igs_ad_ps_appl_inst_all.attribute4%TYPE,
106: attribute5 igs_ad_ps_appl_inst_all.attribute5%TYPE,
107: attribute6 igs_ad_ps_appl_inst_all.attribute6%TYPE,
108: attribute7 igs_ad_ps_appl_inst_all.attribute7%TYPE,
109: attribute8 igs_ad_ps_appl_inst_all.attribute8%TYPE,
110: attribute9 igs_ad_ps_appl_inst_all.attribute9%TYPE,
111: attribute10 igs_ad_ps_appl_inst_all.attribute10%TYPE,
112: attribute11 igs_ad_ps_appl_inst_all.attribute11%TYPE,
105: attribute4 igs_ad_ps_appl_inst_all.attribute4%TYPE,
106: attribute5 igs_ad_ps_appl_inst_all.attribute5%TYPE,
107: attribute6 igs_ad_ps_appl_inst_all.attribute6%TYPE,
108: attribute7 igs_ad_ps_appl_inst_all.attribute7%TYPE,
109: attribute8 igs_ad_ps_appl_inst_all.attribute8%TYPE,
110: attribute9 igs_ad_ps_appl_inst_all.attribute9%TYPE,
111: attribute10 igs_ad_ps_appl_inst_all.attribute10%TYPE,
112: attribute11 igs_ad_ps_appl_inst_all.attribute11%TYPE,
113: attribute12 igs_ad_ps_appl_inst_all.attribute12%TYPE,
106: attribute5 igs_ad_ps_appl_inst_all.attribute5%TYPE,
107: attribute6 igs_ad_ps_appl_inst_all.attribute6%TYPE,
108: attribute7 igs_ad_ps_appl_inst_all.attribute7%TYPE,
109: attribute8 igs_ad_ps_appl_inst_all.attribute8%TYPE,
110: attribute9 igs_ad_ps_appl_inst_all.attribute9%TYPE,
111: attribute10 igs_ad_ps_appl_inst_all.attribute10%TYPE,
112: attribute11 igs_ad_ps_appl_inst_all.attribute11%TYPE,
113: attribute12 igs_ad_ps_appl_inst_all.attribute12%TYPE,
114: attribute13 igs_ad_ps_appl_inst_all.attribute13%TYPE,
107: attribute6 igs_ad_ps_appl_inst_all.attribute6%TYPE,
108: attribute7 igs_ad_ps_appl_inst_all.attribute7%TYPE,
109: attribute8 igs_ad_ps_appl_inst_all.attribute8%TYPE,
110: attribute9 igs_ad_ps_appl_inst_all.attribute9%TYPE,
111: attribute10 igs_ad_ps_appl_inst_all.attribute10%TYPE,
112: attribute11 igs_ad_ps_appl_inst_all.attribute11%TYPE,
113: attribute12 igs_ad_ps_appl_inst_all.attribute12%TYPE,
114: attribute13 igs_ad_ps_appl_inst_all.attribute13%TYPE,
115: attribute14 igs_ad_ps_appl_inst_all.attribute14%TYPE,
108: attribute7 igs_ad_ps_appl_inst_all.attribute7%TYPE,
109: attribute8 igs_ad_ps_appl_inst_all.attribute8%TYPE,
110: attribute9 igs_ad_ps_appl_inst_all.attribute9%TYPE,
111: attribute10 igs_ad_ps_appl_inst_all.attribute10%TYPE,
112: attribute11 igs_ad_ps_appl_inst_all.attribute11%TYPE,
113: attribute12 igs_ad_ps_appl_inst_all.attribute12%TYPE,
114: attribute13 igs_ad_ps_appl_inst_all.attribute13%TYPE,
115: attribute14 igs_ad_ps_appl_inst_all.attribute14%TYPE,
116: attribute15 igs_ad_ps_appl_inst_all.attribute15%TYPE,
109: attribute8 igs_ad_ps_appl_inst_all.attribute8%TYPE,
110: attribute9 igs_ad_ps_appl_inst_all.attribute9%TYPE,
111: attribute10 igs_ad_ps_appl_inst_all.attribute10%TYPE,
112: attribute11 igs_ad_ps_appl_inst_all.attribute11%TYPE,
113: attribute12 igs_ad_ps_appl_inst_all.attribute12%TYPE,
114: attribute13 igs_ad_ps_appl_inst_all.attribute13%TYPE,
115: attribute14 igs_ad_ps_appl_inst_all.attribute14%TYPE,
116: attribute15 igs_ad_ps_appl_inst_all.attribute15%TYPE,
117: attribute16 igs_ad_ps_appl_inst_all.attribute16%TYPE,
110: attribute9 igs_ad_ps_appl_inst_all.attribute9%TYPE,
111: attribute10 igs_ad_ps_appl_inst_all.attribute10%TYPE,
112: attribute11 igs_ad_ps_appl_inst_all.attribute11%TYPE,
113: attribute12 igs_ad_ps_appl_inst_all.attribute12%TYPE,
114: attribute13 igs_ad_ps_appl_inst_all.attribute13%TYPE,
115: attribute14 igs_ad_ps_appl_inst_all.attribute14%TYPE,
116: attribute15 igs_ad_ps_appl_inst_all.attribute15%TYPE,
117: attribute16 igs_ad_ps_appl_inst_all.attribute16%TYPE,
118: attribute17 igs_ad_ps_appl_inst_all.attribute17%TYPE,
111: attribute10 igs_ad_ps_appl_inst_all.attribute10%TYPE,
112: attribute11 igs_ad_ps_appl_inst_all.attribute11%TYPE,
113: attribute12 igs_ad_ps_appl_inst_all.attribute12%TYPE,
114: attribute13 igs_ad_ps_appl_inst_all.attribute13%TYPE,
115: attribute14 igs_ad_ps_appl_inst_all.attribute14%TYPE,
116: attribute15 igs_ad_ps_appl_inst_all.attribute15%TYPE,
117: attribute16 igs_ad_ps_appl_inst_all.attribute16%TYPE,
118: attribute17 igs_ad_ps_appl_inst_all.attribute17%TYPE,
119: attribute18 igs_ad_ps_appl_inst_all.attribute18%TYPE,
112: attribute11 igs_ad_ps_appl_inst_all.attribute11%TYPE,
113: attribute12 igs_ad_ps_appl_inst_all.attribute12%TYPE,
114: attribute13 igs_ad_ps_appl_inst_all.attribute13%TYPE,
115: attribute14 igs_ad_ps_appl_inst_all.attribute14%TYPE,
116: attribute15 igs_ad_ps_appl_inst_all.attribute15%TYPE,
117: attribute16 igs_ad_ps_appl_inst_all.attribute16%TYPE,
118: attribute17 igs_ad_ps_appl_inst_all.attribute17%TYPE,
119: attribute18 igs_ad_ps_appl_inst_all.attribute18%TYPE,
120: attribute19 igs_ad_ps_appl_inst_all.attribute19%TYPE,
113: attribute12 igs_ad_ps_appl_inst_all.attribute12%TYPE,
114: attribute13 igs_ad_ps_appl_inst_all.attribute13%TYPE,
115: attribute14 igs_ad_ps_appl_inst_all.attribute14%TYPE,
116: attribute15 igs_ad_ps_appl_inst_all.attribute15%TYPE,
117: attribute16 igs_ad_ps_appl_inst_all.attribute16%TYPE,
118: attribute17 igs_ad_ps_appl_inst_all.attribute17%TYPE,
119: attribute18 igs_ad_ps_appl_inst_all.attribute18%TYPE,
120: attribute19 igs_ad_ps_appl_inst_all.attribute19%TYPE,
121: attribute20 igs_ad_ps_appl_inst_all.attribute20%TYPE,
114: attribute13 igs_ad_ps_appl_inst_all.attribute13%TYPE,
115: attribute14 igs_ad_ps_appl_inst_all.attribute14%TYPE,
116: attribute15 igs_ad_ps_appl_inst_all.attribute15%TYPE,
117: attribute16 igs_ad_ps_appl_inst_all.attribute16%TYPE,
118: attribute17 igs_ad_ps_appl_inst_all.attribute17%TYPE,
119: attribute18 igs_ad_ps_appl_inst_all.attribute18%TYPE,
120: attribute19 igs_ad_ps_appl_inst_all.attribute19%TYPE,
121: attribute20 igs_ad_ps_appl_inst_all.attribute20%TYPE,
122: decision_reason_id igs_ad_ps_appl_inst_all.decision_reason_id%TYPE,
115: attribute14 igs_ad_ps_appl_inst_all.attribute14%TYPE,
116: attribute15 igs_ad_ps_appl_inst_all.attribute15%TYPE,
117: attribute16 igs_ad_ps_appl_inst_all.attribute16%TYPE,
118: attribute17 igs_ad_ps_appl_inst_all.attribute17%TYPE,
119: attribute18 igs_ad_ps_appl_inst_all.attribute18%TYPE,
120: attribute19 igs_ad_ps_appl_inst_all.attribute19%TYPE,
121: attribute20 igs_ad_ps_appl_inst_all.attribute20%TYPE,
122: decision_reason_id igs_ad_ps_appl_inst_all.decision_reason_id%TYPE,
123: us_version_number igs_ad_ps_appl_inst_all.us_version_number%TYPE,
116: attribute15 igs_ad_ps_appl_inst_all.attribute15%TYPE,
117: attribute16 igs_ad_ps_appl_inst_all.attribute16%TYPE,
118: attribute17 igs_ad_ps_appl_inst_all.attribute17%TYPE,
119: attribute18 igs_ad_ps_appl_inst_all.attribute18%TYPE,
120: attribute19 igs_ad_ps_appl_inst_all.attribute19%TYPE,
121: attribute20 igs_ad_ps_appl_inst_all.attribute20%TYPE,
122: decision_reason_id igs_ad_ps_appl_inst_all.decision_reason_id%TYPE,
123: us_version_number igs_ad_ps_appl_inst_all.us_version_number%TYPE,
124: decision_notes igs_ad_ps_appl_inst_all.decision_notes%TYPE,
117: attribute16 igs_ad_ps_appl_inst_all.attribute16%TYPE,
118: attribute17 igs_ad_ps_appl_inst_all.attribute17%TYPE,
119: attribute18 igs_ad_ps_appl_inst_all.attribute18%TYPE,
120: attribute19 igs_ad_ps_appl_inst_all.attribute19%TYPE,
121: attribute20 igs_ad_ps_appl_inst_all.attribute20%TYPE,
122: decision_reason_id igs_ad_ps_appl_inst_all.decision_reason_id%TYPE,
123: us_version_number igs_ad_ps_appl_inst_all.us_version_number%TYPE,
124: decision_notes igs_ad_ps_appl_inst_all.decision_notes%TYPE,
125: pending_reason_id igs_ad_ps_appl_inst_all.pending_reason_id%TYPE,
118: attribute17 igs_ad_ps_appl_inst_all.attribute17%TYPE,
119: attribute18 igs_ad_ps_appl_inst_all.attribute18%TYPE,
120: attribute19 igs_ad_ps_appl_inst_all.attribute19%TYPE,
121: attribute20 igs_ad_ps_appl_inst_all.attribute20%TYPE,
122: decision_reason_id igs_ad_ps_appl_inst_all.decision_reason_id%TYPE,
123: us_version_number igs_ad_ps_appl_inst_all.us_version_number%TYPE,
124: decision_notes igs_ad_ps_appl_inst_all.decision_notes%TYPE,
125: pending_reason_id igs_ad_ps_appl_inst_all.pending_reason_id%TYPE,
126: preference_number igs_ad_ps_appl_inst_all.preference_number%TYPE,
119: attribute18 igs_ad_ps_appl_inst_all.attribute18%TYPE,
120: attribute19 igs_ad_ps_appl_inst_all.attribute19%TYPE,
121: attribute20 igs_ad_ps_appl_inst_all.attribute20%TYPE,
122: decision_reason_id igs_ad_ps_appl_inst_all.decision_reason_id%TYPE,
123: us_version_number igs_ad_ps_appl_inst_all.us_version_number%TYPE,
124: decision_notes igs_ad_ps_appl_inst_all.decision_notes%TYPE,
125: pending_reason_id igs_ad_ps_appl_inst_all.pending_reason_id%TYPE,
126: preference_number igs_ad_ps_appl_inst_all.preference_number%TYPE,
127: adm_doc_status igs_ad_ps_appl_inst_all.adm_doc_status%TYPE,
120: attribute19 igs_ad_ps_appl_inst_all.attribute19%TYPE,
121: attribute20 igs_ad_ps_appl_inst_all.attribute20%TYPE,
122: decision_reason_id igs_ad_ps_appl_inst_all.decision_reason_id%TYPE,
123: us_version_number igs_ad_ps_appl_inst_all.us_version_number%TYPE,
124: decision_notes igs_ad_ps_appl_inst_all.decision_notes%TYPE,
125: pending_reason_id igs_ad_ps_appl_inst_all.pending_reason_id%TYPE,
126: preference_number igs_ad_ps_appl_inst_all.preference_number%TYPE,
127: adm_doc_status igs_ad_ps_appl_inst_all.adm_doc_status%TYPE,
128: adm_entry_qual_status igs_ad_ps_appl_inst_all.adm_entry_qual_status%TYPE,
121: attribute20 igs_ad_ps_appl_inst_all.attribute20%TYPE,
122: decision_reason_id igs_ad_ps_appl_inst_all.decision_reason_id%TYPE,
123: us_version_number igs_ad_ps_appl_inst_all.us_version_number%TYPE,
124: decision_notes igs_ad_ps_appl_inst_all.decision_notes%TYPE,
125: pending_reason_id igs_ad_ps_appl_inst_all.pending_reason_id%TYPE,
126: preference_number igs_ad_ps_appl_inst_all.preference_number%TYPE,
127: adm_doc_status igs_ad_ps_appl_inst_all.adm_doc_status%TYPE,
128: adm_entry_qual_status igs_ad_ps_appl_inst_all.adm_entry_qual_status%TYPE,
129: deficiency_in_prep igs_ad_ps_appl_inst_all.deficiency_in_prep%TYPE,
122: decision_reason_id igs_ad_ps_appl_inst_all.decision_reason_id%TYPE,
123: us_version_number igs_ad_ps_appl_inst_all.us_version_number%TYPE,
124: decision_notes igs_ad_ps_appl_inst_all.decision_notes%TYPE,
125: pending_reason_id igs_ad_ps_appl_inst_all.pending_reason_id%TYPE,
126: preference_number igs_ad_ps_appl_inst_all.preference_number%TYPE,
127: adm_doc_status igs_ad_ps_appl_inst_all.adm_doc_status%TYPE,
128: adm_entry_qual_status igs_ad_ps_appl_inst_all.adm_entry_qual_status%TYPE,
129: deficiency_in_prep igs_ad_ps_appl_inst_all.deficiency_in_prep%TYPE,
130: late_adm_fee_status igs_ad_ps_appl_inst_all.late_adm_fee_status%TYPE,
123: us_version_number igs_ad_ps_appl_inst_all.us_version_number%TYPE,
124: decision_notes igs_ad_ps_appl_inst_all.decision_notes%TYPE,
125: pending_reason_id igs_ad_ps_appl_inst_all.pending_reason_id%TYPE,
126: preference_number igs_ad_ps_appl_inst_all.preference_number%TYPE,
127: adm_doc_status igs_ad_ps_appl_inst_all.adm_doc_status%TYPE,
128: adm_entry_qual_status igs_ad_ps_appl_inst_all.adm_entry_qual_status%TYPE,
129: deficiency_in_prep igs_ad_ps_appl_inst_all.deficiency_in_prep%TYPE,
130: late_adm_fee_status igs_ad_ps_appl_inst_all.late_adm_fee_status%TYPE,
131: spl_consider_comments igs_ad_ps_appl_inst_all.spl_consider_comments%TYPE,
124: decision_notes igs_ad_ps_appl_inst_all.decision_notes%TYPE,
125: pending_reason_id igs_ad_ps_appl_inst_all.pending_reason_id%TYPE,
126: preference_number igs_ad_ps_appl_inst_all.preference_number%TYPE,
127: adm_doc_status igs_ad_ps_appl_inst_all.adm_doc_status%TYPE,
128: adm_entry_qual_status igs_ad_ps_appl_inst_all.adm_entry_qual_status%TYPE,
129: deficiency_in_prep igs_ad_ps_appl_inst_all.deficiency_in_prep%TYPE,
130: late_adm_fee_status igs_ad_ps_appl_inst_all.late_adm_fee_status%TYPE,
131: spl_consider_comments igs_ad_ps_appl_inst_all.spl_consider_comments%TYPE,
132: apply_for_finaid igs_ad_ps_appl_inst_all.apply_for_finaid%TYPE,
125: pending_reason_id igs_ad_ps_appl_inst_all.pending_reason_id%TYPE,
126: preference_number igs_ad_ps_appl_inst_all.preference_number%TYPE,
127: adm_doc_status igs_ad_ps_appl_inst_all.adm_doc_status%TYPE,
128: adm_entry_qual_status igs_ad_ps_appl_inst_all.adm_entry_qual_status%TYPE,
129: deficiency_in_prep igs_ad_ps_appl_inst_all.deficiency_in_prep%TYPE,
130: late_adm_fee_status igs_ad_ps_appl_inst_all.late_adm_fee_status%TYPE,
131: spl_consider_comments igs_ad_ps_appl_inst_all.spl_consider_comments%TYPE,
132: apply_for_finaid igs_ad_ps_appl_inst_all.apply_for_finaid%TYPE,
133: finaid_apply_date igs_ad_ps_appl_inst_all.finaid_apply_date%TYPE,
126: preference_number igs_ad_ps_appl_inst_all.preference_number%TYPE,
127: adm_doc_status igs_ad_ps_appl_inst_all.adm_doc_status%TYPE,
128: adm_entry_qual_status igs_ad_ps_appl_inst_all.adm_entry_qual_status%TYPE,
129: deficiency_in_prep igs_ad_ps_appl_inst_all.deficiency_in_prep%TYPE,
130: late_adm_fee_status igs_ad_ps_appl_inst_all.late_adm_fee_status%TYPE,
131: spl_consider_comments igs_ad_ps_appl_inst_all.spl_consider_comments%TYPE,
132: apply_for_finaid igs_ad_ps_appl_inst_all.apply_for_finaid%TYPE,
133: finaid_apply_date igs_ad_ps_appl_inst_all.finaid_apply_date%TYPE,
134: adm_outcome_status igs_ad_ps_appl_inst_all.adm_outcome_status%TYPE,
127: adm_doc_status igs_ad_ps_appl_inst_all.adm_doc_status%TYPE,
128: adm_entry_qual_status igs_ad_ps_appl_inst_all.adm_entry_qual_status%TYPE,
129: deficiency_in_prep igs_ad_ps_appl_inst_all.deficiency_in_prep%TYPE,
130: late_adm_fee_status igs_ad_ps_appl_inst_all.late_adm_fee_status%TYPE,
131: spl_consider_comments igs_ad_ps_appl_inst_all.spl_consider_comments%TYPE,
132: apply_for_finaid igs_ad_ps_appl_inst_all.apply_for_finaid%TYPE,
133: finaid_apply_date igs_ad_ps_appl_inst_all.finaid_apply_date%TYPE,
134: adm_outcome_status igs_ad_ps_appl_inst_all.adm_outcome_status%TYPE,
135: adm_otcm_status_auth_person_id igs_ad_ps_appl_inst_all.ADM_OTCM_STATUS_AUTH_PERSON_ID%TYPE,
128: adm_entry_qual_status igs_ad_ps_appl_inst_all.adm_entry_qual_status%TYPE,
129: deficiency_in_prep igs_ad_ps_appl_inst_all.deficiency_in_prep%TYPE,
130: late_adm_fee_status igs_ad_ps_appl_inst_all.late_adm_fee_status%TYPE,
131: spl_consider_comments igs_ad_ps_appl_inst_all.spl_consider_comments%TYPE,
132: apply_for_finaid igs_ad_ps_appl_inst_all.apply_for_finaid%TYPE,
133: finaid_apply_date igs_ad_ps_appl_inst_all.finaid_apply_date%TYPE,
134: adm_outcome_status igs_ad_ps_appl_inst_all.adm_outcome_status%TYPE,
135: adm_otcm_status_auth_person_id igs_ad_ps_appl_inst_all.ADM_OTCM_STATUS_AUTH_PERSON_ID%TYPE,
136: adm_outcome_status_auth_dt igs_ad_ps_appl_inst_all.adm_outcome_status_auth_dt%TYPE,
129: deficiency_in_prep igs_ad_ps_appl_inst_all.deficiency_in_prep%TYPE,
130: late_adm_fee_status igs_ad_ps_appl_inst_all.late_adm_fee_status%TYPE,
131: spl_consider_comments igs_ad_ps_appl_inst_all.spl_consider_comments%TYPE,
132: apply_for_finaid igs_ad_ps_appl_inst_all.apply_for_finaid%TYPE,
133: finaid_apply_date igs_ad_ps_appl_inst_all.finaid_apply_date%TYPE,
134: adm_outcome_status igs_ad_ps_appl_inst_all.adm_outcome_status%TYPE,
135: adm_otcm_status_auth_person_id igs_ad_ps_appl_inst_all.ADM_OTCM_STATUS_AUTH_PERSON_ID%TYPE,
136: adm_outcome_status_auth_dt igs_ad_ps_appl_inst_all.adm_outcome_status_auth_dt%TYPE,
137: adm_outcome_status_reason igs_ad_ps_appl_inst_all.adm_outcome_status_reason%TYPE,
130: late_adm_fee_status igs_ad_ps_appl_inst_all.late_adm_fee_status%TYPE,
131: spl_consider_comments igs_ad_ps_appl_inst_all.spl_consider_comments%TYPE,
132: apply_for_finaid igs_ad_ps_appl_inst_all.apply_for_finaid%TYPE,
133: finaid_apply_date igs_ad_ps_appl_inst_all.finaid_apply_date%TYPE,
134: adm_outcome_status igs_ad_ps_appl_inst_all.adm_outcome_status%TYPE,
135: adm_otcm_status_auth_person_id igs_ad_ps_appl_inst_all.ADM_OTCM_STATUS_AUTH_PERSON_ID%TYPE,
136: adm_outcome_status_auth_dt igs_ad_ps_appl_inst_all.adm_outcome_status_auth_dt%TYPE,
137: adm_outcome_status_reason igs_ad_ps_appl_inst_all.adm_outcome_status_reason%TYPE,
138: offer_dt igs_ad_ps_appl_inst_all.offer_dt%TYPE,
131: spl_consider_comments igs_ad_ps_appl_inst_all.spl_consider_comments%TYPE,
132: apply_for_finaid igs_ad_ps_appl_inst_all.apply_for_finaid%TYPE,
133: finaid_apply_date igs_ad_ps_appl_inst_all.finaid_apply_date%TYPE,
134: adm_outcome_status igs_ad_ps_appl_inst_all.adm_outcome_status%TYPE,
135: adm_otcm_status_auth_person_id igs_ad_ps_appl_inst_all.ADM_OTCM_STATUS_AUTH_PERSON_ID%TYPE,
136: adm_outcome_status_auth_dt igs_ad_ps_appl_inst_all.adm_outcome_status_auth_dt%TYPE,
137: adm_outcome_status_reason igs_ad_ps_appl_inst_all.adm_outcome_status_reason%TYPE,
138: offer_dt igs_ad_ps_appl_inst_all.offer_dt%TYPE,
139: offer_response_dt igs_ad_ps_appl_inst_all.offer_response_dt%TYPE,
132: apply_for_finaid igs_ad_ps_appl_inst_all.apply_for_finaid%TYPE,
133: finaid_apply_date igs_ad_ps_appl_inst_all.finaid_apply_date%TYPE,
134: adm_outcome_status igs_ad_ps_appl_inst_all.adm_outcome_status%TYPE,
135: adm_otcm_status_auth_person_id igs_ad_ps_appl_inst_all.ADM_OTCM_STATUS_AUTH_PERSON_ID%TYPE,
136: adm_outcome_status_auth_dt igs_ad_ps_appl_inst_all.adm_outcome_status_auth_dt%TYPE,
137: adm_outcome_status_reason igs_ad_ps_appl_inst_all.adm_outcome_status_reason%TYPE,
138: offer_dt igs_ad_ps_appl_inst_all.offer_dt%TYPE,
139: offer_response_dt igs_ad_ps_appl_inst_all.offer_response_dt%TYPE,
140: prpsd_commencement_dt igs_ad_ps_appl_inst_all.prpsd_commencement_dt%TYPE,
133: finaid_apply_date igs_ad_ps_appl_inst_all.finaid_apply_date%TYPE,
134: adm_outcome_status igs_ad_ps_appl_inst_all.adm_outcome_status%TYPE,
135: adm_otcm_status_auth_person_id igs_ad_ps_appl_inst_all.ADM_OTCM_STATUS_AUTH_PERSON_ID%TYPE,
136: adm_outcome_status_auth_dt igs_ad_ps_appl_inst_all.adm_outcome_status_auth_dt%TYPE,
137: adm_outcome_status_reason igs_ad_ps_appl_inst_all.adm_outcome_status_reason%TYPE,
138: offer_dt igs_ad_ps_appl_inst_all.offer_dt%TYPE,
139: offer_response_dt igs_ad_ps_appl_inst_all.offer_response_dt%TYPE,
140: prpsd_commencement_dt igs_ad_ps_appl_inst_all.prpsd_commencement_dt%TYPE,
141: adm_cndtnl_offer_status igs_ad_ps_appl_inst_all.adm_cndtnl_offer_status%TYPE,
134: adm_outcome_status igs_ad_ps_appl_inst_all.adm_outcome_status%TYPE,
135: adm_otcm_status_auth_person_id igs_ad_ps_appl_inst_all.ADM_OTCM_STATUS_AUTH_PERSON_ID%TYPE,
136: adm_outcome_status_auth_dt igs_ad_ps_appl_inst_all.adm_outcome_status_auth_dt%TYPE,
137: adm_outcome_status_reason igs_ad_ps_appl_inst_all.adm_outcome_status_reason%TYPE,
138: offer_dt igs_ad_ps_appl_inst_all.offer_dt%TYPE,
139: offer_response_dt igs_ad_ps_appl_inst_all.offer_response_dt%TYPE,
140: prpsd_commencement_dt igs_ad_ps_appl_inst_all.prpsd_commencement_dt%TYPE,
141: adm_cndtnl_offer_status igs_ad_ps_appl_inst_all.adm_cndtnl_offer_status%TYPE,
142: cndtnl_offer_satisfied_dt igs_ad_ps_appl_inst_all.cndtnl_offer_satisfied_dt%TYPE,
135: adm_otcm_status_auth_person_id igs_ad_ps_appl_inst_all.ADM_OTCM_STATUS_AUTH_PERSON_ID%TYPE,
136: adm_outcome_status_auth_dt igs_ad_ps_appl_inst_all.adm_outcome_status_auth_dt%TYPE,
137: adm_outcome_status_reason igs_ad_ps_appl_inst_all.adm_outcome_status_reason%TYPE,
138: offer_dt igs_ad_ps_appl_inst_all.offer_dt%TYPE,
139: offer_response_dt igs_ad_ps_appl_inst_all.offer_response_dt%TYPE,
140: prpsd_commencement_dt igs_ad_ps_appl_inst_all.prpsd_commencement_dt%TYPE,
141: adm_cndtnl_offer_status igs_ad_ps_appl_inst_all.adm_cndtnl_offer_status%TYPE,
142: cndtnl_offer_satisfied_dt igs_ad_ps_appl_inst_all.cndtnl_offer_satisfied_dt%TYPE,
143: cndtnl_offer_must_be_stsfd_ind igs_ad_ps_appl_inst_all.CNDTNL_OFFER_MUST_BE_STSFD_IND%TYPE,
136: adm_outcome_status_auth_dt igs_ad_ps_appl_inst_all.adm_outcome_status_auth_dt%TYPE,
137: adm_outcome_status_reason igs_ad_ps_appl_inst_all.adm_outcome_status_reason%TYPE,
138: offer_dt igs_ad_ps_appl_inst_all.offer_dt%TYPE,
139: offer_response_dt igs_ad_ps_appl_inst_all.offer_response_dt%TYPE,
140: prpsd_commencement_dt igs_ad_ps_appl_inst_all.prpsd_commencement_dt%TYPE,
141: adm_cndtnl_offer_status igs_ad_ps_appl_inst_all.adm_cndtnl_offer_status%TYPE,
142: cndtnl_offer_satisfied_dt igs_ad_ps_appl_inst_all.cndtnl_offer_satisfied_dt%TYPE,
143: cndtnl_offer_must_be_stsfd_ind igs_ad_ps_appl_inst_all.CNDTNL_OFFER_MUST_BE_STSFD_IND%TYPE,
144: adm_offer_resp_status igs_ad_ps_appl_inst_all.adm_offer_resp_status%TYPE,
137: adm_outcome_status_reason igs_ad_ps_appl_inst_all.adm_outcome_status_reason%TYPE,
138: offer_dt igs_ad_ps_appl_inst_all.offer_dt%TYPE,
139: offer_response_dt igs_ad_ps_appl_inst_all.offer_response_dt%TYPE,
140: prpsd_commencement_dt igs_ad_ps_appl_inst_all.prpsd_commencement_dt%TYPE,
141: adm_cndtnl_offer_status igs_ad_ps_appl_inst_all.adm_cndtnl_offer_status%TYPE,
142: cndtnl_offer_satisfied_dt igs_ad_ps_appl_inst_all.cndtnl_offer_satisfied_dt%TYPE,
143: cndtnl_offer_must_be_stsfd_ind igs_ad_ps_appl_inst_all.CNDTNL_OFFER_MUST_BE_STSFD_IND%TYPE,
144: adm_offer_resp_status igs_ad_ps_appl_inst_all.adm_offer_resp_status%TYPE,
145: actual_response_dt igs_ad_ps_appl_inst_all.actual_response_dt%TYPE,
138: offer_dt igs_ad_ps_appl_inst_all.offer_dt%TYPE,
139: offer_response_dt igs_ad_ps_appl_inst_all.offer_response_dt%TYPE,
140: prpsd_commencement_dt igs_ad_ps_appl_inst_all.prpsd_commencement_dt%TYPE,
141: adm_cndtnl_offer_status igs_ad_ps_appl_inst_all.adm_cndtnl_offer_status%TYPE,
142: cndtnl_offer_satisfied_dt igs_ad_ps_appl_inst_all.cndtnl_offer_satisfied_dt%TYPE,
143: cndtnl_offer_must_be_stsfd_ind igs_ad_ps_appl_inst_all.CNDTNL_OFFER_MUST_BE_STSFD_IND%TYPE,
144: adm_offer_resp_status igs_ad_ps_appl_inst_all.adm_offer_resp_status%TYPE,
145: actual_response_dt igs_ad_ps_appl_inst_all.actual_response_dt%TYPE,
146: adm_offer_dfrmnt_status igs_ad_ps_appl_inst_all.adm_offer_dfrmnt_status%TYPE,
139: offer_response_dt igs_ad_ps_appl_inst_all.offer_response_dt%TYPE,
140: prpsd_commencement_dt igs_ad_ps_appl_inst_all.prpsd_commencement_dt%TYPE,
141: adm_cndtnl_offer_status igs_ad_ps_appl_inst_all.adm_cndtnl_offer_status%TYPE,
142: cndtnl_offer_satisfied_dt igs_ad_ps_appl_inst_all.cndtnl_offer_satisfied_dt%TYPE,
143: cndtnl_offer_must_be_stsfd_ind igs_ad_ps_appl_inst_all.CNDTNL_OFFER_MUST_BE_STSFD_IND%TYPE,
144: adm_offer_resp_status igs_ad_ps_appl_inst_all.adm_offer_resp_status%TYPE,
145: actual_response_dt igs_ad_ps_appl_inst_all.actual_response_dt%TYPE,
146: adm_offer_dfrmnt_status igs_ad_ps_appl_inst_all.adm_offer_dfrmnt_status%TYPE,
147: deferred_adm_cal_type igs_ad_ps_appl_inst_all.deferred_adm_cal_type%TYPE,
140: prpsd_commencement_dt igs_ad_ps_appl_inst_all.prpsd_commencement_dt%TYPE,
141: adm_cndtnl_offer_status igs_ad_ps_appl_inst_all.adm_cndtnl_offer_status%TYPE,
142: cndtnl_offer_satisfied_dt igs_ad_ps_appl_inst_all.cndtnl_offer_satisfied_dt%TYPE,
143: cndtnl_offer_must_be_stsfd_ind igs_ad_ps_appl_inst_all.CNDTNL_OFFER_MUST_BE_STSFD_IND%TYPE,
144: adm_offer_resp_status igs_ad_ps_appl_inst_all.adm_offer_resp_status%TYPE,
145: actual_response_dt igs_ad_ps_appl_inst_all.actual_response_dt%TYPE,
146: adm_offer_dfrmnt_status igs_ad_ps_appl_inst_all.adm_offer_dfrmnt_status%TYPE,
147: deferred_adm_cal_type igs_ad_ps_appl_inst_all.deferred_adm_cal_type%TYPE,
148: deferred_adm_ci_sequence_num igs_ad_ps_appl_inst_all.deferred_adm_ci_sequence_num%TYPE,
141: adm_cndtnl_offer_status igs_ad_ps_appl_inst_all.adm_cndtnl_offer_status%TYPE,
142: cndtnl_offer_satisfied_dt igs_ad_ps_appl_inst_all.cndtnl_offer_satisfied_dt%TYPE,
143: cndtnl_offer_must_be_stsfd_ind igs_ad_ps_appl_inst_all.CNDTNL_OFFER_MUST_BE_STSFD_IND%TYPE,
144: adm_offer_resp_status igs_ad_ps_appl_inst_all.adm_offer_resp_status%TYPE,
145: actual_response_dt igs_ad_ps_appl_inst_all.actual_response_dt%TYPE,
146: adm_offer_dfrmnt_status igs_ad_ps_appl_inst_all.adm_offer_dfrmnt_status%TYPE,
147: deferred_adm_cal_type igs_ad_ps_appl_inst_all.deferred_adm_cal_type%TYPE,
148: deferred_adm_ci_sequence_num igs_ad_ps_appl_inst_all.deferred_adm_ci_sequence_num%TYPE,
149: deferred_tracking_id igs_ad_ps_appl_inst_all.deferred_tracking_id%TYPE,
142: cndtnl_offer_satisfied_dt igs_ad_ps_appl_inst_all.cndtnl_offer_satisfied_dt%TYPE,
143: cndtnl_offer_must_be_stsfd_ind igs_ad_ps_appl_inst_all.CNDTNL_OFFER_MUST_BE_STSFD_IND%TYPE,
144: adm_offer_resp_status igs_ad_ps_appl_inst_all.adm_offer_resp_status%TYPE,
145: actual_response_dt igs_ad_ps_appl_inst_all.actual_response_dt%TYPE,
146: adm_offer_dfrmnt_status igs_ad_ps_appl_inst_all.adm_offer_dfrmnt_status%TYPE,
147: deferred_adm_cal_type igs_ad_ps_appl_inst_all.deferred_adm_cal_type%TYPE,
148: deferred_adm_ci_sequence_num igs_ad_ps_appl_inst_all.deferred_adm_ci_sequence_num%TYPE,
149: deferred_tracking_id igs_ad_ps_appl_inst_all.deferred_tracking_id%TYPE,
150: ass_rank igs_ad_ps_appl_inst_all.ass_rank%TYPE,
143: cndtnl_offer_must_be_stsfd_ind igs_ad_ps_appl_inst_all.CNDTNL_OFFER_MUST_BE_STSFD_IND%TYPE,
144: adm_offer_resp_status igs_ad_ps_appl_inst_all.adm_offer_resp_status%TYPE,
145: actual_response_dt igs_ad_ps_appl_inst_all.actual_response_dt%TYPE,
146: adm_offer_dfrmnt_status igs_ad_ps_appl_inst_all.adm_offer_dfrmnt_status%TYPE,
147: deferred_adm_cal_type igs_ad_ps_appl_inst_all.deferred_adm_cal_type%TYPE,
148: deferred_adm_ci_sequence_num igs_ad_ps_appl_inst_all.deferred_adm_ci_sequence_num%TYPE,
149: deferred_tracking_id igs_ad_ps_appl_inst_all.deferred_tracking_id%TYPE,
150: ass_rank igs_ad_ps_appl_inst_all.ass_rank%TYPE,
151: secondary_ass_rank igs_ad_ps_appl_inst_all.secondary_ass_rank%TYPE,
144: adm_offer_resp_status igs_ad_ps_appl_inst_all.adm_offer_resp_status%TYPE,
145: actual_response_dt igs_ad_ps_appl_inst_all.actual_response_dt%TYPE,
146: adm_offer_dfrmnt_status igs_ad_ps_appl_inst_all.adm_offer_dfrmnt_status%TYPE,
147: deferred_adm_cal_type igs_ad_ps_appl_inst_all.deferred_adm_cal_type%TYPE,
148: deferred_adm_ci_sequence_num igs_ad_ps_appl_inst_all.deferred_adm_ci_sequence_num%TYPE,
149: deferred_tracking_id igs_ad_ps_appl_inst_all.deferred_tracking_id%TYPE,
150: ass_rank igs_ad_ps_appl_inst_all.ass_rank%TYPE,
151: secondary_ass_rank igs_ad_ps_appl_inst_all.secondary_ass_rank%TYPE,
152: intrntnl_acceptance_advice_num igs_ad_ps_appl_inst_all.intrntnl_acceptance_advice_num%TYPE,
145: actual_response_dt igs_ad_ps_appl_inst_all.actual_response_dt%TYPE,
146: adm_offer_dfrmnt_status igs_ad_ps_appl_inst_all.adm_offer_dfrmnt_status%TYPE,
147: deferred_adm_cal_type igs_ad_ps_appl_inst_all.deferred_adm_cal_type%TYPE,
148: deferred_adm_ci_sequence_num igs_ad_ps_appl_inst_all.deferred_adm_ci_sequence_num%TYPE,
149: deferred_tracking_id igs_ad_ps_appl_inst_all.deferred_tracking_id%TYPE,
150: ass_rank igs_ad_ps_appl_inst_all.ass_rank%TYPE,
151: secondary_ass_rank igs_ad_ps_appl_inst_all.secondary_ass_rank%TYPE,
152: intrntnl_acceptance_advice_num igs_ad_ps_appl_inst_all.intrntnl_acceptance_advice_num%TYPE,
153: ass_tracking_id igs_ad_ps_appl_inst_all.ass_tracking_id%TYPE,
146: adm_offer_dfrmnt_status igs_ad_ps_appl_inst_all.adm_offer_dfrmnt_status%TYPE,
147: deferred_adm_cal_type igs_ad_ps_appl_inst_all.deferred_adm_cal_type%TYPE,
148: deferred_adm_ci_sequence_num igs_ad_ps_appl_inst_all.deferred_adm_ci_sequence_num%TYPE,
149: deferred_tracking_id igs_ad_ps_appl_inst_all.deferred_tracking_id%TYPE,
150: ass_rank igs_ad_ps_appl_inst_all.ass_rank%TYPE,
151: secondary_ass_rank igs_ad_ps_appl_inst_all.secondary_ass_rank%TYPE,
152: intrntnl_acceptance_advice_num igs_ad_ps_appl_inst_all.intrntnl_acceptance_advice_num%TYPE,
153: ass_tracking_id igs_ad_ps_appl_inst_all.ass_tracking_id%TYPE,
154: fee_cat igs_ad_ps_appl_inst_all.fee_cat%TYPE,
147: deferred_adm_cal_type igs_ad_ps_appl_inst_all.deferred_adm_cal_type%TYPE,
148: deferred_adm_ci_sequence_num igs_ad_ps_appl_inst_all.deferred_adm_ci_sequence_num%TYPE,
149: deferred_tracking_id igs_ad_ps_appl_inst_all.deferred_tracking_id%TYPE,
150: ass_rank igs_ad_ps_appl_inst_all.ass_rank%TYPE,
151: secondary_ass_rank igs_ad_ps_appl_inst_all.secondary_ass_rank%TYPE,
152: intrntnl_acceptance_advice_num igs_ad_ps_appl_inst_all.intrntnl_acceptance_advice_num%TYPE,
153: ass_tracking_id igs_ad_ps_appl_inst_all.ass_tracking_id%TYPE,
154: fee_cat igs_ad_ps_appl_inst_all.fee_cat%TYPE,
155: hecs_payment_option igs_ad_ps_appl_inst_all.hecs_payment_option%TYPE,
148: deferred_adm_ci_sequence_num igs_ad_ps_appl_inst_all.deferred_adm_ci_sequence_num%TYPE,
149: deferred_tracking_id igs_ad_ps_appl_inst_all.deferred_tracking_id%TYPE,
150: ass_rank igs_ad_ps_appl_inst_all.ass_rank%TYPE,
151: secondary_ass_rank igs_ad_ps_appl_inst_all.secondary_ass_rank%TYPE,
152: intrntnl_acceptance_advice_num igs_ad_ps_appl_inst_all.intrntnl_acceptance_advice_num%TYPE,
153: ass_tracking_id igs_ad_ps_appl_inst_all.ass_tracking_id%TYPE,
154: fee_cat igs_ad_ps_appl_inst_all.fee_cat%TYPE,
155: hecs_payment_option igs_ad_ps_appl_inst_all.hecs_payment_option%TYPE,
156: expected_completion_yr igs_ad_ps_appl_inst_all.expected_completion_yr%TYPE,
149: deferred_tracking_id igs_ad_ps_appl_inst_all.deferred_tracking_id%TYPE,
150: ass_rank igs_ad_ps_appl_inst_all.ass_rank%TYPE,
151: secondary_ass_rank igs_ad_ps_appl_inst_all.secondary_ass_rank%TYPE,
152: intrntnl_acceptance_advice_num igs_ad_ps_appl_inst_all.intrntnl_acceptance_advice_num%TYPE,
153: ass_tracking_id igs_ad_ps_appl_inst_all.ass_tracking_id%TYPE,
154: fee_cat igs_ad_ps_appl_inst_all.fee_cat%TYPE,
155: hecs_payment_option igs_ad_ps_appl_inst_all.hecs_payment_option%TYPE,
156: expected_completion_yr igs_ad_ps_appl_inst_all.expected_completion_yr%TYPE,
157: expected_completion_perd igs_ad_ps_appl_inst_all.expected_completion_perd%TYPE,
150: ass_rank igs_ad_ps_appl_inst_all.ass_rank%TYPE,
151: secondary_ass_rank igs_ad_ps_appl_inst_all.secondary_ass_rank%TYPE,
152: intrntnl_acceptance_advice_num igs_ad_ps_appl_inst_all.intrntnl_acceptance_advice_num%TYPE,
153: ass_tracking_id igs_ad_ps_appl_inst_all.ass_tracking_id%TYPE,
154: fee_cat igs_ad_ps_appl_inst_all.fee_cat%TYPE,
155: hecs_payment_option igs_ad_ps_appl_inst_all.hecs_payment_option%TYPE,
156: expected_completion_yr igs_ad_ps_appl_inst_all.expected_completion_yr%TYPE,
157: expected_completion_perd igs_ad_ps_appl_inst_all.expected_completion_perd%TYPE,
158: correspondence_cat igs_ad_ps_appl_inst_all.correspondence_cat%TYPE,
151: secondary_ass_rank igs_ad_ps_appl_inst_all.secondary_ass_rank%TYPE,
152: intrntnl_acceptance_advice_num igs_ad_ps_appl_inst_all.intrntnl_acceptance_advice_num%TYPE,
153: ass_tracking_id igs_ad_ps_appl_inst_all.ass_tracking_id%TYPE,
154: fee_cat igs_ad_ps_appl_inst_all.fee_cat%TYPE,
155: hecs_payment_option igs_ad_ps_appl_inst_all.hecs_payment_option%TYPE,
156: expected_completion_yr igs_ad_ps_appl_inst_all.expected_completion_yr%TYPE,
157: expected_completion_perd igs_ad_ps_appl_inst_all.expected_completion_perd%TYPE,
158: correspondence_cat igs_ad_ps_appl_inst_all.correspondence_cat%TYPE,
159: enrolment_cat igs_ad_ps_appl_inst_all.enrolment_cat%TYPE,
152: intrntnl_acceptance_advice_num igs_ad_ps_appl_inst_all.intrntnl_acceptance_advice_num%TYPE,
153: ass_tracking_id igs_ad_ps_appl_inst_all.ass_tracking_id%TYPE,
154: fee_cat igs_ad_ps_appl_inst_all.fee_cat%TYPE,
155: hecs_payment_option igs_ad_ps_appl_inst_all.hecs_payment_option%TYPE,
156: expected_completion_yr igs_ad_ps_appl_inst_all.expected_completion_yr%TYPE,
157: expected_completion_perd igs_ad_ps_appl_inst_all.expected_completion_perd%TYPE,
158: correspondence_cat igs_ad_ps_appl_inst_all.correspondence_cat%TYPE,
159: enrolment_cat igs_ad_ps_appl_inst_all.enrolment_cat%TYPE,
160: funding_source igs_ad_ps_appl_inst_all.funding_source%TYPE,
153: ass_tracking_id igs_ad_ps_appl_inst_all.ass_tracking_id%TYPE,
154: fee_cat igs_ad_ps_appl_inst_all.fee_cat%TYPE,
155: hecs_payment_option igs_ad_ps_appl_inst_all.hecs_payment_option%TYPE,
156: expected_completion_yr igs_ad_ps_appl_inst_all.expected_completion_yr%TYPE,
157: expected_completion_perd igs_ad_ps_appl_inst_all.expected_completion_perd%TYPE,
158: correspondence_cat igs_ad_ps_appl_inst_all.correspondence_cat%TYPE,
159: enrolment_cat igs_ad_ps_appl_inst_all.enrolment_cat%TYPE,
160: funding_source igs_ad_ps_appl_inst_all.funding_source%TYPE,
161: applicant_acptnce_cndtn igs_ad_ps_appl_inst_all.applicant_acptnce_cndtn%TYPE,
154: fee_cat igs_ad_ps_appl_inst_all.fee_cat%TYPE,
155: hecs_payment_option igs_ad_ps_appl_inst_all.hecs_payment_option%TYPE,
156: expected_completion_yr igs_ad_ps_appl_inst_all.expected_completion_yr%TYPE,
157: expected_completion_perd igs_ad_ps_appl_inst_all.expected_completion_perd%TYPE,
158: correspondence_cat igs_ad_ps_appl_inst_all.correspondence_cat%TYPE,
159: enrolment_cat igs_ad_ps_appl_inst_all.enrolment_cat%TYPE,
160: funding_source igs_ad_ps_appl_inst_all.funding_source%TYPE,
161: applicant_acptnce_cndtn igs_ad_ps_appl_inst_all.applicant_acptnce_cndtn%TYPE,
162: cndtnl_offer_cndtn igs_ad_ps_appl_inst_all.cndtnl_offer_cndtn%TYPE,
155: hecs_payment_option igs_ad_ps_appl_inst_all.hecs_payment_option%TYPE,
156: expected_completion_yr igs_ad_ps_appl_inst_all.expected_completion_yr%TYPE,
157: expected_completion_perd igs_ad_ps_appl_inst_all.expected_completion_perd%TYPE,
158: correspondence_cat igs_ad_ps_appl_inst_all.correspondence_cat%TYPE,
159: enrolment_cat igs_ad_ps_appl_inst_all.enrolment_cat%TYPE,
160: funding_source igs_ad_ps_appl_inst_all.funding_source%TYPE,
161: applicant_acptnce_cndtn igs_ad_ps_appl_inst_all.applicant_acptnce_cndtn%TYPE,
162: cndtnl_offer_cndtn igs_ad_ps_appl_inst_all.cndtnl_offer_cndtn%TYPE,
163: ss_application_id igs_ad_ps_appl_inst_all.ss_application_id%TYPE,
156: expected_completion_yr igs_ad_ps_appl_inst_all.expected_completion_yr%TYPE,
157: expected_completion_perd igs_ad_ps_appl_inst_all.expected_completion_perd%TYPE,
158: correspondence_cat igs_ad_ps_appl_inst_all.correspondence_cat%TYPE,
159: enrolment_cat igs_ad_ps_appl_inst_all.enrolment_cat%TYPE,
160: funding_source igs_ad_ps_appl_inst_all.funding_source%TYPE,
161: applicant_acptnce_cndtn igs_ad_ps_appl_inst_all.applicant_acptnce_cndtn%TYPE,
162: cndtnl_offer_cndtn igs_ad_ps_appl_inst_all.cndtnl_offer_cndtn%TYPE,
163: ss_application_id igs_ad_ps_appl_inst_all.ss_application_id%TYPE,
164: ss_pwd igs_ad_ps_appl_inst_all.ss_pwd%TYPE,
157: expected_completion_perd igs_ad_ps_appl_inst_all.expected_completion_perd%TYPE,
158: correspondence_cat igs_ad_ps_appl_inst_all.correspondence_cat%TYPE,
159: enrolment_cat igs_ad_ps_appl_inst_all.enrolment_cat%TYPE,
160: funding_source igs_ad_ps_appl_inst_all.funding_source%TYPE,
161: applicant_acptnce_cndtn igs_ad_ps_appl_inst_all.applicant_acptnce_cndtn%TYPE,
162: cndtnl_offer_cndtn igs_ad_ps_appl_inst_all.cndtnl_offer_cndtn%TYPE,
163: ss_application_id igs_ad_ps_appl_inst_all.ss_application_id%TYPE,
164: ss_pwd igs_ad_ps_appl_inst_all.ss_pwd%TYPE,
165: authorized_dt igs_ad_ps_appl_inst_all.authorized_dt%TYPE,
158: correspondence_cat igs_ad_ps_appl_inst_all.correspondence_cat%TYPE,
159: enrolment_cat igs_ad_ps_appl_inst_all.enrolment_cat%TYPE,
160: funding_source igs_ad_ps_appl_inst_all.funding_source%TYPE,
161: applicant_acptnce_cndtn igs_ad_ps_appl_inst_all.applicant_acptnce_cndtn%TYPE,
162: cndtnl_offer_cndtn igs_ad_ps_appl_inst_all.cndtnl_offer_cndtn%TYPE,
163: ss_application_id igs_ad_ps_appl_inst_all.ss_application_id%TYPE,
164: ss_pwd igs_ad_ps_appl_inst_all.ss_pwd%TYPE,
165: authorized_dt igs_ad_ps_appl_inst_all.authorized_dt%TYPE,
166: authorizing_pers_id igs_ad_ps_appl_inst_all.authorizing_pers_id%TYPE,
159: enrolment_cat igs_ad_ps_appl_inst_all.enrolment_cat%TYPE,
160: funding_source igs_ad_ps_appl_inst_all.funding_source%TYPE,
161: applicant_acptnce_cndtn igs_ad_ps_appl_inst_all.applicant_acptnce_cndtn%TYPE,
162: cndtnl_offer_cndtn igs_ad_ps_appl_inst_all.cndtnl_offer_cndtn%TYPE,
163: ss_application_id igs_ad_ps_appl_inst_all.ss_application_id%TYPE,
164: ss_pwd igs_ad_ps_appl_inst_all.ss_pwd%TYPE,
165: authorized_dt igs_ad_ps_appl_inst_all.authorized_dt%TYPE,
166: authorizing_pers_id igs_ad_ps_appl_inst_all.authorizing_pers_id%TYPE,
167: entry_status igs_ad_ps_appl_inst_all.entry_status%TYPE,
160: funding_source igs_ad_ps_appl_inst_all.funding_source%TYPE,
161: applicant_acptnce_cndtn igs_ad_ps_appl_inst_all.applicant_acptnce_cndtn%TYPE,
162: cndtnl_offer_cndtn igs_ad_ps_appl_inst_all.cndtnl_offer_cndtn%TYPE,
163: ss_application_id igs_ad_ps_appl_inst_all.ss_application_id%TYPE,
164: ss_pwd igs_ad_ps_appl_inst_all.ss_pwd%TYPE,
165: authorized_dt igs_ad_ps_appl_inst_all.authorized_dt%TYPE,
166: authorizing_pers_id igs_ad_ps_appl_inst_all.authorizing_pers_id%TYPE,
167: entry_status igs_ad_ps_appl_inst_all.entry_status%TYPE,
168: entry_level igs_ad_ps_appl_inst_all.entry_level%TYPE,
161: applicant_acptnce_cndtn igs_ad_ps_appl_inst_all.applicant_acptnce_cndtn%TYPE,
162: cndtnl_offer_cndtn igs_ad_ps_appl_inst_all.cndtnl_offer_cndtn%TYPE,
163: ss_application_id igs_ad_ps_appl_inst_all.ss_application_id%TYPE,
164: ss_pwd igs_ad_ps_appl_inst_all.ss_pwd%TYPE,
165: authorized_dt igs_ad_ps_appl_inst_all.authorized_dt%TYPE,
166: authorizing_pers_id igs_ad_ps_appl_inst_all.authorizing_pers_id%TYPE,
167: entry_status igs_ad_ps_appl_inst_all.entry_status%TYPE,
168: entry_level igs_ad_ps_appl_inst_all.entry_level%TYPE,
169: sch_apl_to_id igs_ad_ps_appl_inst_all.sch_apl_to_id%TYPE,
162: cndtnl_offer_cndtn igs_ad_ps_appl_inst_all.cndtnl_offer_cndtn%TYPE,
163: ss_application_id igs_ad_ps_appl_inst_all.ss_application_id%TYPE,
164: ss_pwd igs_ad_ps_appl_inst_all.ss_pwd%TYPE,
165: authorized_dt igs_ad_ps_appl_inst_all.authorized_dt%TYPE,
166: authorizing_pers_id igs_ad_ps_appl_inst_all.authorizing_pers_id%TYPE,
167: entry_status igs_ad_ps_appl_inst_all.entry_status%TYPE,
168: entry_level igs_ad_ps_appl_inst_all.entry_level%TYPE,
169: sch_apl_to_id igs_ad_ps_appl_inst_all.sch_apl_to_id%TYPE,
170: idx_calc_date igs_ad_ps_appl_inst_all.idx_calc_date%TYPE,
163: ss_application_id igs_ad_ps_appl_inst_all.ss_application_id%TYPE,
164: ss_pwd igs_ad_ps_appl_inst_all.ss_pwd%TYPE,
165: authorized_dt igs_ad_ps_appl_inst_all.authorized_dt%TYPE,
166: authorizing_pers_id igs_ad_ps_appl_inst_all.authorizing_pers_id%TYPE,
167: entry_status igs_ad_ps_appl_inst_all.entry_status%TYPE,
168: entry_level igs_ad_ps_appl_inst_all.entry_level%TYPE,
169: sch_apl_to_id igs_ad_ps_appl_inst_all.sch_apl_to_id%TYPE,
170: idx_calc_date igs_ad_ps_appl_inst_all.idx_calc_date%TYPE,
171: waitlist_status igs_ad_ps_appl_inst_all.waitlist_status%TYPE,
164: ss_pwd igs_ad_ps_appl_inst_all.ss_pwd%TYPE,
165: authorized_dt igs_ad_ps_appl_inst_all.authorized_dt%TYPE,
166: authorizing_pers_id igs_ad_ps_appl_inst_all.authorizing_pers_id%TYPE,
167: entry_status igs_ad_ps_appl_inst_all.entry_status%TYPE,
168: entry_level igs_ad_ps_appl_inst_all.entry_level%TYPE,
169: sch_apl_to_id igs_ad_ps_appl_inst_all.sch_apl_to_id%TYPE,
170: idx_calc_date igs_ad_ps_appl_inst_all.idx_calc_date%TYPE,
171: waitlist_status igs_ad_ps_appl_inst_all.waitlist_status%TYPE,
172: attribute21 igs_ad_ps_appl_inst_all.attribute21%TYPE,
165: authorized_dt igs_ad_ps_appl_inst_all.authorized_dt%TYPE,
166: authorizing_pers_id igs_ad_ps_appl_inst_all.authorizing_pers_id%TYPE,
167: entry_status igs_ad_ps_appl_inst_all.entry_status%TYPE,
168: entry_level igs_ad_ps_appl_inst_all.entry_level%TYPE,
169: sch_apl_to_id igs_ad_ps_appl_inst_all.sch_apl_to_id%TYPE,
170: idx_calc_date igs_ad_ps_appl_inst_all.idx_calc_date%TYPE,
171: waitlist_status igs_ad_ps_appl_inst_all.waitlist_status%TYPE,
172: attribute21 igs_ad_ps_appl_inst_all.attribute21%TYPE,
173: attribute22 igs_ad_ps_appl_inst_all.attribute22%TYPE,
166: authorizing_pers_id igs_ad_ps_appl_inst_all.authorizing_pers_id%TYPE,
167: entry_status igs_ad_ps_appl_inst_all.entry_status%TYPE,
168: entry_level igs_ad_ps_appl_inst_all.entry_level%TYPE,
169: sch_apl_to_id igs_ad_ps_appl_inst_all.sch_apl_to_id%TYPE,
170: idx_calc_date igs_ad_ps_appl_inst_all.idx_calc_date%TYPE,
171: waitlist_status igs_ad_ps_appl_inst_all.waitlist_status%TYPE,
172: attribute21 igs_ad_ps_appl_inst_all.attribute21%TYPE,
173: attribute22 igs_ad_ps_appl_inst_all.attribute22%TYPE,
174: attribute23 igs_ad_ps_appl_inst_all.attribute23%TYPE,
167: entry_status igs_ad_ps_appl_inst_all.entry_status%TYPE,
168: entry_level igs_ad_ps_appl_inst_all.entry_level%TYPE,
169: sch_apl_to_id igs_ad_ps_appl_inst_all.sch_apl_to_id%TYPE,
170: idx_calc_date igs_ad_ps_appl_inst_all.idx_calc_date%TYPE,
171: waitlist_status igs_ad_ps_appl_inst_all.waitlist_status%TYPE,
172: attribute21 igs_ad_ps_appl_inst_all.attribute21%TYPE,
173: attribute22 igs_ad_ps_appl_inst_all.attribute22%TYPE,
174: attribute23 igs_ad_ps_appl_inst_all.attribute23%TYPE,
175: attribute24 igs_ad_ps_appl_inst_all.attribute24%TYPE,
168: entry_level igs_ad_ps_appl_inst_all.entry_level%TYPE,
169: sch_apl_to_id igs_ad_ps_appl_inst_all.sch_apl_to_id%TYPE,
170: idx_calc_date igs_ad_ps_appl_inst_all.idx_calc_date%TYPE,
171: waitlist_status igs_ad_ps_appl_inst_all.waitlist_status%TYPE,
172: attribute21 igs_ad_ps_appl_inst_all.attribute21%TYPE,
173: attribute22 igs_ad_ps_appl_inst_all.attribute22%TYPE,
174: attribute23 igs_ad_ps_appl_inst_all.attribute23%TYPE,
175: attribute24 igs_ad_ps_appl_inst_all.attribute24%TYPE,
176: attribute25 igs_ad_ps_appl_inst_all.attribute25%TYPE,
169: sch_apl_to_id igs_ad_ps_appl_inst_all.sch_apl_to_id%TYPE,
170: idx_calc_date igs_ad_ps_appl_inst_all.idx_calc_date%TYPE,
171: waitlist_status igs_ad_ps_appl_inst_all.waitlist_status%TYPE,
172: attribute21 igs_ad_ps_appl_inst_all.attribute21%TYPE,
173: attribute22 igs_ad_ps_appl_inst_all.attribute22%TYPE,
174: attribute23 igs_ad_ps_appl_inst_all.attribute23%TYPE,
175: attribute24 igs_ad_ps_appl_inst_all.attribute24%TYPE,
176: attribute25 igs_ad_ps_appl_inst_all.attribute25%TYPE,
177: attribute26 igs_ad_ps_appl_inst_all.attribute26%TYPE,
170: idx_calc_date igs_ad_ps_appl_inst_all.idx_calc_date%TYPE,
171: waitlist_status igs_ad_ps_appl_inst_all.waitlist_status%TYPE,
172: attribute21 igs_ad_ps_appl_inst_all.attribute21%TYPE,
173: attribute22 igs_ad_ps_appl_inst_all.attribute22%TYPE,
174: attribute23 igs_ad_ps_appl_inst_all.attribute23%TYPE,
175: attribute24 igs_ad_ps_appl_inst_all.attribute24%TYPE,
176: attribute25 igs_ad_ps_appl_inst_all.attribute25%TYPE,
177: attribute26 igs_ad_ps_appl_inst_all.attribute26%TYPE,
178: attribute27 igs_ad_ps_appl_inst_all.attribute27%TYPE,
171: waitlist_status igs_ad_ps_appl_inst_all.waitlist_status%TYPE,
172: attribute21 igs_ad_ps_appl_inst_all.attribute21%TYPE,
173: attribute22 igs_ad_ps_appl_inst_all.attribute22%TYPE,
174: attribute23 igs_ad_ps_appl_inst_all.attribute23%TYPE,
175: attribute24 igs_ad_ps_appl_inst_all.attribute24%TYPE,
176: attribute25 igs_ad_ps_appl_inst_all.attribute25%TYPE,
177: attribute26 igs_ad_ps_appl_inst_all.attribute26%TYPE,
178: attribute27 igs_ad_ps_appl_inst_all.attribute27%TYPE,
179: attribute28 igs_ad_ps_appl_inst_all.attribute28%TYPE,
172: attribute21 igs_ad_ps_appl_inst_all.attribute21%TYPE,
173: attribute22 igs_ad_ps_appl_inst_all.attribute22%TYPE,
174: attribute23 igs_ad_ps_appl_inst_all.attribute23%TYPE,
175: attribute24 igs_ad_ps_appl_inst_all.attribute24%TYPE,
176: attribute25 igs_ad_ps_appl_inst_all.attribute25%TYPE,
177: attribute26 igs_ad_ps_appl_inst_all.attribute26%TYPE,
178: attribute27 igs_ad_ps_appl_inst_all.attribute27%TYPE,
179: attribute28 igs_ad_ps_appl_inst_all.attribute28%TYPE,
180: attribute29 igs_ad_ps_appl_inst_all.attribute29%TYPE,
173: attribute22 igs_ad_ps_appl_inst_all.attribute22%TYPE,
174: attribute23 igs_ad_ps_appl_inst_all.attribute23%TYPE,
175: attribute24 igs_ad_ps_appl_inst_all.attribute24%TYPE,
176: attribute25 igs_ad_ps_appl_inst_all.attribute25%TYPE,
177: attribute26 igs_ad_ps_appl_inst_all.attribute26%TYPE,
178: attribute27 igs_ad_ps_appl_inst_all.attribute27%TYPE,
179: attribute28 igs_ad_ps_appl_inst_all.attribute28%TYPE,
180: attribute29 igs_ad_ps_appl_inst_all.attribute29%TYPE,
181: attribute30 igs_ad_ps_appl_inst_all.attribute30%TYPE,
174: attribute23 igs_ad_ps_appl_inst_all.attribute23%TYPE,
175: attribute24 igs_ad_ps_appl_inst_all.attribute24%TYPE,
176: attribute25 igs_ad_ps_appl_inst_all.attribute25%TYPE,
177: attribute26 igs_ad_ps_appl_inst_all.attribute26%TYPE,
178: attribute27 igs_ad_ps_appl_inst_all.attribute27%TYPE,
179: attribute28 igs_ad_ps_appl_inst_all.attribute28%TYPE,
180: attribute29 igs_ad_ps_appl_inst_all.attribute29%TYPE,
181: attribute30 igs_ad_ps_appl_inst_all.attribute30%TYPE,
182: attribute31 igs_ad_ps_appl_inst_all.attribute31%TYPE,
175: attribute24 igs_ad_ps_appl_inst_all.attribute24%TYPE,
176: attribute25 igs_ad_ps_appl_inst_all.attribute25%TYPE,
177: attribute26 igs_ad_ps_appl_inst_all.attribute26%TYPE,
178: attribute27 igs_ad_ps_appl_inst_all.attribute27%TYPE,
179: attribute28 igs_ad_ps_appl_inst_all.attribute28%TYPE,
180: attribute29 igs_ad_ps_appl_inst_all.attribute29%TYPE,
181: attribute30 igs_ad_ps_appl_inst_all.attribute30%TYPE,
182: attribute31 igs_ad_ps_appl_inst_all.attribute31%TYPE,
183: attribute32 igs_ad_ps_appl_inst_all.attribute32%TYPE,
176: attribute25 igs_ad_ps_appl_inst_all.attribute25%TYPE,
177: attribute26 igs_ad_ps_appl_inst_all.attribute26%TYPE,
178: attribute27 igs_ad_ps_appl_inst_all.attribute27%TYPE,
179: attribute28 igs_ad_ps_appl_inst_all.attribute28%TYPE,
180: attribute29 igs_ad_ps_appl_inst_all.attribute29%TYPE,
181: attribute30 igs_ad_ps_appl_inst_all.attribute30%TYPE,
182: attribute31 igs_ad_ps_appl_inst_all.attribute31%TYPE,
183: attribute32 igs_ad_ps_appl_inst_all.attribute32%TYPE,
184: attribute33 igs_ad_ps_appl_inst_all.attribute33%TYPE,
177: attribute26 igs_ad_ps_appl_inst_all.attribute26%TYPE,
178: attribute27 igs_ad_ps_appl_inst_all.attribute27%TYPE,
179: attribute28 igs_ad_ps_appl_inst_all.attribute28%TYPE,
180: attribute29 igs_ad_ps_appl_inst_all.attribute29%TYPE,
181: attribute30 igs_ad_ps_appl_inst_all.attribute30%TYPE,
182: attribute31 igs_ad_ps_appl_inst_all.attribute31%TYPE,
183: attribute32 igs_ad_ps_appl_inst_all.attribute32%TYPE,
184: attribute33 igs_ad_ps_appl_inst_all.attribute33%TYPE,
185: attribute34 igs_ad_ps_appl_inst_all.attribute34%TYPE,
178: attribute27 igs_ad_ps_appl_inst_all.attribute27%TYPE,
179: attribute28 igs_ad_ps_appl_inst_all.attribute28%TYPE,
180: attribute29 igs_ad_ps_appl_inst_all.attribute29%TYPE,
181: attribute30 igs_ad_ps_appl_inst_all.attribute30%TYPE,
182: attribute31 igs_ad_ps_appl_inst_all.attribute31%TYPE,
183: attribute32 igs_ad_ps_appl_inst_all.attribute32%TYPE,
184: attribute33 igs_ad_ps_appl_inst_all.attribute33%TYPE,
185: attribute34 igs_ad_ps_appl_inst_all.attribute34%TYPE,
186: attribute35 igs_ad_ps_appl_inst_all.attribute35%TYPE,
179: attribute28 igs_ad_ps_appl_inst_all.attribute28%TYPE,
180: attribute29 igs_ad_ps_appl_inst_all.attribute29%TYPE,
181: attribute30 igs_ad_ps_appl_inst_all.attribute30%TYPE,
182: attribute31 igs_ad_ps_appl_inst_all.attribute31%TYPE,
183: attribute32 igs_ad_ps_appl_inst_all.attribute32%TYPE,
184: attribute33 igs_ad_ps_appl_inst_all.attribute33%TYPE,
185: attribute34 igs_ad_ps_appl_inst_all.attribute34%TYPE,
186: attribute35 igs_ad_ps_appl_inst_all.attribute35%TYPE,
187: attribute36 igs_ad_ps_appl_inst_all.attribute36%TYPE,
180: attribute29 igs_ad_ps_appl_inst_all.attribute29%TYPE,
181: attribute30 igs_ad_ps_appl_inst_all.attribute30%TYPE,
182: attribute31 igs_ad_ps_appl_inst_all.attribute31%TYPE,
183: attribute32 igs_ad_ps_appl_inst_all.attribute32%TYPE,
184: attribute33 igs_ad_ps_appl_inst_all.attribute33%TYPE,
185: attribute34 igs_ad_ps_appl_inst_all.attribute34%TYPE,
186: attribute35 igs_ad_ps_appl_inst_all.attribute35%TYPE,
187: attribute36 igs_ad_ps_appl_inst_all.attribute36%TYPE,
188: attribute37 igs_ad_ps_appl_inst_all.attribute37%TYPE,
181: attribute30 igs_ad_ps_appl_inst_all.attribute30%TYPE,
182: attribute31 igs_ad_ps_appl_inst_all.attribute31%TYPE,
183: attribute32 igs_ad_ps_appl_inst_all.attribute32%TYPE,
184: attribute33 igs_ad_ps_appl_inst_all.attribute33%TYPE,
185: attribute34 igs_ad_ps_appl_inst_all.attribute34%TYPE,
186: attribute35 igs_ad_ps_appl_inst_all.attribute35%TYPE,
187: attribute36 igs_ad_ps_appl_inst_all.attribute36%TYPE,
188: attribute37 igs_ad_ps_appl_inst_all.attribute37%TYPE,
189: attribute38 igs_ad_ps_appl_inst_all.attribute38%TYPE,
182: attribute31 igs_ad_ps_appl_inst_all.attribute31%TYPE,
183: attribute32 igs_ad_ps_appl_inst_all.attribute32%TYPE,
184: attribute33 igs_ad_ps_appl_inst_all.attribute33%TYPE,
185: attribute34 igs_ad_ps_appl_inst_all.attribute34%TYPE,
186: attribute35 igs_ad_ps_appl_inst_all.attribute35%TYPE,
187: attribute36 igs_ad_ps_appl_inst_all.attribute36%TYPE,
188: attribute37 igs_ad_ps_appl_inst_all.attribute37%TYPE,
189: attribute38 igs_ad_ps_appl_inst_all.attribute38%TYPE,
190: attribute39 igs_ad_ps_appl_inst_all.attribute39%TYPE,
183: attribute32 igs_ad_ps_appl_inst_all.attribute32%TYPE,
184: attribute33 igs_ad_ps_appl_inst_all.attribute33%TYPE,
185: attribute34 igs_ad_ps_appl_inst_all.attribute34%TYPE,
186: attribute35 igs_ad_ps_appl_inst_all.attribute35%TYPE,
187: attribute36 igs_ad_ps_appl_inst_all.attribute36%TYPE,
188: attribute37 igs_ad_ps_appl_inst_all.attribute37%TYPE,
189: attribute38 igs_ad_ps_appl_inst_all.attribute38%TYPE,
190: attribute39 igs_ad_ps_appl_inst_all.attribute39%TYPE,
191: attribute40 igs_ad_ps_appl_inst_all.attribute40%TYPE,
184: attribute33 igs_ad_ps_appl_inst_all.attribute33%TYPE,
185: attribute34 igs_ad_ps_appl_inst_all.attribute34%TYPE,
186: attribute35 igs_ad_ps_appl_inst_all.attribute35%TYPE,
187: attribute36 igs_ad_ps_appl_inst_all.attribute36%TYPE,
188: attribute37 igs_ad_ps_appl_inst_all.attribute37%TYPE,
189: attribute38 igs_ad_ps_appl_inst_all.attribute38%TYPE,
190: attribute39 igs_ad_ps_appl_inst_all.attribute39%TYPE,
191: attribute40 igs_ad_ps_appl_inst_all.attribute40%TYPE,
192: future_acad_cal_type igs_ad_ps_appl_inst_all.future_acad_cal_type%TYPE,
185: attribute34 igs_ad_ps_appl_inst_all.attribute34%TYPE,
186: attribute35 igs_ad_ps_appl_inst_all.attribute35%TYPE,
187: attribute36 igs_ad_ps_appl_inst_all.attribute36%TYPE,
188: attribute37 igs_ad_ps_appl_inst_all.attribute37%TYPE,
189: attribute38 igs_ad_ps_appl_inst_all.attribute38%TYPE,
190: attribute39 igs_ad_ps_appl_inst_all.attribute39%TYPE,
191: attribute40 igs_ad_ps_appl_inst_all.attribute40%TYPE,
192: future_acad_cal_type igs_ad_ps_appl_inst_all.future_acad_cal_type%TYPE,
193: future_acad_ci_sequence_number igs_ad_ps_appl_inst_all.future_acad_ci_sequence_number%TYPE,
186: attribute35 igs_ad_ps_appl_inst_all.attribute35%TYPE,
187: attribute36 igs_ad_ps_appl_inst_all.attribute36%TYPE,
188: attribute37 igs_ad_ps_appl_inst_all.attribute37%TYPE,
189: attribute38 igs_ad_ps_appl_inst_all.attribute38%TYPE,
190: attribute39 igs_ad_ps_appl_inst_all.attribute39%TYPE,
191: attribute40 igs_ad_ps_appl_inst_all.attribute40%TYPE,
192: future_acad_cal_type igs_ad_ps_appl_inst_all.future_acad_cal_type%TYPE,
193: future_acad_ci_sequence_number igs_ad_ps_appl_inst_all.future_acad_ci_sequence_number%TYPE,
194: future_adm_cal_type igs_ad_ps_appl_inst_all.future_adm_cal_type%TYPE,
187: attribute36 igs_ad_ps_appl_inst_all.attribute36%TYPE,
188: attribute37 igs_ad_ps_appl_inst_all.attribute37%TYPE,
189: attribute38 igs_ad_ps_appl_inst_all.attribute38%TYPE,
190: attribute39 igs_ad_ps_appl_inst_all.attribute39%TYPE,
191: attribute40 igs_ad_ps_appl_inst_all.attribute40%TYPE,
192: future_acad_cal_type igs_ad_ps_appl_inst_all.future_acad_cal_type%TYPE,
193: future_acad_ci_sequence_number igs_ad_ps_appl_inst_all.future_acad_ci_sequence_number%TYPE,
194: future_adm_cal_type igs_ad_ps_appl_inst_all.future_adm_cal_type%TYPE,
195: future_adm_ci_sequence_number igs_ad_ps_appl_inst_all.future_adm_ci_sequence_number%TYPE,
188: attribute37 igs_ad_ps_appl_inst_all.attribute37%TYPE,
189: attribute38 igs_ad_ps_appl_inst_all.attribute38%TYPE,
190: attribute39 igs_ad_ps_appl_inst_all.attribute39%TYPE,
191: attribute40 igs_ad_ps_appl_inst_all.attribute40%TYPE,
192: future_acad_cal_type igs_ad_ps_appl_inst_all.future_acad_cal_type%TYPE,
193: future_acad_ci_sequence_number igs_ad_ps_appl_inst_all.future_acad_ci_sequence_number%TYPE,
194: future_adm_cal_type igs_ad_ps_appl_inst_all.future_adm_cal_type%TYPE,
195: future_adm_ci_sequence_number igs_ad_ps_appl_inst_all.future_adm_ci_sequence_number%TYPE,
196: previous_term_adm_appl_number igs_ad_ps_appl_inst_all.PREVIOUS_TERM_ADM_APPL_NUMBER%TYPE,
189: attribute38 igs_ad_ps_appl_inst_all.attribute38%TYPE,
190: attribute39 igs_ad_ps_appl_inst_all.attribute39%TYPE,
191: attribute40 igs_ad_ps_appl_inst_all.attribute40%TYPE,
192: future_acad_cal_type igs_ad_ps_appl_inst_all.future_acad_cal_type%TYPE,
193: future_acad_ci_sequence_number igs_ad_ps_appl_inst_all.future_acad_ci_sequence_number%TYPE,
194: future_adm_cal_type igs_ad_ps_appl_inst_all.future_adm_cal_type%TYPE,
195: future_adm_ci_sequence_number igs_ad_ps_appl_inst_all.future_adm_ci_sequence_number%TYPE,
196: previous_term_adm_appl_number igs_ad_ps_appl_inst_all.PREVIOUS_TERM_ADM_APPL_NUMBER%TYPE,
197: previous_term_sequence_number igs_ad_ps_appl_inst_all.PREVIOUS_TERM_SEQUENCE_NUMBER%TYPE,
190: attribute39 igs_ad_ps_appl_inst_all.attribute39%TYPE,
191: attribute40 igs_ad_ps_appl_inst_all.attribute40%TYPE,
192: future_acad_cal_type igs_ad_ps_appl_inst_all.future_acad_cal_type%TYPE,
193: future_acad_ci_sequence_number igs_ad_ps_appl_inst_all.future_acad_ci_sequence_number%TYPE,
194: future_adm_cal_type igs_ad_ps_appl_inst_all.future_adm_cal_type%TYPE,
195: future_adm_ci_sequence_number igs_ad_ps_appl_inst_all.future_adm_ci_sequence_number%TYPE,
196: previous_term_adm_appl_number igs_ad_ps_appl_inst_all.PREVIOUS_TERM_ADM_APPL_NUMBER%TYPE,
197: previous_term_sequence_number igs_ad_ps_appl_inst_all.PREVIOUS_TERM_SEQUENCE_NUMBER%TYPE,
198: future_term_adm_appl_number igs_ad_ps_appl_inst_all.future_term_adm_appl_number%TYPE,
191: attribute40 igs_ad_ps_appl_inst_all.attribute40%TYPE,
192: future_acad_cal_type igs_ad_ps_appl_inst_all.future_acad_cal_type%TYPE,
193: future_acad_ci_sequence_number igs_ad_ps_appl_inst_all.future_acad_ci_sequence_number%TYPE,
194: future_adm_cal_type igs_ad_ps_appl_inst_all.future_adm_cal_type%TYPE,
195: future_adm_ci_sequence_number igs_ad_ps_appl_inst_all.future_adm_ci_sequence_number%TYPE,
196: previous_term_adm_appl_number igs_ad_ps_appl_inst_all.PREVIOUS_TERM_ADM_APPL_NUMBER%TYPE,
197: previous_term_sequence_number igs_ad_ps_appl_inst_all.PREVIOUS_TERM_SEQUENCE_NUMBER%TYPE,
198: future_term_adm_appl_number igs_ad_ps_appl_inst_all.future_term_adm_appl_number%TYPE,
199: future_term_sequence_number igs_ad_ps_appl_inst_all.future_term_sequence_number%TYPE,
192: future_acad_cal_type igs_ad_ps_appl_inst_all.future_acad_cal_type%TYPE,
193: future_acad_ci_sequence_number igs_ad_ps_appl_inst_all.future_acad_ci_sequence_number%TYPE,
194: future_adm_cal_type igs_ad_ps_appl_inst_all.future_adm_cal_type%TYPE,
195: future_adm_ci_sequence_number igs_ad_ps_appl_inst_all.future_adm_ci_sequence_number%TYPE,
196: previous_term_adm_appl_number igs_ad_ps_appl_inst_all.PREVIOUS_TERM_ADM_APPL_NUMBER%TYPE,
197: previous_term_sequence_number igs_ad_ps_appl_inst_all.PREVIOUS_TERM_SEQUENCE_NUMBER%TYPE,
198: future_term_adm_appl_number igs_ad_ps_appl_inst_all.future_term_adm_appl_number%TYPE,
199: future_term_sequence_number igs_ad_ps_appl_inst_all.future_term_sequence_number%TYPE,
200: def_acad_cal_type igs_ad_ps_appl_inst_all.def_acad_cal_type%TYPE,
193: future_acad_ci_sequence_number igs_ad_ps_appl_inst_all.future_acad_ci_sequence_number%TYPE,
194: future_adm_cal_type igs_ad_ps_appl_inst_all.future_adm_cal_type%TYPE,
195: future_adm_ci_sequence_number igs_ad_ps_appl_inst_all.future_adm_ci_sequence_number%TYPE,
196: previous_term_adm_appl_number igs_ad_ps_appl_inst_all.PREVIOUS_TERM_ADM_APPL_NUMBER%TYPE,
197: previous_term_sequence_number igs_ad_ps_appl_inst_all.PREVIOUS_TERM_SEQUENCE_NUMBER%TYPE,
198: future_term_adm_appl_number igs_ad_ps_appl_inst_all.future_term_adm_appl_number%TYPE,
199: future_term_sequence_number igs_ad_ps_appl_inst_all.future_term_sequence_number%TYPE,
200: def_acad_cal_type igs_ad_ps_appl_inst_all.def_acad_cal_type%TYPE,
201: def_acad_ci_sequence_num igs_ad_ps_appl_inst_all.def_acad_ci_sequence_num%TYPE,
194: future_adm_cal_type igs_ad_ps_appl_inst_all.future_adm_cal_type%TYPE,
195: future_adm_ci_sequence_number igs_ad_ps_appl_inst_all.future_adm_ci_sequence_number%TYPE,
196: previous_term_adm_appl_number igs_ad_ps_appl_inst_all.PREVIOUS_TERM_ADM_APPL_NUMBER%TYPE,
197: previous_term_sequence_number igs_ad_ps_appl_inst_all.PREVIOUS_TERM_SEQUENCE_NUMBER%TYPE,
198: future_term_adm_appl_number igs_ad_ps_appl_inst_all.future_term_adm_appl_number%TYPE,
199: future_term_sequence_number igs_ad_ps_appl_inst_all.future_term_sequence_number%TYPE,
200: def_acad_cal_type igs_ad_ps_appl_inst_all.def_acad_cal_type%TYPE,
201: def_acad_ci_sequence_num igs_ad_ps_appl_inst_all.def_acad_ci_sequence_num%TYPE,
202: def_prev_term_adm_appl_num igs_ad_ps_appl_inst_all.def_prev_term_adm_appl_num%TYPE,
195: future_adm_ci_sequence_number igs_ad_ps_appl_inst_all.future_adm_ci_sequence_number%TYPE,
196: previous_term_adm_appl_number igs_ad_ps_appl_inst_all.PREVIOUS_TERM_ADM_APPL_NUMBER%TYPE,
197: previous_term_sequence_number igs_ad_ps_appl_inst_all.PREVIOUS_TERM_SEQUENCE_NUMBER%TYPE,
198: future_term_adm_appl_number igs_ad_ps_appl_inst_all.future_term_adm_appl_number%TYPE,
199: future_term_sequence_number igs_ad_ps_appl_inst_all.future_term_sequence_number%TYPE,
200: def_acad_cal_type igs_ad_ps_appl_inst_all.def_acad_cal_type%TYPE,
201: def_acad_ci_sequence_num igs_ad_ps_appl_inst_all.def_acad_ci_sequence_num%TYPE,
202: def_prev_term_adm_appl_num igs_ad_ps_appl_inst_all.def_prev_term_adm_appl_num%TYPE,
203: def_prev_appl_sequence_num igs_ad_ps_appl_inst_all.def_prev_appl_sequence_num%TYPE,
196: previous_term_adm_appl_number igs_ad_ps_appl_inst_all.PREVIOUS_TERM_ADM_APPL_NUMBER%TYPE,
197: previous_term_sequence_number igs_ad_ps_appl_inst_all.PREVIOUS_TERM_SEQUENCE_NUMBER%TYPE,
198: future_term_adm_appl_number igs_ad_ps_appl_inst_all.future_term_adm_appl_number%TYPE,
199: future_term_sequence_number igs_ad_ps_appl_inst_all.future_term_sequence_number%TYPE,
200: def_acad_cal_type igs_ad_ps_appl_inst_all.def_acad_cal_type%TYPE,
201: def_acad_ci_sequence_num igs_ad_ps_appl_inst_all.def_acad_ci_sequence_num%TYPE,
202: def_prev_term_adm_appl_num igs_ad_ps_appl_inst_all.def_prev_term_adm_appl_num%TYPE,
203: def_prev_appl_sequence_num igs_ad_ps_appl_inst_all.def_prev_appl_sequence_num%TYPE,
204: def_term_adm_appl_num igs_ad_ps_appl_inst_all.def_term_adm_appl_num%TYPE,
197: previous_term_sequence_number igs_ad_ps_appl_inst_all.PREVIOUS_TERM_SEQUENCE_NUMBER%TYPE,
198: future_term_adm_appl_number igs_ad_ps_appl_inst_all.future_term_adm_appl_number%TYPE,
199: future_term_sequence_number igs_ad_ps_appl_inst_all.future_term_sequence_number%TYPE,
200: def_acad_cal_type igs_ad_ps_appl_inst_all.def_acad_cal_type%TYPE,
201: def_acad_ci_sequence_num igs_ad_ps_appl_inst_all.def_acad_ci_sequence_num%TYPE,
202: def_prev_term_adm_appl_num igs_ad_ps_appl_inst_all.def_prev_term_adm_appl_num%TYPE,
203: def_prev_appl_sequence_num igs_ad_ps_appl_inst_all.def_prev_appl_sequence_num%TYPE,
204: def_term_adm_appl_num igs_ad_ps_appl_inst_all.def_term_adm_appl_num%TYPE,
205: def_appl_sequence_num igs_ad_ps_appl_inst_all.def_appl_sequence_num%TYPE,
198: future_term_adm_appl_number igs_ad_ps_appl_inst_all.future_term_adm_appl_number%TYPE,
199: future_term_sequence_number igs_ad_ps_appl_inst_all.future_term_sequence_number%TYPE,
200: def_acad_cal_type igs_ad_ps_appl_inst_all.def_acad_cal_type%TYPE,
201: def_acad_ci_sequence_num igs_ad_ps_appl_inst_all.def_acad_ci_sequence_num%TYPE,
202: def_prev_term_adm_appl_num igs_ad_ps_appl_inst_all.def_prev_term_adm_appl_num%TYPE,
203: def_prev_appl_sequence_num igs_ad_ps_appl_inst_all.def_prev_appl_sequence_num%TYPE,
204: def_term_adm_appl_num igs_ad_ps_appl_inst_all.def_term_adm_appl_num%TYPE,
205: def_appl_sequence_num igs_ad_ps_appl_inst_all.def_appl_sequence_num%TYPE,
206: appl_inst_status igs_ad_ps_appl_inst_all.appl_inst_status%TYPE,
199: future_term_sequence_number igs_ad_ps_appl_inst_all.future_term_sequence_number%TYPE,
200: def_acad_cal_type igs_ad_ps_appl_inst_all.def_acad_cal_type%TYPE,
201: def_acad_ci_sequence_num igs_ad_ps_appl_inst_all.def_acad_ci_sequence_num%TYPE,
202: def_prev_term_adm_appl_num igs_ad_ps_appl_inst_all.def_prev_term_adm_appl_num%TYPE,
203: def_prev_appl_sequence_num igs_ad_ps_appl_inst_all.def_prev_appl_sequence_num%TYPE,
204: def_term_adm_appl_num igs_ad_ps_appl_inst_all.def_term_adm_appl_num%TYPE,
205: def_appl_sequence_num igs_ad_ps_appl_inst_all.def_appl_sequence_num%TYPE,
206: appl_inst_status igs_ad_ps_appl_inst_all.appl_inst_status%TYPE,
207: ais_reason igs_ad_ps_appl_inst_all.ais_reason%TYPE,
200: def_acad_cal_type igs_ad_ps_appl_inst_all.def_acad_cal_type%TYPE,
201: def_acad_ci_sequence_num igs_ad_ps_appl_inst_all.def_acad_ci_sequence_num%TYPE,
202: def_prev_term_adm_appl_num igs_ad_ps_appl_inst_all.def_prev_term_adm_appl_num%TYPE,
203: def_prev_appl_sequence_num igs_ad_ps_appl_inst_all.def_prev_appl_sequence_num%TYPE,
204: def_term_adm_appl_num igs_ad_ps_appl_inst_all.def_term_adm_appl_num%TYPE,
205: def_appl_sequence_num igs_ad_ps_appl_inst_all.def_appl_sequence_num%TYPE,
206: appl_inst_status igs_ad_ps_appl_inst_all.appl_inst_status%TYPE,
207: ais_reason igs_ad_ps_appl_inst_all.ais_reason%TYPE,
208: decline_ofr_reason igs_ad_ps_appl_inst_all.decline_ofr_reason%TYPE);
201: def_acad_ci_sequence_num igs_ad_ps_appl_inst_all.def_acad_ci_sequence_num%TYPE,
202: def_prev_term_adm_appl_num igs_ad_ps_appl_inst_all.def_prev_term_adm_appl_num%TYPE,
203: def_prev_appl_sequence_num igs_ad_ps_appl_inst_all.def_prev_appl_sequence_num%TYPE,
204: def_term_adm_appl_num igs_ad_ps_appl_inst_all.def_term_adm_appl_num%TYPE,
205: def_appl_sequence_num igs_ad_ps_appl_inst_all.def_appl_sequence_num%TYPE,
206: appl_inst_status igs_ad_ps_appl_inst_all.appl_inst_status%TYPE,
207: ais_reason igs_ad_ps_appl_inst_all.ais_reason%TYPE,
208: decline_ofr_reason igs_ad_ps_appl_inst_all.decline_ofr_reason%TYPE);
209:
202: def_prev_term_adm_appl_num igs_ad_ps_appl_inst_all.def_prev_term_adm_appl_num%TYPE,
203: def_prev_appl_sequence_num igs_ad_ps_appl_inst_all.def_prev_appl_sequence_num%TYPE,
204: def_term_adm_appl_num igs_ad_ps_appl_inst_all.def_term_adm_appl_num%TYPE,
205: def_appl_sequence_num igs_ad_ps_appl_inst_all.def_appl_sequence_num%TYPE,
206: appl_inst_status igs_ad_ps_appl_inst_all.appl_inst_status%TYPE,
207: ais_reason igs_ad_ps_appl_inst_all.ais_reason%TYPE,
208: decline_ofr_reason igs_ad_ps_appl_inst_all.decline_ofr_reason%TYPE);
209:
210: c_pend_fut_rec c_pend_futrecTyp;
203: def_prev_appl_sequence_num igs_ad_ps_appl_inst_all.def_prev_appl_sequence_num%TYPE,
204: def_term_adm_appl_num igs_ad_ps_appl_inst_all.def_term_adm_appl_num%TYPE,
205: def_appl_sequence_num igs_ad_ps_appl_inst_all.def_appl_sequence_num%TYPE,
206: appl_inst_status igs_ad_ps_appl_inst_all.appl_inst_status%TYPE,
207: ais_reason igs_ad_ps_appl_inst_all.ais_reason%TYPE,
208: decline_ofr_reason igs_ad_ps_appl_inst_all.decline_ofr_reason%TYPE);
209:
210: c_pend_fut_rec c_pend_futrecTyp;
211:
204: def_term_adm_appl_num igs_ad_ps_appl_inst_all.def_term_adm_appl_num%TYPE,
205: def_appl_sequence_num igs_ad_ps_appl_inst_all.def_appl_sequence_num%TYPE,
206: appl_inst_status igs_ad_ps_appl_inst_all.appl_inst_status%TYPE,
207: ais_reason igs_ad_ps_appl_inst_all.ais_reason%TYPE,
208: decline_ofr_reason igs_ad_ps_appl_inst_all.decline_ofr_reason%TYPE);
209:
210: c_pend_fut_rec c_pend_futrecTyp;
211:
212: TYPE c_pend_fut_table IS TABLE OF c_pend_fut_rec%TYPE INDEX BY BINARY_INTEGER;
311: FROM igs_ad_appl_all
312: WHERE person_id = cp_person_id
313: AND admission_appl_number = cp_admission_appl_number;
314:
315: CURSOR c_get_inst_dtls(cp_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
316: cp_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
317: cp_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE) IS
318: SELECT apai.rowid,apai.*
319: FROM igs_ad_ps_appl_inst_all apai
312: WHERE person_id = cp_person_id
313: AND admission_appl_number = cp_admission_appl_number;
314:
315: CURSOR c_get_inst_dtls(cp_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
316: cp_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
317: cp_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE) IS
318: SELECT apai.rowid,apai.*
319: FROM igs_ad_ps_appl_inst_all apai
320: WHERE apai.person_id = cp_person_id
313: AND admission_appl_number = cp_admission_appl_number;
314:
315: CURSOR c_get_inst_dtls(cp_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
316: cp_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
317: cp_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE) IS
318: SELECT apai.rowid,apai.*
319: FROM igs_ad_ps_appl_inst_all apai
320: WHERE apai.person_id = cp_person_id
321: AND apai.admission_appl_number = cp_admission_appl_number
315: CURSOR c_get_inst_dtls(cp_person_id igs_ad_ps_appl_inst_all.person_id%TYPE,
316: cp_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
317: cp_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE) IS
318: SELECT apai.rowid,apai.*
319: FROM igs_ad_ps_appl_inst_all apai
320: WHERE apai.person_id = cp_person_id
321: AND apai.admission_appl_number = cp_admission_appl_number
322: AND apai.nominated_course_cd = cp_nominated_course_cd
323: AND NVL(apai.appl_inst_status,'RECEIVED') NOT IN (SELECT adm_appl_status FROM igs_ad_appl_stat WHERE S_ADM_APPL_STATUS = 'WITHDRAWN');