Untitled

named_scope :lead_managers_co_managers, lambda { |lead_managers_array, co_managers_array|

    { :joins => [:lead_managers, :co_managers],

      :conditions => ['lead_manager_offerings.underwriter_id in (?) AND co_manager_offerings.underwriter_id in (?)', lead_managers_array, co_managers_array],

      :group => 'offerings.id',

      :having => ['count(DISTINCT lead_manager_offerings.underwriter_id) = ? AND count(DISTINCT co_manager_offerings.underwriter_id) = ?', lead_managers_array.length, co_managers_array.length] }

  }