199: target_ledger_name VARCHAR2(30);
200:
201: CURSOR ledger_id_cur IS
202: SELECT rel.target_ledger_name
203: FROM gl_ledgers lgr, gl_ledger_relationships rel, gl_ledgers alc
204: WHERE lgr.ledger_id = ledgerid
205: AND rel.source_ledger_id = lgr.ledger_id
206: AND rel.target_ledger_category_code = 'ALC'
207: AND rel.relationship_type_code <> 'BALANCE'