116:
117:
118: l_admission_cat igs_ad_appl_all.admission_cat%TYPE;
119: l_s_admission_process_type igs_ad_appl_all.s_admission_process_type%TYPE;
120: l_acad_cal_type igs_ca_inst_all.cal_type%TYPE;
121: l_acad_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE;
122: l_adm_cal_type igs_ca_inst_all.cal_type%TYPE;
123: l_adm_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE;
124: l_country igs_or_inst_addr.country%TYPE;
117:
118: l_admission_cat igs_ad_appl_all.admission_cat%TYPE;
119: l_s_admission_process_type igs_ad_appl_all.s_admission_process_type%TYPE;
120: l_acad_cal_type igs_ca_inst_all.cal_type%TYPE;
121: l_acad_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE;
122: l_adm_cal_type igs_ca_inst_all.cal_type%TYPE;
123: l_adm_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE;
124: l_country igs_or_inst_addr.country%TYPE;
125: l_state igs_or_inst_addr.state%TYPE;
118: l_admission_cat igs_ad_appl_all.admission_cat%TYPE;
119: l_s_admission_process_type igs_ad_appl_all.s_admission_process_type%TYPE;
120: l_acad_cal_type igs_ca_inst_all.cal_type%TYPE;
121: l_acad_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE;
122: l_adm_cal_type igs_ca_inst_all.cal_type%TYPE;
123: l_adm_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE;
124: l_country igs_or_inst_addr.country%TYPE;
125: l_state igs_or_inst_addr.state%TYPE;
126: l_postal_code igs_or_inst_addr.postal_code%TYPE;
119: l_s_admission_process_type igs_ad_appl_all.s_admission_process_type%TYPE;
120: l_acad_cal_type igs_ca_inst_all.cal_type%TYPE;
121: l_acad_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE;
122: l_adm_cal_type igs_ca_inst_all.cal_type%TYPE;
123: l_adm_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE;
124: l_country igs_or_inst_addr.country%TYPE;
125: l_state igs_or_inst_addr.state%TYPE;
126: l_postal_code igs_or_inst_addr.postal_code%TYPE;
127: l_pe_country igs_pe_addr_v.country_cd%TYPE;