296:
297: l_acad_alternate_code igs_ca_inst_all.alternate_code%TYPE;
298: l_adm_alternate_code igs_ca_inst_all.alternate_code%TYPE;
299:
300: CURSOR c_get_adm_process_type (cp_s_admission_process_type igs_lookup_values.lookup_code%TYPE) IS
301: SELECT meaning
302: FROM igs_lookup_values
303: WHERE lookup_type = 'ADMISSION_PROCESS_TYPE'
304: AND lookup_code = cp_s_admission_process_type;
298: l_adm_alternate_code igs_ca_inst_all.alternate_code%TYPE;
299:
300: CURSOR c_get_adm_process_type (cp_s_admission_process_type igs_lookup_values.lookup_code%TYPE) IS
301: SELECT meaning
302: FROM igs_lookup_values
303: WHERE lookup_type = 'ADMISSION_PROCESS_TYPE'
304: AND lookup_code = cp_s_admission_process_type;
305:
306: l_get_adm_process_type igs_ad_prcs_cat_v.meaning%TYPE;