SELECT [IDX_NAME] FROM [TOP_VIRTUALIDX] WHERE [IDX_ENV]=@1 AND [IDX_NAME]=@2

UPDATE [dbo].[FWTSFWSCHDSMART_EXECUTE] set [D_E_L_E_T_] = @1,[R_E_C_D_E_L_] = [R_E_C_N_O_]  WHERE [R_E_C_N_O_]=@2

SELECT [TSK_PARM] FROM [dbo].[SCHDTSK] WHERE [R_E_C_N_O_]=@1

SELECT [XX1_PARAM] FROM [dbo].[XX1] WHERE [R_E_C_N_O_]=@1

UPDATE F75010 SET S_T_A_M_P_ = GETUTCDATE()  WHERE R_E_C_N_O_ IN ( SELECT R_E_C_N_O_ FROM INSERTED )

UPDATE [dbo].[SYS_USR_LOGIN] set [USR_HRLOGON] = @1  WHERE [R_E_C_N_O_]=@2

SELECT [XX1_DESCR] FROM [dbo].[XX1] WHERE [R_E_C_N_O_]=@1

SELECT [TSK_PARM] FROM [dbo].[SCHDTSK] WHERE [R_E_C_N_O_]=@1

SELECT [XX1_RECORR] FROM [dbo].[XX1] WHERE [R_E_C_N_O_]=@1

SELECT 
            @reservedpages = SUM (reserved_page_count),
            @usedpages = SUM (used_page_count),
            @pages = SUM (
                CASE
                    WHEN (index_id < 2) THEN (in_row_data_page_count + lob_used_page_count + row_overflow_used_page_count)
                    ELSE 0
                END
                ),
            @rowCount = SUM (
                CASE
                    WHEN (index_id < 2) THEN row_count
                    ELSE 0
                END
                )
        FROM sys.dm_db_partition_stats
        WHERE object_id = @id

SELECT [IDX_NAME] FROM [TOP_VIRTUALIDX] WHERE [IDX_ENV]=@1 AND [IDX_NAME]=@2

UPDATE [dbo].[FWTSFWSCHDSMART_EXECUTE] set [D_E_L_E_T_] = @1,[R_E_C_D_E_L_] = [R_E_C_N_O_]  WHERE [R_E_C_N_O_]=@2

SELECT [TSK_PARM] FROM [dbo].[SCHDTSK] WHERE [R_E_C_N_O_]=@1

UPDATE F75010 SET S_T_A_M_P_ = GETUTCDATE()  WHERE R_E_C_N_O_ IN ( SELECT R_E_C_N_O_ FROM INSERTED )

SELECT [XX1_PARAM] FROM [dbo].[XX1] WHERE [R_E_C_N_O_]=@1

DELETE [SYS_APP_PARAM]  WHERE [APP_PARAM]=@1

UPDATE [dbo].[SYS_USR_LOGIN] set [USR_HRLOGON] = @1  WHERE [R_E_C_N_O_]=@2

SELECT [XX1_DESCR] FROM [dbo].[XX1] WHERE [R_E_C_N_O_]=@1

INSERT INTO SN4010 (N4_FILIAL , N4_CBASE , N4_ITEM , N4_TIPO , N4_OCORR , N4_MOTIVO , N4_TIPOCNT , N4_CONTA , N4_DATA , 
          N4_QUANTD , N4_VLROC1 , N4_VLROC2 , N4_VLROC3 , N4_VLROC4 , N4_VLROC5 , N4_SERIE , N4_NOTA , N4_VENDA , N4_TXMEDIA , 
          N4_TXDEPR , N4_CCUSTO , N4_LOCAL , N4_SEQ , N4_SUBCTA , N4_SEQREAV , N4_CODBAIX , N4_FILORIG , N4_CLVL , N4_DCONTAB , 
          R_E_C_N_O_ , N4_TPSALDO , N4_QUANTPR , N4_CALCPIS , N4_IDMOV , N4_ORIGEM , N4_LP , N4_LA ) 
   VALUES (@IN_FILIAL , @IN_CBASE , @IN_ITEM , @IN_TIPO , @IN_OCORR , @IN_MOTIVO , @IN_TIPOCNT , @IN_CONTA , @IN_DATA , @nQUANTD , 
          @nVLROC1 , @nVLROC2 , @nVLROC3 , @nVLROC4 , @nVLROC5 , @IN_SERIE , @IN_NOTA , @nVENDA , @nTXMEDIA , @nTXDEPR , 
          @IN_CCUSTO , @IN_LOCAL , @IN_SEQ , @IN_SUBCTA , @IN_SEQREAV , @IN_CODBAIX , @IN_FILORIG , @IN_CLVL , @IN_DCONTAB , 
          @iRecno , @IN_TPSALDO , @IN_QUANTPR , @IN_CALCPIS , @IN_IDMOV , 'ATFA050' , '820' , 'N' )

