APPS.IGS_AD_APP_REQ_PKG dependencies on IGS_AD_APPL_STAT

Line 140: FROM igs_ad_appl_stat

136: -- Cursor to get the application processing status for an application
137: CURSOR c_appl_status (cp_person_id igs_ad_app_req.person_id%TYPE,
138: cp_admission_appl_number igs_ad_app_req.admission_appl_number%TYPE) IS
139: SELECT s_adm_appl_status
140: FROM igs_ad_appl_stat
141: WHERE adm_appl_status = ( SELECT adm_appl_status
142: FROM igs_ad_appl
143: WHERE person_id = cp_person_id
144: AND admission_appl_number = cp_admission_appl_number );