DỰ ÁN PHẦN MỀM QUẢN LÝ TÀI SẢN NGÂN HÀNG BẢN VIỆT

DECLARE @TMP_DVDM TABLE(DVDM_ID VARCHAR(15))

			INSERT INTO @TMP_DVDM

			SELECT A.DVDM_ID--, A.COST_CODE, A.COST_NAME, B.DEP_ID --, C.DEP_CODE, C.DEP_NAME

			FROM PL_COSTCENTER A

			LEFT JOIN PL_COSTCENTER_DT B ON A.COST_ID = B.COST_ID

			WHERE B.DEP_ID = 'DEP000000000014'

			GROUP BY A.DVDM_ID

SELECT * FROM @TMP_DVDM

DECLARE @TOTAL_ADVANCE DECIMAL(18,0)

SET @TOTAL_ADVANCE =ISNULL((SELECT SUM(REQ_AMT*ISNULL(RATE,1)) FROM TR_REQ_ADVANCE_PAYMENT WHERE

					 DEP_ID IN

					 (SELECT A.DEP_ID FROM PL_COSTCENTER_DT A

						LEFT JOIN PL_COSTCENTER B ON A.COST_ID = B.COST_ID

						WHERE B.DVDM_ID IN (SELECT DVDM_ID FROM @TMP_DVDM) AND A.BRANCH_ID ='DV0001')

					 AND REQ_TYPE ='I' AND AUTH_STATUS ='A'),0)