SELECT [TSK_PARM] FROM [dbo].[SCHDTSK] WHERE [R_E_C_N_O_]=@1

SELECT I_ID, I_TP_MENU, I_ITEMID, I_FATHER, F_FUNCTION, I_STATUS, I_ORDER, I_ACCESS, I_DEFAULT, I_RESNAME, I_TYPE, I_OWNER, F_DEFAULT, I_MODULE, I18N1.N_DESC N_PT, I18N2.N_DESC N_ES, I18N3.N_DESC N_EN, KW1.K_DESC K_PT, KW2.K_DESC K_ES, KW3.K_DESC K_EN, I_TABLE_M TABLES FROM MPMENU_MENU MPN INNER JOIN MPMENU_ITEM MPI ON I_ID_MENU = M_ID AND MPI.D_E_L_E_T_ = ' ' INNER JOIN MPMENU_I18N I18N1 ON I18N1.N_PAREN_ID = I_ID AND I18N1.N_LANG = '1' AND I18N1.D_E_L_E_T_ = ' ' INNER JOIN MPMENU_I18N I18N2 ON I18N2.N_PAREN_ID = I_ID AND I18N2.N_LANG = '2' AND I18N2.D_E_L_E_T_ = ' ' INNER JOIN MPMENU_I18N I18N3 ON I18N3.N_PAREN_ID = I_ID AND I18N3.N_LANG = '3' AND I18N3.D_E_L_E_T_ = ' ' LEFT JOIN MPMENU_FUNCTION MPF ON F_ID = I_ID_FUNC AND MPF.D_E_L_E_T_ = ' ' LEFT JOIN MPMENU_KEY_WORDS KW1 ON KW1.K_ID_ITEM = I_ID AND KW1.K_LANG = '1' AND KW1.D_E_L_E_T_ = ' ' LEFT JOIN MPMENU_KEY_WORDS KW2 ON KW2.K_ID_ITEM = I_ID AND KW2.K_LANG = '2' AND KW2.D_E_L_E_T_ = ' ' LEFT JOIN MPMENU_KEY_WORDS KW3 ON KW3.K_ID_ITEM = I_ID AND KW3.K_LANG = '3' AND KW3.D_E_L_E_T_ = ' ' WHERE M_ID = @P1 AND MPN.D_E_L_E_T_ = ' ' ORDER BY I_ORDER

UPDATE F75010 SET S_T_A_M_P_ = GETUTCDATE()  WHERE R_E_C_N_O_ IN ( SELECT R_E_C_N_O_ FROM INSERTED )

UPDATE F76010 SET S_T_A_M_P_ = GETUTCDATE()  WHERE R_E_C_N_O_ IN ( SELECT R_E_C_N_O_ FROM INSERTED )

UPDATE SE2010 SET S_T_A_M_P_ = GETUTCDATE()  WHERE R_E_C_N_O_ IN ( SELECT R_E_C_N_O_ FROM INSERTED )

UPDATE CTK010 SET S_T_A_M_P_ = GETUTCDATE()  WHERE R_E_C_N_O_ IN ( SELECT R_E_C_N_O_ FROM INSERTED )

INSERT INTO SYS_USR_LOGIN_TTAT_LOG VALUES ( 'USR_HRLOGON', @COLD, @CNEW, 'C', @NRECNONEW, @CUSER, @CID, @CLOGIN, @CHOST, @CPROGRAM, @COPERA, @CDELNEW, @DDATASTAMP, @CMD5, @CUNICKEY )

DELETE FROM CQ3010  WHERE CQ3_FILIAL  = @IN_FILIAL  and ROUND ( CQ3_DEBITO , 2 ) = 0.00  and ROUND ( CQ3_CREDIT , 2 ) = 0.00 
         and CQ3_DATA  = @IN_DATA  and  ( (CQ3_CONTA  = @IN_CONTAC  and CQ3_CCUSTO  = @IN_CUSTOC )  or  (CQ3_CONTA  = @IN_CONTAD 
         and CQ3_CCUSTO  = @IN_CUSTOD ) )  and CQ3_TPSALD  = @IN_TPSALDO  and CQ3_MOEDA  = @IN_MOEDA  and CQ3_LP  = @cLp 
         and D_E_L_E_T_  = ' '

