CURSOR CUR01 IS
    SELECT COLUMN_VALUE AS SPCODE FROM TABLE(BOS.FN_SPLIT(I_SPCODE,','));
BEGIN

  -- OPEN cur_name;
   
   FOR C1 IN CUR01 LOOP
          V_CAN_USE_MILEAGE := '0';
   
          SELECT 
                        BRANDCD 
          INTO V_BRANDCD
          FROM BOS.V_BM_ORDER_BASKET  WHERE CCD = I_CCD AND SPCODE IN (C1.SPCODE) GROUP BY BRANDCD;   
    
          IF V_BRANDCD =   '109100' then
                SELECT  
                
                CASE WHEN ROUND((TO_NUMBER(SUBSTR (BOS.FN_GET_SALEPRICE_CH(BSK.SPCODE, I_CCD, '','N','ko','','KRW'), 31, 10))* BSK_QTY) * 0.13 )  IS NULL THEN
                0
                ELSE
                ROUND((TO_NUMBER(SUBSTR (BOS.FN_GET_SALEPRICE_CH(BSK.SPCODE, I_CCD, '','N','ko','','KRW'), 31, 10))* BSK_QTY) * 0.13 ) 
                END AS CAN_USE_MILEAGE
                    INTO V_CAN_USE_MILEAGE
                FROM BOS.V_BM_ORDER_BASKET BSK WHERE 1=1 AND BSK.CCD = I_CCD AND SPCODE in  (C1.SPCODE); 
          
          
            END IF;  

        
        
   
   END LOOP;

이렇게 함수가 돌아가는데요

LOOP 안에서 V_CAN_USE_MILEAGE가 계속 더해진 총합을 구하고싶은데 어떻게 해야하나요?

도움좀 부탁드립니다.

감사합니다.