OKL Variable Rate Schedule

SELECT  VAR.INTEREST_CALC_START_DATE DATE_FROM, 
        VAR.INTEREST_CALC_END_DATE DATE_TO, 
        DECODE(VAR.CALC_METHOD_CODE,'REAMORT','Y','N') COMPOSITE, 
        LKP.MEANING INTEREST_CALCULATION, 
        VAR.CALC_METHOD_CODE INTEREST_CALC_MTHD_CODE, 
        VAR.INTEREST_RATE, 
        SUM(VAR.INTEREST_AMT) INTEREST_AMOUNT, 
        VAR.KHR_ID KHR_ID,
        CHR.CONTRACT_NUMBER CONTRACT_NUMBER, 
        CHR.STS_CODE CONTRACT_STATUS,
        CHR.START_DATE CONTRACT_EFFECTIVE_FROM,
        CHR.END_DATE CONTRACT_EFFECTIVE_TO,
        CHR.CURRENCY_CODE CONTRACT_CURRENCY_CODE, 
        CHR.AUTHORING_ORG_ID ORG_ID,
        CHR.CUST_ACCT_ID CUST_ACCOUNT_ID
FROM    OKL_VAR_INT_PARAMS_ALL VAR, 
        FND_LOOKUPS LKP,
        OKC_K_HEADERS_ALL_B CHR 
WHERE   VAR.KHR_ID = :P_CONTRACT_ID
   AND  LKP.LOOKUP_TYPE = 'OKL_BPD_VAR_RATE_CALC_CODE' 
   AND  LKP.LOOKUP_CODE = VAR.CALC_METHOD_CODE
   AND  VAR.KHR_ID = CHR.ID
GROUP BY VAR.INTEREST_CALC_START_DATE,
         VAR.INTEREST_CALC_END_DATE,
         VAR.CALC_METHOD_CODE,
         LKP.MEANING,
         VAR.INTEREST_RATE,
         VAR.KHR_ID,
         CHR.CONTRACT_NUMBER,
         CHR.STS_CODE,
         CHR.START_DATE,
         CHR.END_DATE,
         CHR.CURRENCY_CODE,
         CHR.AUTHORING_ORG_ID,
         CHR.CUST_ACCT_ID
ORDER BY CHR.START_DATE