View | Details | Raw Unified | Return to bug 18941
Collapse All | Expand All

(-)a/C4/Budgets.pm (-2 / +2 lines)
Lines 779-786 sub GetBudgetByCode { Link Here
779
    my $query = qq{
779
    my $query = qq{
780
        SELECT *
780
        SELECT *
781
        FROM aqbudgets
781
        FROM aqbudgets
782
        JOIN aqbudgetperiods USING (budget_period_id)
782
        WHERE budget_code = ?
783
        WHERE budget_code = ?
783
        ORDER BY budget_id DESC
784
        ORDER BY budget_id DESC, budget_period_active DESC
784
        LIMIT 1
785
        LIMIT 1
785
    };
786
    };
786
    my $sth = $dbh->prepare( $query );
787
    my $sth = $dbh->prepare( $query );
787
- 

Return to bug 18941