IF(@p_REQ_TYPE ='I')
	BEGIN
		DECLARE @AMT_AD_PAY DECIMAL(18,0) =0
		DECLARE @AMT_AD_PAY_BACK DECIMAL(18,0) =0
		DECLARE @AMT_AD_PAY_REMAIN DECIMAL(18,0) =0
		SET @AMT_AD_PAY = (SELECT SUM(REQ_AMT*ISNULL(RATE,1)) FROM TR_REQ_ADVANCE_PAYMENT WHERE REF_ID=@p_MAKER_ID AND AUTH_STATUS_KT='A' AND REQ_TYPE ='I')
		SET @AMT_AD_PAY_BACK = (SELECT SUM(D.AMT_USE) +SUM(D.AMT_REVERT) - SUM (D.AMT_ADD)
					FROM TR_REQ_PAYMENT_DT D
					LEFT JOIN TR_REQ_ADVANCE_PAYMENT X ON D.PAY_ADV_ID = X.REQ_PAY_ID  AND D.AUTH_STATUS_KT ='A'
					WHERE X.REF_ID =@p_REF_ID)
	 SET @AMT_AD_PAY_REMAIN =ISNULL(@AMT_AD_PAY,0) -ISNULL(@AMT_AD_PAY_BACK,0)
	 SET @p_REQ_TEMP_AMT =ISNULL(@AMT_AD_PAY_REMAIN,0)
	 END