GL Open Balances Revaluation

            SELECT * FROM 
              (SELECT 
                      gcc.code_combination_id        ccid
                     ,fnd_flex_xml_publisher_apis.process_kff_combination_1('flex_acct', 'SQLGL', 'GL#', gcc.CHART_OF_ACCOUNTS_ID, NULL, gcc.CODE_COMBINATION_ID, 'ALL', 'N', 'VALUE')                     acct
                     ,gjh.currency_code              reval_jrnl_currency_code
                     ,gjs.user_je_source_name        reval_jrnl_source
                     ,gjc.user_je_category_name      reval_jrnl_category
                     ,gjh.name                       reval_jrnl_name
                     ,gjh.default_effective_date     reval_jrnl_effective_date
                     ,NVL(gjl.entered_dr,0)          reval_jrnl_line_ent_dr
                     ,NVL(gjl.entered_cr,0)          reval_jrnl_line_ent_cr
                     ,NVL(gjl.accounted_dr,0)        reval_jrnl_line_dr
                     ,NVL(gjl.accounted_cr,0)        reval_jrnl_line_cr
                     ,gl_open_bal_reval_rpt_pkg.get_reval_conversion_rate(gcc.code_combination_id
                                                                    ,fnd_flex_xml_publisher_apis.process_kff_combination_1('flex_acct', 'SQLGL', 'GL#', gcc.CHART_OF_ACCOUNTS_ID, NULL, gcc.CODE_COMBINATION_ID, 'ALL', 'N', 'VALUE')					 
                                                                    ,gjh.currency_code)   reval_conversion_rate
              FROM   
                      gl_je_headers gjh
                     ,gl_je_lines gjl 
                     ,gl_code_combinations gcc
                     ,gl_je_categories gjc
                     ,gl_je_sources gjs
                     ,gl_balances gb
              WHERE
                         gb.ledger_id=:ledger_id_param
                     AND gb.code_combination_id=gcc.code_combination_id
                     AND gb.period_name=:period_to_param
                     AND gb.actual_flag = 'A'
                     AND gb.translated_flag='R'
                     AND (NVL(gb.begin_balance_dr,0)+NVL(gb.period_net_dr,0))
                         <> (NVL(gb.begin_balance_cr,0)+NVL(gb.period_net_cr,0))
                     AND gjh.ledger_id = gb.ledger_id
                     AND gjh.je_source = 'Revaluation'
                     AND gjh.status = 'P'
                     AND gjh.actual_flag = 'A'	  
                     AND gjh.currency_code=gb.currency_code
                     AND gjl.effective_date BETWEEN :gd_start_date AND :gd_end_date
                     AND gjl.je_header_id = gjh.je_header_id	
                     AND gjl.code_combination_id = gb.code_combination_id
                     AND gjc.je_category_name = gjh.je_category
                     AND gjs.je_source_name = gjh.je_source
                     AND &gc_currency_where 
                     AND &acct_flex_where_clause
                     AND &gc_access_where 
              ORDER BY 
                      acct
                     ,reval_jrnl_currency_code )
            WHERE reval_conversion_rate IS NOT NULL