APPS.IGS_AD_VAL_FCM SQL Statements

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

Line: 54

  		SELECT	fcm.dflt_cat_ind
  		FROM	IGS_FI_FEE_CAT_MAP fcm
  		WHERE	fcm.admission_cat = cp_admission_cat;

Line: 104

  		SELECT	fcm.dflt_cat_ind
  		FROM	IGS_FI_FEE_CAT_MAP fcm
  		WHERE	fcm.admission_cat = cp_admission_cat AND
  			fcm.fee_cat <> cp_fee_cat AND
  			fcm.dflt_cat_ind = cst_yes;

Line: 141

                SELECT  fc.closed_ind
                FROM    IGS_FI_FEE_CAT fc
                WHERE   fc.fee_cat = p_fee_cat;