From 2607bb85159f385efe6bc94ffd77450a1ab4ce5f Mon Sep 17 00:00:00 2001
From: einhverfr <einhverfr@4979c152-3d1c-0410-bac9-87ea11338e46>
Date: Sun, 18 Feb 2007 00:33:10 +0000
Subject: Fixing bug 1661261

git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/branches/1.2@810 4979c152-3d1c-0410-bac9-87ea11338e46
---
 LedgerSMB/RC.pm               | 6 +++---
 dists/deb/cpan_requisites.txt | 1 +
 2 files changed, 4 insertions(+), 3 deletions(-)

diff --git a/LedgerSMB/RC.pm b/LedgerSMB/RC.pm
index 7ba6770a..48f184cd 100755
--- a/LedgerSMB/RC.pm
+++ b/LedgerSMB/RC.pm
@@ -232,11 +232,11 @@ sub payment_transactions {
 	if ($form->{fx_transaction}) {
 		$fx_transaction = qq|
 			AND NOT (ac.chart_id IN 
-				(SELECT value AS fxgain_accno_id FROM defaults
+				(SELECT value FROM defaults
 					WHERE setting_key = 'fxgain_accno_id'
 				UNION
-				SELECT value AS fxloss_accno_id FROM defaults
-					WHERE setting_key = 'fxloss_accno_id))|;
+				SELECT value FROM defaults
+					WHERE setting_key = 'fxloss_accno_id'))|;
 	} else {
 		$fx_transaction = qq|
 			AND ac.fx_transaction = '0'|;
diff --git a/dists/deb/cpan_requisites.txt b/dists/deb/cpan_requisites.txt
index e1b0e1ae..b2636dea 100644
--- a/dists/deb/cpan_requisites.txt
+++ b/dists/deb/cpan_requisites.txt
@@ -1,2 +1,3 @@
 Config::Std
 Class::Std
+Build
-- 
cgit v1.2.3