CREATE PROC dbo.WEPDEN_SIL(@KOD VARCHAR(100)) AS
BEGIN 
DECLARE @LOGREF INT 
SET @LOGREF=ISNULL((SELECT LOGICALREF FROM LG_011_ITEMS WHERE CODE=@KOD),0)
UPDATE LG_011_ITEMS SET ACTIVE=1 WHERE LOGICALREF=@LOGREF 
UPDATE LG_011_PRCLIST SET ACTIVE=1 WHERE PTYPE=2 AND CARDREF = @LOGREF
END