APPS.IGS_AD_GEN_004 dependencies on IGS_AD_PRCS_CAT_STEP

Line 59: FROM IGS_AD_PRCS_CAT_STEP

55: -- Retrieve the admission process category steps.
56: CURSOR c_apcs IS
57: SELECT s_admission_step_type,
58: step_type_restriction_num
59: FROM IGS_AD_PRCS_CAT_STEP
60: WHERE admission_cat = p_admission_cat AND
61: s_admission_process_type = p_s_admission_process_type AND
62: step_group_type <> 'TRACK'; --2402377
63: BEGIN

Line 91: --Loop through each IGS_AD_PRCS_CAT_STEP record

87: p_apcs_outcome_lt_ind :='N';
88: p_apcs_pre_enrol_ind :='N';
89: p_apcs_un_dob_ind :='N';
90: p_apcs_un_title_ind :='N';
91: --Loop through each IGS_AD_PRCS_CAT_STEP record
92: FOR v_apcs_rec IN c_apcs LOOP
93: IF (v_apcs_rec.s_admission_step_type = 'PREF-LIMIT') THEN
94: p_apcs_pref_limit_ind := 'Y';
95: ELSIF (v_apcs_rec.s_admission_step_type = 'APP-FEE') THEN