GL Cash Clearing Account Analysis

        SELECT 
                MAX (DECODE (gb.period_name,:period_from_param, NVL (gb.begin_balance_dr, 0),0)) BEGIN_BALANCE_DR
               ,MAX (DECODE (gb.period_name,:period_from_param, NVL (gb.begin_balance_cr, 0),0)) BEGIN_BALANCE_CR
               ,MAX (DECODE (gb.period_name,:period_to_param, NVL (gb.begin_balance_dr, 0)
                                                                  +NVL (gb.period_net_dr, 0),0)) END_BALANCE_DR
               ,MAX (DECODE (gb.period_name,:period_to_param, NVL (gb.begin_balance_cr, 0)
                                                                 + NVL (gb.period_net_cr, 0),0)) END_BALANCE_CR
               ,MAX(gcc.code_combination_id) CCID													 
        FROM    gl_balances          gb
               ,gl_code_combinations gcc
        WHERE  gb.ledger_id = :ledger_id_param
        AND    gb.code_combination_id = :ccid_param
        AND    gb.period_name IN (:period_from_param, :period_to_param)
        AND    gb.currency_code =(
                                  SELECT currency_code
                                  FROM gl_ledgers
                                  WHERE ledger_id = :ledger_id_param
                                 )
        AND   gb.actual_flag = 'A'
        AND   gcc.code_combination_id = gb.code_combination_id
        AND   &GC_ACCESS_WHERE