APPS.IGS_CA_VAL_CAT SQL Statements

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

Line: 14

  		SELECT  DISTINCT 'x'
  		FROM	IGS_CA_INST ci,
  			IGS_CA_STAT cs
  		WHERE 	ci.CAL_TYPE     = cp_cal_type   AND
  			cs.CAL_STATUS   = ci.CAL_STATUS AND
  			cs.s_cal_status IN (cst_active, cst_inactive);

Line: 59

  		SELECT	atctc.closed_ind
  		FROM	IGS_CA_ARTS_TC_CA_CD	atctc
  		WHERE	atctc.ARTS_TEACHING_CAL_TYPE_CD = p_arts_teaching_cal_type_cd;