You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
51 lines
3.1 KiB
51 lines
3.1 KiB
USE [FastMoneyPro_Remit]
|
|
GO
|
|
/****** Object: StoredProcedure [dbo].[mobile_proc_KTFC] Script Date: 9/27/2019 1:30:14 PM ******/
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
|
|
CREATE OR ALTER PROC [dbo].[mobile_proc_KTFC]
|
|
@FLAG VARCHAR(20),
|
|
@CUSTOMERID VARCHAR(100),
|
|
@KftcLogId BIGINT = NULL
|
|
|
|
AS
|
|
SET NOCOUNT ON;
|
|
|
|
DECLARE @VgmeAccessToken VARCHAR(400),@VgmeBankCode VARCHAR(5)
|
|
|
|
IF @FLAG = 'CUSTOMERINFO'
|
|
BEGIN
|
|
SELECT @VgmeAccessToken = accessToken,
|
|
@VgmeBankCode = bankCodeStd
|
|
FROM KFTC_GME_MASTER(NOLOCK)
|
|
|
|
SELECT C.CustomerId, C.AccessToken, S.FintechUseNo, S.AccountNum, s.AccountName,
|
|
c.AccHolderInfoType,c.AccHolderInfo,s.bankCodeStd AS BankCode, @VgmeAccessToken GmeAccessToken , @VgmeBankCode GmeBankCode
|
|
FROM KFTC_CUSTOMER_MASTER(NOLOCK) C
|
|
INNER JOIN KFTC_CUSTOMER_SUB S(NOLOCK) ON S.customerId = C.customerId
|
|
WHERE S.customerId = @CUSTOMERID AND S.rowId = @KftcLogId
|
|
END
|
|
|
|
ELSE IF @FLAG = 'GME-INFO'
|
|
BEGIN
|
|
SELECT accessToken,
|
|
bankCodeStd
|
|
FROM KFTC_GME_MASTER(NOLOCK)
|
|
|
|
END
|
|
|
|
ELSE IF @FLAG = 'ACCOUNTINFO' -- 2019.10 계좌해지시 사용하기 위해 추가
|
|
BEGIN
|
|
SELECT C.CustomerId, C.AccessToken, S.FintechUseNo, S.AccountNum, S.AccountName,
|
|
C.AccHolderInfoType,C.AccHolderInfo,S.bankCodeStd AS BankCode, S.inquiryAgreeYn, S.transferAgreeYn
|
|
FROM KFTC_CUSTOMER_MASTER(NOLOCK) C
|
|
INNER JOIN KFTC_CUSTOMER_SUB S(NOLOCK) ON S.customerId = C.customerId
|
|
WHERE S.customerId = @CUSTOMERID AND S.rowId = @KftcLogId
|
|
END
|
|
|
|
|
|
|
|
GO
|