GL Budget - Master/Detail

select null FLEXDATA,
          &SELECT_MASTER_BUDGET MASTER_BUDGET_BAL,
          bv.budget_name DEPENDENT_BUDGET_NAME,
          &SELECT_DETAIL_BUDGET DETAIL_BUDGET_BAL, 
	fnd_flex_xml_publisher_apis.process_kff_combination_1('acctdesc', 'SQLGL', 'GL#', CC.CHART_OF_ACCOUNTS_ID, NULL, CC.CODE_COMBINATION_ID, 'GL_ACCOUNT', 'N', 'FULL_DESCRIPTION') ACCTDESC, 
	fnd_flex_xml_publisher_apis.process_kff_combination_1('flexfield', 'SQLGL', 'GL#', CC.CHART_OF_ACCOUNTS_ID, NULL, CC.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') FLEXFIELD, 
	fnd_flex_xml_publisher_apis.process_kff_combination_1('flexfield_pad', 'SQLGL', 'GL#', CC.CHART_OF_ACCOUNTS_ID, NULL, CC.CODE_COMBINATION_ID, 'ALL', 'Y', 'PADDED_VALUE') FLEXFIELD_PAD, 
	GL_GLXRBCR_XMLP_PKG.available_budgetformula(nvl ( bm.period_net_dr , 0 ) - nvl ( bm.period_net_cr , 0 ), :TOTAL_DETAIL_BAL) AVAILABLE_BUDGET
from gl_budget_versions bv,
        gl_balances bm,
        gl_balances bd,
        gl_code_combinations cc
where cc.chart_of_accounts_id = :CHART_OF_ACCOUNTS_ID
and     cc.template_id is not null
&WHERE_DAS
and     bm.ledger_id = :P_LEDGER_ID
and     bm.code_combination_id = cc.code_combination_id
and     bm.currency_code = :P_CURRENCY_CODE
and     bm.period_name = :P_PERIOD_NAME
and     bm.actual_flag = 'B'
and     bm.budget_version_id = :P_BUDGET_VERSION_ID
and     (bm.translated_flag is NULL OR
            bm.translated_flag = 'R')
and     bm.template_id is not NULL
and     bd.ledger_id = :P_LEDGER_ID
and     bd.code_combination_id = bm.code_combination_id
and     bd.currency_code = :P_CURRENCY_CODE
and     bd.period_name = :P_PERIOD_NAME
and     bd.actual_flag = 'B'
and     bd.budget_version_id in 
          (select bv2.budget_version_id
            from gl_budget_versions bv2
            where bv2.control_budget_version_id = 
                      :P_BUDGET_VERSION_ID)
and    (bd.translated_flag is NULL OR
           bd.translated_flag = 'R')
and    bd.template_id is not NULL
and    bv.budget_version_id = bd.budget_version_id
order by &ORDERBY_FLEX, bv.budget_name

select null FLEXDATA, &SELECT_MASTER_BUDGET MASTER_BUDGET_BAL, bv.budget_name DEPENDENT_BUDGET_NAME, &SELECT_DETAIL_BUDGET DETAIL_BUDGET_BAL, fnd_flex_xml_publisher_apis.process_kff_combination_1('acctdesc', 'SQLGL', 'GL#', CC.CHART_OF_ACCOUNTS_ID, NULL, CC.CODE_COMBINATION_ID, 'GL_ACCOUNT', 'N', 'FULL_DESCRIPTION') ACCTDESC, fnd_flex_xml_publisher_apis.process_kff_combination_1('flexfield', 'SQLGL', 'GL#', CC.CHART_OF_ACCOUNTS_ID, NULL, CC.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') FLEXFIELD, fnd_flex_xml_publisher_apis.process_kff_combination_1('flexfield_pad', 'SQLGL', 'GL#', CC.CHART_OF_ACCOUNTS_ID, NULL, CC.CODE_COMBINATION_ID, 'ALL', 'Y', 'PADDED_VALUE') FLEXFIELD_PAD, GL_GLXRBCR_XMLP_PKG.available_budgetformula(nvl ( bm.period_net_dr , 0 ) - nvl ( bm.period_net_cr , 0 ), :TOTAL_DETAIL_BAL) AVAILABLE_BUDGET from gl_budget_versions bv, gl_balances bm, gl_balances bd, gl_code_combinations cc where cc.chart_of_accounts_id = :CHART_OF_ACCOUNTS_ID and cc.template_id is not null &WHERE_DAS and bm.ledger_id = :P_LEDGER_ID and bm.code_combination_id = cc.code_combination_id and bm.currency_code = :P_CURRENCY_CODE and bm.period_name = :P_PERIOD_NAME and bm.actual_flag = 'B' and bm.budget_version_id = :P_BUDGET_VERSION_ID and (bm.translated_flag is NULL OR bm.translated_flag = 'R') and bm.template_id is not NULL and bd.ledger_id = :P_LEDGER_ID and bd.code_combination_id = bm.code_combination_id and bd.currency_code = :P_CURRENCY_CODE and bd.period_name = :P_PERIOD_NAME and bd.actual_flag = 'B' and bd.budget_version_id in (select bv2.budget_version_id from gl_budget_versions bv2 where bv2.control_budget_version_id = :P_BUDGET_VERSION_ID) and (bd.translated_flag is NULL OR bd.translated_flag = 'R') and bd.template_id is not NULL and bv.budget_version_id = bd.budget_version_id order by &ORDERBY_FLEX, bv.budget_name