APPS.IGS_GR_VAL_ACUS SQL Statements

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

Line: 20

  		SELECT	acusg.closed_ind
  		FROM	IGS_GR_AWD_CRM_US_GP 	acusg
  		WHERE	acusg.grd_cal_type		= p_grd_cal_type and
  			acusg.grd_ci_sequence_number 	= p_grd_ci_sequence_number and
  			acusg.ceremony_number 		= p_ceremony_number and
  			acusg.award_course_cd 		= p_award_course_cd and
  			acusg.award_crs_version_number 	=p_award_crs_version_number and
  			acusg.award_cd			= p_award_cd and
  			acusg.us_group_number 		= p_us_group_number and
  			acusg.closed_ind 		='Y';

Line: 76

  		SELECT	'X'
  		FROM	IGS_AS_SU_SETATMPT	susa
  		WHERE	susa.unit_set_cd		= p_unit_set_cd AND
  			susa.us_version_number		= p_us_version_number AND
  			susa.primary_set_ind		= 'Y';

Line: 119

  		SELECT	'X'
  		FROM	IGS_GR_AWD_CEREMONY			awc
  		WHERE	awc.grd_cal_type		= p_grd_cal_type 	AND
  			awc.grd_ci_sequence_number 	= p_grd_ci_sequence_number AND
  			awc.ceremony_number 		= p_ceremony_number AND
  			NVL(awc.award_course_cd, 'NULL')= NVL(p_award_course_cd, 'NULL') AND
  			NVL(awc.award_crs_version_number, 0) =
  					NVL(p_award_crs_version_number, 0) AND
  			awc.award_cd			= p_award_cd AND
  			awc.closed_ind			= 'Y';

Line: 175

  		SELECT	'x'
  		FROM	IGS_EN_UNIT_SET			us
  		WHERE	us.unit_set_cd		= p_unit_set_cd AND
  			us.version_number		= p_us_version_number AND
  			us.administrative_ind	= 'N';

Line: 181

  		SELECT	'x'
  		FROM	IGS_PS_OFR_UNIT_SET	cous
  		WHERE	cous.course_cd		= p_award_course_cd		AND
  			cous.crv_version_number	= p_award_crs_version_number	AND
  			cous.unit_set_cd	= p_unit_set_cd			AND
  			cous.us_version_number	= p_us_version_number;