DECLARE @SUM_TEMP_PAY DECIMAL, @SUM_PAY DECIMAL
	IF (@p_REQ_TYPE ='I')
	BEGIN
		SET @SUM_TEMP_PAY = (SELECT SUM(REQ_AMT*ISNULL(RATE,1)) 
		FROM TR_REQ_ADVANCE_PAYMENT WHERE REQ_TYPE=@p_REQ_TYPE AND REF_ID =@p_REF_ID AND AUTH_STATUS_KT ='A')
		SET @SUM_PAY = (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)
	END