Fixes issue 22919: Automated test regression, issue 22293
authorJavier Etxarri <javier.echarri@openbravo.com>
Tue, 29 Jan 2013 10:29:47 +0100
changeset 19491 4326aacab306
parent 19490 c2a31ef051f5
child 19492 ba68df61ab6b
child 19520 7c03514582ee
Fixes issue 22919: Automated test regression, issue 22293
src-db/database/model/functions/C_YEARPERIODS.xml
--- a/src-db/database/model/functions/C_YEARPERIODS.xml	Tue Jan 29 09:44:54 2013 +0100
+++ b/src-db/database/model/functions/C_YEARPERIODS.xml	Tue Jan 29 10:29:47 2013 +0100
@@ -133,7 +133,7 @@
 	FROM C_PERIOD 
 	WHERE C_PERIOD_ID <> v_NextNo
 	AND AD_ORG_ID = v_Org_ID
-	AND AD_CLIENT_ID = AD_Client_ID
+	AND AD_CLIENT_ID = v_Client_ID
 	AND TO_DATE(ADD_MONTHS(v_StartDate, v_MonthNo-1)) <= ENDDATE 
 	AND ADD_MONTHS(TRUNC(TO_DATE(ADD_MONTHS(v_StartDate, v_MonthNo-1)), 'MM'), 1) -1 >= STARTDATE;