APPS.IGS_PS_VAL_COUS SQL Statements

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

Line: 27

  		SELECT	crv.course_type
  		FROM	IGS_PS_VER	crv
  		WHERE	crv.course_cd		= p_course_cd AND
  			crv.version_number	= p_crv_version_number;

Line: 33

  		SELECT	usctv.course_type
  		FROM	IGS_EN_UNIT_SET_COURSE_TYPE_V	usctv
  		WHERE	usctv.course_type	= cp_course_type AND
  			usctv.unit_set_cd	= p_unit_set_cd AND
  			usctv.version_number	= p_us_version_number;

Line: 90

  		SELECT	'x'
  		FROM	IGS_PS_OF_UNT_SET_RL	cousr
  		WHERE	cousr.course_cd			= p_course_cd AND
  			cousr.crv_version_number	= p_crv_version_number AND
  			cousr.cal_type			= p_cal_type AND
  			cousr.sup_unit_set_cd		= p_unit_set_cd AND
  			cousr.sup_us_version_number	= p_us_version_number;

Line: 98

  		SELECT	'x'
  		FROM	IGS_PS_COO_AD_UNIT_S		cacus
  		WHERE	cacus.course_cd			= p_course_cd AND
  			cacus.crv_version_number	= p_crv_version_number AND
  			cacus.cal_type			= p_cal_type AND
  			cacus.unit_set_cd		= p_unit_set_cd AND
  			cacus.us_version_number		= p_us_version_number;