APPS.IGS_UC_EXP_APPLICANT_DTLS dependencies on IGS_UC_APP_CHOICES

Line 318: FROM IGS_UC_APP_CHOICES

314: -- retrieves application system codes and entry years from their
315: -- application choices
316: CURSOR cur_get_syscode_entryyr(cp_app_no igs_uc_applicants.app_no%TYPE ) IS
317: SELECT system_code, entry_year
318: FROM IGS_UC_APP_CHOICES
319: WHERE app_no = cp_app_no
320: ORDER BY entry_year;
321:
322: -- local variables required

Line 323: l_appl_sys_code IGS_UC_APP_CHOICES.system_code%TYPE;

319: WHERE app_no = cp_app_no
320: ORDER BY entry_year;
321:
322: -- local variables required
323: l_appl_sys_code IGS_UC_APP_CHOICES.system_code%TYPE;
324: l_appl_entry_yr IGS_UC_APP_CHOICES.entry_year%TYPE;
325: l_found_term BOOLEAN;
326: l_count NUMBER;
327:

Line 324: l_appl_entry_yr IGS_UC_APP_CHOICES.entry_year%TYPE;

320: ORDER BY entry_year;
321:
322: -- local variables required
323: l_appl_sys_code IGS_UC_APP_CHOICES.system_code%TYPE;
324: l_appl_entry_yr IGS_UC_APP_CHOICES.entry_year%TYPE;
325: l_found_term BOOLEAN;
326: l_count NUMBER;
327:
328: BEGIN