102: SELECT ledger_id
103: ,NAME
104: ,ledger_category_code
105: , relationship_enabled_flag
106: FROM xla_ledger_relationships_v xlr
107: WHERE xlr.primary_ledger_id = p_ledger_id
108: --AND xlr.relationship_enabled_flag = 'Y'
109: ORDER BY DECODE(xlr.ledger_category_code,
110: 'PRIMARY',1,