select l.* from ledger_app_credit l,fw_organization o1,fw_organization o2 where o1.id_ =? and o2.hiberarchy_ like o1.hiberarchy_ || '%' and o2.id_ = l.orgid_ and l.enable_=1