DỰ ÁN PHẦN MỀM QUẢN LÝ TÀI SẢN - NH BẢN VIỆT - GD3

 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'