CHECK_SO_DU_TAM_UNG.txt
| 1 |
DECLARE @SUM_TEMP_PAY DECIMAL, @SUM_PAY DECIMAL |
|---|---|
| 2 |
|
| 3 |
SET @SUM_TEMP_PAY = ( SELECT SUM(A.REQ_AMT*ISNULL(A.RATE,1)) |
| 4 |
FROM TR_REQ_ADVANCE_PAYMENT A |
| 5 |
LEFT JOIN CM_DEPARTMENT B ON A.DEP_ID = B.DEP_ID |
| 6 |
WHERE A.REQ_TYPE= 'I' AND A.AUTH_STATUS_KT ='A' AND B.KHOI_ID = 'DM0000000000015' |
| 7 |
) |
| 8 |
SET @SUM_PAY = ( SELECT SUM (ISNULL(A.PAY_AMT,0)) |
| 9 |
FROM TR_REQ_ADVANCE_PAYMENT A |
| 10 |
LEFT JOIN CM_DEPARTMENT B ON A.DEP_ID = B.DEP_ID |
| 11 |
WHERE A.AUTH_STATUS_KT ='A' AND A.REQ_TYPE ='I' AND B.KHOI_ID = 'DM0000000000015' |
| 12 |
) |