APPS.IGS_AD_VAL_ECM SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 52

  		SELECT	ecm.dflt_cat_ind
  		FROM	IGS_EN_CAT_MAPPING ecm
  		WHERE	ecm.admission_cat = cp_admission_cat;

Line: 101

  		SELECT	ecm.dflt_cat_ind
  		FROM	IGS_EN_CAT_MAPPING ecm
  		WHERE	ecm.admission_cat = cp_admission_cat AND
  			ecm.enrolment_cat <> cp_enrolment_cat AND
  			ecm.dflt_cat_ind = cst_yes;

Line: 136

  		SELECT 	closed_ind
  		FROM		IGS_EN_ENROLMENT_CAT
  		WHERE	enrolment_cat = p_enrolment_cat;