APPS.IGS_AD_CANCEL_RECONSIDER dependencies on IGS_AD_PRCS_CAT_V

Line 306: l_get_adm_process_type igs_ad_prcs_cat_v.meaning%TYPE;

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;
307:
308: CURSOR c_get_application_id (cp_person_id igs_ad_appl_all.person_id%TYPE,
309: cp_admission_appl_number igs_ad_appl_all.admission_appl_number%TYPE) IS
310: SELECT application_id