Calculate the GL Average Balance period to Date

Hi ,

  Our customer is on 11i.  We are migrating to cloud now.  As part of conversion, we are generating fbdi files from 11i instance.  The period_average_to_date is to be calculated and I am using the below query.  Can you  please suggest.  It is little urgent.  Appreciate the quick turn around.

          SELECT  NVL(period_average_to_date, 0)   

          FROM    gl_daily_balances_v bal

                        ,gl_sets_of_books sob

          WHERE   bal.set_of_books_id = xx

          AND     bal.period_name     = 'DEC-16'

          AND     bal.code_combination_id = XXXX    

          AND     bal.currency_code   = 'CAD'

          AND     bal.accounting_date = '31-DEC-16'