CLIENT SUPPORT » BBG Bugs

??USE [MinovaES_BBG_Prod]

GO

/****** Object:  StoredProcedure [dbo].[PDSLOANLASTBALANCEPELUNASAN]    Script Date: 19/04/2022 09.31.40 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

ALTER PROCEDURE [dbo].[PDSLOANLASTBALANCEPELUNASAN]

(

	@EmployeeID VARCHAR(50),

	@StartDate VARCHAR(50),

	@HeaderSequence VARCHAR(50),

	 @LoanType VARCHAR(50)

)

AS

--DECLARE @EmployeeID VARCHAR(50) = '00000066'

--DECLARE @StartDate VARCHAR(50) = '20220201'

--DECLARE @HeaderSequence VARCHAR(50) = '3'

--DECLARE @LoanType VARCHAR(50) = '2000'

DECLARE @DateBefore VARCHAR(50)

SET @DateBefore = dbo.fn_formatdatetime(( DATEADD(dd, -1,CONVERT(DATETIME, @StartDate))),'yyyymmdd')

DECLARE @LastBalance DECIMAL(22,0)

SELECT @LastBalance = pa35.Balance

FROM dbo.PHRPA0035 AS pa35

WHERE pa35.EmployeeID = @EmployeeID

	AND pa35.HeaderSequence = @HeaderSequence

	AND pa35.EndDate = @DateBefore

SELECT @LastBalance AS LastBalance