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)
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
SET @TOTAL_ADVANCE =ISNULL) 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)