APPS.IGS_PRECREATE_APPL_PUB dependencies on IGS_AD_SS_APPL_TYP

Line 111: CURSOR c_apptype(p_app_type igs_ad_ss_appl_typ.admission_application_type%TYPE) IS

107: WHERE class = 'SPECIAL_GROUP2' AND
108: code_id = p_spcl_grp2;
109:
110: -- Cursor to validate Admission Application Type
111: CURSOR c_apptype(p_app_type igs_ad_ss_appl_typ.admission_application_type%TYPE) IS
112: SELECT admission_application_type, admission_cat, s_admission_process_type
113: FROM igs_ad_ss_appl_typ
114: WHERE admission_application_type = p_app_type;
115:

Line 113: FROM igs_ad_ss_appl_typ

109:
110: -- Cursor to validate Admission Application Type
111: CURSOR c_apptype(p_app_type igs_ad_ss_appl_typ.admission_application_type%TYPE) IS
112: SELECT admission_application_type, admission_cat, s_admission_process_type
113: FROM igs_ad_ss_appl_typ
114: WHERE admission_application_type = p_app_type;
115:
116: -- Cursor to validate whether the Application Type is available in the current Admission Calendar
117: CURSOR c_apptype_admcal(p_adm_cal_type IGS_AD_PRD_AD_PRC_CA.adm_cal_type%TYPE,p_adm_cal_seq IGS_AD_PRD_AD_PRC_CA.adm_ci_sequence_number%TYPE,