66: WHERE ledger_id IN (
67: SELECT gll2.ledger_id
68: FROM gl_ledgers gll1,
69: gl_ledgers gll2,
70: gl_ledger_relationships glrs
71: WHERE gll1.short_name = c_ledger_short_name
72: AND glrs.primary_ledger_id = gll1.ledger_id
73: AND gll2.object_type_code = c_object_type_code
74: AND glrs.target_ledger_id = gll2.ledger_id