UPDATE SE1010 SET S_T_A_M_P_ = GETUTCDATE()  WHERE R_E_C_N_O_ IN ( SELECT R_E_C_N_O_ FROM INSERTED )

UPDATE SC7010 SET S_T_A_M_P_ = GETUTCDATE()  WHERE R_E_C_N_O_ IN ( SELECT R_E_C_N_O_ FROM INSERTED )

UPDATE SEA010 SET S_T_A_M_P_ = GETUTCDATE()  WHERE R_E_C_N_O_ IN ( SELECT R_E_C_N_O_ FROM INSERTED )

SELECT @cModo  = X2_MODO , @cModoUn  = X2_MODOUN , @cModoEmp  = X2_MODOEMP , @iTamFil  = X2_TAMFIL , @iTamUn  = X2_TAMUN 
     , @iTamEmp  = X2_TAMEMP 
     FROM SX2010 
     WHERE X2_CHAVE  = @IN_ALIAS  and D_E_L_E_T_  = ' '

UPDATE F75010 SET S_T_A_M_P_ = GETUTCDATE()  WHERE R_E_C_N_O_ IN ( SELECT R_E_C_N_O_ FROM INSERTED )

INSERT INTO SYS_USR_LOGIN_TTAT_LOG VALUES ( 'USR_HRLOGON', @COLD, @CNEW, 'C', @NRECNONEW, @CUSER, @CID, @CLOGIN, @CHOST, @CPROGRAM, @COPERA, @CDELNEW, @DDATASTAMP, @CMD5, @CUNICKEY )

UPDATE F76010 SET S_T_A_M_P_ = GETUTCDATE()  WHERE R_E_C_N_O_ IN ( SELECT R_E_C_N_O_ FROM INSERTED )

UPDATE SE2010 SET S_T_A_M_P_ = GETUTCDATE()  WHERE R_E_C_N_O_ IN ( SELECT R_E_C_N_O_ FROM INSERTED )

UPDATE SE1010 SET S_T_A_M_P_ = GETUTCDATE()  WHERE R_E_C_N_O_ IN ( SELECT R_E_C_N_O_ FROM INSERTED )

UPDATE CTK010 SET S_T_A_M_P_ = GETUTCDATE()  WHERE R_E_C_N_O_ IN ( SELECT R_E_C_N_O_ FROM INSERTED )

UPDATE SBZ010 SET S_T_A_M_P_ = GETUTCDATE()  WHERE R_E_C_N_O_ IN ( SELECT R_E_C_N_O_ FROM INSERTED )

SELECT @iRecno  = COALESCE ( MIN ( R_E_C_N_O_ ), 0 )
        FROM CQ7010 
        WHERE CQ7_FILIAL  = @IN_FILIAL  and CQ7_CONTA  = @IN_CONTAD  and CQ7_CCUSTO  = @IN_CUSTOD  and CQ7_ITEM  = @IN_ITEMD 
         and CQ7_CLVL  = @IN_CLVLD  and CQ7_MOEDA  = @IN_MOEDA  and CQ7_TPSALD  = @IN_TPSALDO  and CQ7_DATA  = @IN_DATA  and CQ7_LP  = @cLp 
         and D_E_L_E_T_  = ' '

UPDATE SA1010 SET S_T_A_M_P_ = GETUTCDATE()  WHERE R_E_C_N_O_ IN ( SELECT R_E_C_N_O_ FROM INSERTED )

INSERT INTO CQ3010 (CQ3_FILIAL , CQ3_CONTA , CQ3_CCUSTO , CQ3_MOEDA , CQ3_TPSALD , CQ3_DATA , CQ3_DEBITO , CQ3_SLBASE , 
                CQ3_STATUS , CQ3_LP , R_E_C_N_O_ ) 
         VALUES (@IN_FILIAL , @IN_CONTAD , @IN_CUSTOD , @IN_MOEDA , @IN_TPSALDO , @IN_DATA , 0 , @cSlBase , @cStatus , @cLp , 
                @iRecno )