CLIENT SUPPORT » HINO Bugs

??USE [MinovaES_HINO_Dev]

GO

/****** Object:  StoredProcedure [dbo].[PHRPYBASEWTBENEFIT_NOPROTATE]    Script Date: 15/09/2023 08.43.43 ******/

SET ANSI_NULLS ON

GO

--SET QUOTED_IDENTIFIER ON

--GO

--ALTER PROCEDURE [dbo].[PHRPYBASEWTBENEFIT_NOPROTATE]

--(

--	@EmpID VARCHAR(20)

--	,@EndDate VARCHAR(20)

--	,@BaseWT VARCHAR(20)

--	,@NoProrate VARCHAR(50)

--)

--AS 

DECLARE @EmpID VARCHAR(20) = '00000036'

DECLARE @EndDate VARCHAR(20) = '20230831'

DECLARE @BaseWT VARCHAR(20) = 'B002'

DECLARE @NoProrate VARCHAR(50) = '1'

DECLARE @BaseAmount DECIMAL(22,0) = 0

IF(@NoProrate = '1')

BEGIN

	DECLARE @TWT TABLE

	(

		WageType VARCHAR(20)

	)

	INSERT INTO @TWT

	SELECT DISTINCT WageType

	FROM dbo.PHRPYCU0305

	WHERE WageTypeCum = @BaseWT

	DECLARE @c_wt varchar(8)

	DECLARE cur_wt CURSOR FOR SELECT WageType FROM @TWT

	OPEN cur_wt

	FETCH cur_wt INTO @c_wt

	WHILE @@Fetch_Status = 0

		BEGIN

			SELECT @BaseAmount = @BaseAmount + CAST(REPLACE(ISNULL(dbo.GetPEN(Amount), '0'), ',','.') AS DECIMAL)

			FROM dbo.PHRPA0004 

			WHERE EmployeeID = @EmpID AND StartDate <= @EndDate AND EndDate >= @EndDate

				AND WageType = @c_wt

		FETCH cur_wt INTO @c_wt  

		END

	CLOSE cur_wt

	DEALLOCATE cur_wt

END

SELECT ISNULL(@BaseAmount,0) AS BaseAmount