#------------------------------------------------------------
# Copyright (C) 2006 RoyaltyShare, Inc.   All Rights Reserved
# $Id$
#------------------------------------------------------------
package RPS::DB::Item::ArtistRoyaltyRun;
use strict;
use warnings;
use lib '/app/tools/common/lib';
use Common::DB::Item;
use Common::Assert;
use base 'RPS::DB::RoyaltyRunItem';


use constant kTable => 'artist_royalty_run';
use constant kDB => Common::DB::Item::kClientDB();

sub _table { kTable }

sub GetOtherCommittedRuns
{
    my ($class, $runID) = @_;

    my $sql = "SELECT * FROM " . kTable . " WHERE status=".RPS::RoyaltyRun::Status::kCommitted." AND artist_royalty_run_id<>$runID AND payor_id=(select payor_id from ".kTable." where artist_royalty_run_id=$runID)";

    return $class->SUPER::GetAllLegacy($sql);
}



1;