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)