APPS.IGS_AS_VAL_UAPI SQL Statements

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

Line: 29

  		SELECT 	uap.location_cd,
  			uap.unit_class,
  		      uap.unit_mode
  		FROM	IGS_AS_UNTAS_PATTERN uap
  		WHERE	uap.ass_pattern_id = p_ass_pattern_id;

Line: 35

  		SELECT 	uai.location_cd,
  			uai.unit_class,
  		      uai.unit_mode
  		FROM	IGS_AS_UNITASS_ITEM uai
  		WHERE	uai.unit_cd 		= p_unit_cd 		AND
  			uai.version_number 	= p_version_number 	AND
  			uai.cal_type 		= p_cal_type 		AND
  			uai.ci_sequence_number 	= p_ci_sequence_number 	AND
  			uai.ass_id 		= p_ass_id 		AND
  			uai.sequence_number 	= p_uai_sequence_number;

Line: 104

  	SELECT	NVL(SUM(uapi.apportionment_percentage), 0)
  	FROM	IGS_AS_UNT_PATRN_ITM uapi
  	WHERE	uapi.unit_cd		= p_unit_cd 		AND
  		uapi.version_number	= p_version_number	AND
  		uapi.cal_type		= p_cal_type		AND
  		uapi.ci_sequence_number	= p_ci_sequence_number	AND
  		uapi.ass_pattern_id	= p_ass_pattern_id;