DECLARE @SUM_TEMP_PAY DECIMAL, @SUM_PAY DECIMAL
	
SET @SUM_TEMP_PAY = (	SELECT SUM(A.REQ_AMT*ISNULL(A.RATE,1)) 
						FROM TR_REQ_ADVANCE_PAYMENT A 
						LEFT JOIN CM_DEPARTMENT B ON A.DEP_ID = B.DEP_ID
						WHERE A.REQ_TYPE= 'I' AND A.AUTH_STATUS_KT ='A' AND B.KHOI_ID = 'DM0000000000015'
					)
SET  @SUM_PAY = (	SELECT SUM (ISNULL(A.PAY_AMT,0)) 
					FROM TR_REQ_ADVANCE_PAYMENT A
					LEFT JOIN CM_DEPARTMENT B ON A.DEP_ID = B.DEP_ID
					WHERE A.AUTH_STATUS_KT ='A' AND A.REQ_TYPE ='I' AND B.KHOI_ID = 'DM0000000000015'
				)