BANK KALTENG

??USE [MinovaES_BankKalteng_Dev]

GO

/****** Object:  StoredProcedure [dbo].[PRPTCMBONUSHEAD]    Script Date: 13/07/2022 10.19.32 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

ALTER PROCEDURE [dbo].[PRPTCMBONUSHEAD]

(

  @CompanyID varchar(8),

  @Year varchar(8),

  @CostCenter varchar(8),

  @Organization varchar(8),

  @EmployeeIDFrom varchar(8),

  @EmployeeIDTo varchar(8),

  @MenuID varchar(8),

  @UserID varchar(8)

)

AS

--DECLARE @CompanyID varchar(8)

--DECLARE @Scenario varchar(250)

--DECLARE @Year varchar(8)

--DECLARE @CostCenter varchar(8)

--DECLARE @Organization varchar(8)

--DECLARE @EmployeeIDFrom varchar(8)

--DECLARE @EmployeeIDTo varchar(8)

--DECLARE @MenuID varchar(8) = 'CMR01'

--DECLARE @UserID varchar(8) = 'tri'

--SET @CompanyID = '1000'

--SET @Scenario = ''

--SET @Year = '2022'

--SET @CostCenter = ''

--SET @Organization = ''

--SET @EmployeeIDFrom = ''

--SET @EmployeeIDTo = ''

SELECT TOP(1) COM.* ,

        ISNULL(CAT.FileData, 0) AS Value

		,@year AS period

FROM    dbo.PCMEPCOMPID COM

LEFT JOIN dbo.SFILECATALOG CAT ON COM.Logo = CAT.FileName

WHERE (com.CompanyID = @CompanyID OR @CompanyID = '')