GL daily Rates Import

Please validate the data and populate in to GL_DAILY_RATES_INTERFACE table.
After inserting the validate records, Please run the standard program.

Program - Daily Rates Import and Calculation


INSERT INTO GL_DAILY_RATES_INTERFACE
        (
         FROM_CURRENCY
        ,TO_CURRENCY
        ,FROM_CONVERSION_DATE
        ,TO_CONVERSION_DATE
        ,USER_CONVERSION_TYPE
        ,CONVERSION_RATE
        ,MODE_FLAG
        ,USER_ID
        )
        VALUES
        (CREC.FROM_CURRENCY
        ,CREC.TO_CURRENCY
        ,CREC.FROM_CONVERSION_DATE
        ,CREC.TO_CONVERSION_DATE
        ,L_USER_CONVERSION_TYPE
        ,CREC.CONVERSION_RATE
        ,'I'
        ,FND_PROFILE.VALUE('USER_ID')
        );