--bk data
SELECT ASSET_CODE,AMORTIZED_AMT,AMORTIZED_MONTH,AMORT_STATUS FROM dbo.ASS_MASTER
-- 
EXEC [ASS_AMORT_Do] '19/01/2023','admin','admin','ALL',NULL

EXEC ASS_AMORT_Start @p_AMORT_ID =''

--TYPE BAN CORE
AMORT

-- KTRA DA BAN THANH CONG CHUA
SELECT COUNT (*) FROM ASS_ENTRIES_POST WHERE TRN_ID ='' AND ISNULL(REF_NO,'') <> ''