ACC_PAYByid.txt
| 1 |
|
|---|---|
| 2 |
ALTER PROC [dbo].[CM_ACCOUNT_PAY_BYID] |
| 3 |
@p_REF_ID VARCHAR(15) = NULL, |
| 4 |
@p_ACC_TYPE VARCHAR(50) = NULL |
| 5 |
AS |
| 6 |
BEGIN |
| 7 |
IF(@p_ACC_TYPE = 'ADV_PAY') |
| 8 |
BEGIN |
| 9 |
SELECT TOP 1 A.*,'' AS REF_CODE, '' AS REF_NAME, 'ADV_PAY' AS ACC_TYPE, A.ACC_NUM ACC_NO, B.CONTENT AS AUTH_STATUS_NAME |
| 10 |
FROM CM_ACCOUNT_PAY A |
| 11 |
LEFT JOIN CM_ALLCODE B ON A.AUTH_STATUS = B.CDVAL AND B.CDNAME = 'AUTH_STATUS' AND B.CDTYPE = 'AUTH_STATUS' |
| 12 |
WHERE A.ACC_NUM = @p_REF_ID OR A.REF_ID = @p_REF_ID |
| 13 |
END |
| 14 |
ELSE |
| 15 |
BEGIN |
| 16 |
SELECT TOP 1 A.*,'' AS REF_CODE, '' AS REF_NAME, |
| 17 |
CASE |
| 18 |
WHEN LEN(A.ACC_NO) > 9 THEN 'CASA' |
| 19 |
ELSE 'GL' |
| 20 |
END AS ACC_TYPE, |
| 21 |
B.CONTENT AS AUTH_STATUS_NAME |
| 22 |
FROM CM_ACCOUNT A |
| 23 |
LEFT JOIN CM_ALLCODE B ON A.AUTH_STATUS = B.CDVAL AND B.CDNAME = 'AUTH_STATUS' AND B.CDTYPE = 'AUTH_STATUS' |
| 24 |
WHERE A.ACC_NO = @p_REF_ID |
| 25 |
END |
| 26 |
END |