|
1
|
|
|
2
|
declare @p_EXECUTE_DATE varchar(20)=N'25/10/2022 23:52:04',@p_ASSET_TYPE varchar(15)=N'ALL',@p_MAKER_ID varchar(15) =N'vanpt2',@p_CHECKER_ID VARCHAR(15) =N'vanpt2',@p_BRANCH_ID_LST XML=NULL
|
|
3
|
declare @l_AMORT_ID varchar(15), @l_AMORTDT_ID varchar(15)
|
|
4
|
declare @l_LAST_AMORT_ID varchar(15) = NULL
|
|
5
|
declare @l_AMORT_TERM nvarchar(50) = ''
|
|
6
|
|
|
7
|
declare @l_ASSET_ID varchar(15)
|
|
8
|
declare @l_AMORTIZED_AMT decimal(18,0)
|
|
9
|
declare @l_AMORTIZED_MONTH int
|
|
10
|
declare @l_AMORT_AMT decimal(18,0)
|
|
11
|
declare @l_AMORT_MONTH decimal(18,2)
|
|
12
|
declare @l_AMORT_END_DATE datetime, @l_AMORT_START_DATE datetime
|
|
13
|
declare @l_FIRST_AMORT_AMT decimal(18,0), @l_MONTHLY_AMORT_AMT decimal(18,0)
|
|
14
|
declare @l_BRANCH_ID varchar(15)
|
|
15
|
declare @l_DEP_ID varchar(15)
|
|
16
|
declare @l_BRANCH_ID_DO varchar(15) = NULL, @l_BRANCH_TYPE_DO VARCHAR(15)
|
|
17
|
declare @l_CURR_AMORT_AMT decimal(18,0)
|
|
18
|
declare @l_TOTAL_AMT decimal(18,0)
|
|
19
|
declare @l_CURR_AMORT_STATUS nvarchar(100)
|
|
20
|
declare @l_DESC nvarchar(1000)
|
|
21
|
DECLARE @ERRORSYS NVARCHAR(15) = ''
|
|
22
|
DECLARE @LST_BRANCH TABLE ( BRANCHID VARCHAR(15), BRANCHCODE VARCHAR(15))
|
|
23
|
|
|
24
|
DECLARE @ErrCode nvarchar(10) --Phong added
|
|
25
|
declare @l_AmortIdDefault varchar(100) = '',@l_AMORTTERMDefault varchar(100) = '',
|
|
26
|
@l_TOTALAMTDefault decimal (18,2) = 0,@l_PROCESSSTATUSDefault varchar(100) = '',
|
|
27
|
@l_ExecDateDefault datetime = null, @l_StatusNameDef varchar(100) = '', @l_NotesDef varchar(100) = ''
|
|
28
|
--
|
|
29
|
|
|
30
|
declare @sExecDT datetime = convert(datetime, @p_EXECUTE_DATE, 103)
|
|
31
|
|
|
32
|
select @l_LAST_AMORT_ID = AMORT_ID
|
|
33
|
FROM ASS_AMORT
|
|
34
|
WHERE IS_LEAF = 'Y'
|
|
35
|
|
|
36
|
SET @l_AMORT_TERM = convert(varchar(2), datepart(month, @sExecDT)) + '/' + convert(varchar(4), datepart(year, @sExecDT))
|
|
37
|
|
|
38
|
|
|
39
|
SELECT A.ASSET_ID, A.AMORTIZED_AMT, A.AMORTIZED_MONTH,
|
|
40
|
A.AMORT_AMT, A.AMORT_MONTH, A.AMORT_END_DATE, A.AMORT_START_DATE,
|
|
41
|
A.FIRST_AMORT_AMT, A.MONTHLY_AMORT_AMT, A.BRANCH_ID, A.DEPT_ID
|
|
42
|
FROM ASS_MASTER A
|
|
43
|
WHERE A.AMORT_STATUS IN ('CKH','DKH')
|
|
44
|
AND convert(date, A.AMORT_START_DATE) <= convert(date, @sExecDT)
|
|
45
|
AND A.AMORTIZED_AMT < A.AMORT_AMT
|
|
46
|
AND A.RECORD_STATUS = '1'
|
|
47
|
AND A.AUTH_STATUS = 'A'
|
|
48
|
AND (A.TYPE_ID = @p_ASSET_TYPE OR @p_ASSET_TYPE = 'ALL') --Phong
|