GL Budget - Unbudgeted Master/Detail Accounts

select
   &FLEXDATA                   				FLEXDATA_H,
   &ACCOUNT_SEG            				ACCOUNT_SEG_H,
  glbv.budget_name           				Dep_Bud_Name,
  &PTD_YTD                  				Dep_amount, 
	fnd_flex_xml_publisher_apis.process_kff_combination_1('account_seg_dsp', 'SQLGL', 'GL#', CS.CHART_OF_ACCOUNTS_ID, NULL, CS.CODE_COMBINATION_ID, 'GL_ACCOUNT', 'N', 'FULL_DESCRIPTION') ACCOUNT_SEG_DSP, 
	fnd_flex_xml_publisher_apis.process_kff_combination_1('flexdata2_dsp', 'SQLGL', 'GL#', CS.CHART_OF_ACCOUNTS_ID, NULL, CS.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') FLEXDATA2_DSP
FROM
  gl_code_combinations   				cs,
  gl_balances                 				glbd,
  gl_budget_versions         				glbv
where
  glbd.ledger_id =    		:P_LEDGER_ID  AND
  glbd.currency_code =   	:P_CURRENCY_CODE AND	
  glbd.period_name =     	:P_PERIOD_NAME AND
  glbd.actual_flag =      	'B' AND
  glbd.code_combination_id = cs.code_combination_id		AND
  glbd.budget_version_id in
   (select glbv1.budget_version_id
    from gl_budget_versions glbv1
    where glbv1.control_budget_version_id = 
             :P_BUDGET_VERSION_ID)			AND
  glbd.budget_version_id = glbv.budget_version_id		AND
  NVL(glbd.translated_flag,'R') = 'R'			AND
  glbd.template_id is NOT NULL				AND
  glbd.code_combination_id NOT IN
  (select glbc.code_combination_id
    from gl_balances glbc
    where glbc.ledger_id = :P_LEDGER_ID AND
        glbc.period_name = :P_PERIOD_NAME AND
        glbc.currency_code = :P_CURRENCY_CODE AND
        glbc.budget_version_id = :P_BUDGET_VERSION_ID AND
        glbc.actual_flag = 'B')
  &WHERE_DAS
order by 1 ASC ,
  &FLEX_ORDERBY,
  glbv.budget_name

select &FLEXDATA FLEXDATA_H, &ACCOUNT_SEG ACCOUNT_SEG_H, glbv.budget_name Dep_Bud_Name, &PTD_YTD Dep_amount, fnd_flex_xml_publisher_apis.process_kff_combination_1('account_seg_dsp', 'SQLGL', 'GL#', CS.CHART_OF_ACCOUNTS_ID, NULL, CS.CODE_COMBINATION_ID, 'GL_ACCOUNT', 'N', 'FULL_DESCRIPTION') ACCOUNT_SEG_DSP, fnd_flex_xml_publisher_apis.process_kff_combination_1('flexdata2_dsp', 'SQLGL', 'GL#', CS.CHART_OF_ACCOUNTS_ID, NULL, CS.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') FLEXDATA2_DSP FROM gl_code_combinations cs, gl_balances glbd, gl_budget_versions glbv where glbd.ledger_id = :P_LEDGER_ID AND glbd.currency_code = :P_CURRENCY_CODE AND glbd.period_name = :P_PERIOD_NAME AND glbd.actual_flag = 'B' AND glbd.code_combination_id = cs.code_combination_id AND glbd.budget_version_id in (select glbv1.budget_version_id from gl_budget_versions glbv1 where glbv1.control_budget_version_id = :P_BUDGET_VERSION_ID) AND glbd.budget_version_id = glbv.budget_version_id AND NVL(glbd.translated_flag,'R') = 'R' AND glbd.template_id is NOT NULL AND glbd.code_combination_id NOT IN (select glbc.code_combination_id from gl_balances glbc where glbc.ledger_id = :P_LEDGER_ID AND glbc.period_name = :P_PERIOD_NAME AND glbc.currency_code = :P_CURRENCY_CODE AND glbc.budget_version_id = :P_BUDGET_VERSION_ID AND glbc.actual_flag = 'B') &WHERE_DAS order by 1 ASC , &FLEX_ORDERBY, glbv.budget_name