DBA Data[Home] [Help]

APPS.IGS_PS_VAL_TRO SQL Statements

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

Line: 20

  		SELECT	SUM(tro.percentage)
  		FROM	IGS_PS_TCH_RESP_OVRD tro
  		WHERE	tro.unit_cd		= p_unit_cd AND
  			tro.version_number	= p_version_number AND
  			tro.cal_type		= p_cal_type AND
  			tro.ci_sequence_number	= p_ci_sequence_number AND
  			tro.location_cd		= p_location_cd AND
  			tro.unit_class		= p_unit_class;