APPS.IGS_AD_VAL_ACAI dependencies on IGS_EN_CAT_MAPPING

Line 853: FROM IGS_EN_CAT_MAPPING

849: ORDER BY ci.start_dt DESC;
850: CURSOR c_ecm (
851: cp_enrolment_cat IGS_AS_SC_ATMPT_ENR.enrolment_cat%TYPE) IS
852: SELECT 'x'
853: FROM IGS_EN_CAT_MAPPING
854: WHERE admission_cat = p_admission_cat AND
855: enrolment_cat = cp_enrolment_cat ;
856: cst_error CONSTANT VARCHAR2(1) := 'E';
857: cst_warn CONSTANT VARCHAR2(1) := 'W';

Line 2640: FROM IGS_EN_CAT_MAPPING

2636: -- existing course attempts the student may have
2637: DECLARE
2638: CURSOR c_ccm IS
2639: Select 'x'
2640: FROM IGS_EN_CAT_MAPPING
2641: WHERE enrolment_cat = p_enrolment_cat AND
2642: admission_cat = p_admission_cat;
2643: v_x VARCHAR2(1) := NULL;
2644: v_message_name VARCHAR2(30);