APPS.IGS_AD_CANCEL_RECONSIDER dependencies on IGS_AD_PRCS_CAT_STEP

Line 379: CURSOR c_apcs(cp_admission_cat IGS_AD_PRCS_CAT_STEP.admission_cat%TYPE, cp_s_admission_process_type IGS_AD_PRCS_CAT_STEP.s_admission_process_type%TYPE) IS

375: WHERE admission_application_type = cp_admission_type;
376:
377: l_admission_type c_admission_type%ROWTYPE;
378:
379: CURSOR c_apcs(cp_admission_cat IGS_AD_PRCS_CAT_STEP.admission_cat%TYPE, cp_s_admission_process_type IGS_AD_PRCS_CAT_STEP.s_admission_process_type%TYPE) IS
380: SELECT 'Y'
381: FROM IGS_AD_PRCS_CAT_STEP
382: WHERE admission_cat = cp_admission_cat
383: AND s_admission_process_type = cp_s_admission_process_type

Line 381: FROM IGS_AD_PRCS_CAT_STEP

377: l_admission_type c_admission_type%ROWTYPE;
378:
379: CURSOR c_apcs(cp_admission_cat IGS_AD_PRCS_CAT_STEP.admission_cat%TYPE, cp_s_admission_process_type IGS_AD_PRCS_CAT_STEP.s_admission_process_type%TYPE) IS
380: SELECT 'Y'
381: FROM IGS_AD_PRCS_CAT_STEP
382: WHERE admission_cat = cp_admission_cat
383: AND s_admission_process_type = cp_s_admission_process_type
384: AND s_admission_step_type = 'PRE-ENROL'
385: AND step_group_type <> 'TRACK';