SELECT COUNT(*)
		 FROM ASS_MASTER A
		 WHERE A.AMORT_STATUS IN ('CKH','DKH')
			AND convert(date, A.AMORT_START_DATE) <= convert(date, '2022-10-31')
			AND A.AMORTIZED_AMT < A.AMORT_AMT
			AND A.RECORD_STATUS = '1'
			AND A.AUTH_STATUS = 'A'
			--AND (A.TYPE_ID = @p_ASSET_TYPE OR @p_ASSET_TYPE = 'ALL') --Phong

SELECT COUNT (*) FROM ASS_MASTER WHERE AMORT_STATUS IN ('CKH','DKH') AND AMORT_START_DATE <='2022-10-31'

AND AMORTIZED_AMT < AMORT_AMT
			AND RECORD_STATUS = '1'
			AND AUTH_STATUS = 'A'