PSB Flexfield Mapping

select distinct a.code_combination_id in_ccid, 
	PSB_PSBRPFLX_XMLP_PKG.cf_accountformula(a.code_combination_id) CF_ACCOUNT
from psb_ws_account_lines a,gl_code_combinations cc
where a.currency_code <> 'STAT' and
a.code_combination_id = cc.code_combination_id and
cc.summary_flag <> 'Y' and
exists
(select 1 from psb_ws_lines b
where b.account_line_id = a.account_line_id and
b.worksheet_id =:p_global_worksheet_id )
order by a.code_combination_id