Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- coverage_levels = CoverageLevel.find(:all,
- :select => 'distinct ob.name as benefit_name, b.lookup_code as benefit_lookup_code, op.name as plan_name, op.lookup_code as plan_lookup_code, cl.name, cl.lookup_code',
- :from => 'org_plan_years opy',
- :joins => 'inner join org_benefits ob on ob.org_plan_year_id = opy.id
- inner join benefits b on b.id = ob.benefit_id
- inner join org_plans op on op.org_benefit_id = ob.id
- inner join coverage_levels cl on cl.coverage_level_group_id = op.coverage_level_group_id',
- :conditions => ['opy.organization_id = ?', organization.id],
- :order => 'benefit_name, plan_name, cl.display_order'
- )
Add Comment
Please, Sign In to add comment