236: insert into FII_FA_ACCT_CLASS_CODE_GT
237: (accounting_class_code, ledger_id)
238: SELECT XACA.accounting_class_code,
239: fset.ledger_id
240: FROM xla_post_acct_progs_b XPAP,
241: xla_assignment_defns_b XAD,
242: xla_acct_class_assgns XACA,
243: (SELECT DISTINCT slga.ledger_id
244: FROM fii_slg_assignments slga,
255: AND XACA.assignment_code = XAD.assignment_code
256: UNION
257: SELECT XACA.accounting_class_code,
258: fset.ledger_id
259: FROM xla_post_acct_progs_b XPAP,
260: xla_assignment_defns_b XAD,
261: xla_acct_class_assgns XACA,
262: (SELECT DISTINCT slga.ledger_id
263: FROM fii_slg_assignments slga,