APPS.IGS_UC_UPD_PENDING_TRANS_PKG dependencies on IGS_UC_APPLICANTS

Line 114: CURSOR c_appno(cp_appno igs_uc_applicants.app_no%TYPE) IS

110:
111: c_tranin_info_rec c_tranin_info%ROWTYPE;
112:
113: -- Cursor to convert 8-digit appno to 9 digit NUMBER with check digit for UCAS 2006 Cycle Support
114: CURSOR c_appno(cp_appno igs_uc_applicants.app_no%TYPE) IS
115: SELECT TO_NUMBER(APP_NO || CHECK_DIGIT)
116: FROM IGS_UC_APPLICANTS
117: WHERE APP_NO = CP_APPNO;
118:

Line 116: FROM IGS_UC_APPLICANTS

112:
113: -- Cursor to convert 8-digit appno to 9 digit NUMBER with check digit for UCAS 2006 Cycle Support
114: CURSOR c_appno(cp_appno igs_uc_applicants.app_no%TYPE) IS
115: SELECT TO_NUMBER(APP_NO || CHECK_DIGIT)
116: FROM IGS_UC_APPLICANTS
117: WHERE APP_NO = CP_APPNO;
118:
119: l_soc igs_uc_transactions.SOC%TYPE;
120: l_entry_year igs_uc_defaults.configured_cycle%TYPE;