APPS.IGS_CA_VAL_CI SQL Statements

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

Line: 21

  		SELECT 	'X'
  		FROM	IGS_CA_STAT	cs
  		WHERE	cs.cal_status	= p_cal_status AND
  			cs.closed_ind	= 'Y';

Line: 60

  		SELECT	CAT.s_cal_cat
  		FROM	IGS_CA_TYPE CAT
  		WHERE	CAT.cal_type = cp_cal_type;

Line: 135

  	SELECT 	*
  	FROM	IGS_CA_STAT
  	WHERE	cal_status = cp_cal_status;

Line: 140

  	SELECT 	*
  	FROM	IGS_CA_INST_REL
  	WHERE	sup_cal_type = p_cal_type AND
  		sup_ci_sequence_number = p_sequence_number;

Line: 146

  	SELECT 	*
  	FROM	IGS_CA_INST_REL
  	WHERE	sub_cal_type = p_cal_type AND
  		sub_ci_sequence_number = p_sequence_number;

Line: 152

  	SELECT 	*
  	FROM	IGS_CA_DA_INST_V
  	WHERE	cal_type = p_cal_type AND
  		ci_sequence_number = p_sequence_number;

Line: 159

  	SELECT 	*
  	FROM	IGS_CA_INST
  	WHERE	cal_type = cp_cal_type AND
  		sequence_number = cp_sequence_number;

Line: 346

  	SELECT 	*
  	FROM	IGS_CA_INST
  	WHERE	cal_type = cp_cal_type
  	AND	sequence_number = cp_cal_sequence_number ;

Line: 354

  	SELECT 	*
  	FROM	IGS_CA_INST_REL
  	WHERE	sub_cal_type = cp_sub_cal_type
  	AND	sub_ci_sequence_number = cp_sub_ci_sequence_number;

Line: 362

  	SELECT 	*
  	FROM	IGS_CA_INST_REL
  	WHERE	sup_cal_type = cp_sup_cal_type
  	AND	sup_ci_sequence_number = cp_sup_ci_sequence_number;

Line: 369

  	SELECT 	*
  	FROM	IGS_CA_TYPE
  	WHERE	cal_type = cp_cal_type
  	AND	s_cal_cat = cst_academic_period;

Line: 376

  	SELECT 	*
  	FROM	IGS_CA_TYPE
  	WHERE	cal_type = cp_cal_type
  	AND	s_cal_cat = cst_teaching_period;