Guest User

Untitled

a guest
Jan 20th, 2019
85
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.70 KB | None | 0 0
  1. coverage_levels = CoverageLevel.find(:all,
  2. :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',
  3. :from => 'org_plan_years opy',
  4. :joins => 'inner join org_benefits ob on ob.org_plan_year_id = opy.id
  5. inner join benefits b on b.id = ob.benefit_id
  6. inner join org_plans op on op.org_benefit_id = ob.id
  7. inner join coverage_levels cl on cl.coverage_level_group_id = op.coverage_level_group_id',
  8. :conditions => ['opy.organization_id = ?', organization.id],
  9. :order => 'benefit_name, plan_name, cl.display_order'
  10. )
Add Comment
Please, Sign In to add comment