APPS.IGS_AD_VAL_CCM SQL Statements

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

Line: 62

  		SELECT	ccm.dflt_cat_ind
  		FROM	IGS_CO_CAT_MAP ccm
  		WHERE	ccm.admission_cat = cp_admission_cat;

Line: 115

  		SELECT	ccm.dflt_cat_ind
  		FROM	IGS_CO_CAT_MAP ccm
  		WHERE	ccm.admission_cat = cp_admission_cat AND
  			ccm.correspondence_cat <> cp_correspondence_cat AND
  			ccm.dflt_cat_ind = cst_yes;