DBA Data[Home] [Help]

APPS.IGS_PS_VAL_CALUL SQL Statements

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

Line: 12

  		SELECT	'x'
  		FROM	IGS_PS_UNIT_VER
  		WHERE	unit_cd		= p_unit_cd	AND
  			version_number	= p_version_number;
Line: 44

  		SELECT	s_unit_status
  		FROM	IGS_PS_UNIT_VER,
  			IGS_PS_UNIT_STAT
  		WHERE	unit_cd			= p_unit_cd		AND
  			version_number		= p_version_number	AND
  			IGS_PS_UNIT_VER.unit_status	= IGS_PS_UNIT_STAT.unit_status;