swat

diff --git a/foundation-database/public/functions/postcccashreceipt.sql b/foundation-database/public/functions/postcccashreceipt.sql
index bbfbf2c..a282e1b 100644 (file)
--- a/foundation-database/public/functions/postcccashreceipt.sql
+++ b/foundation-database/public/functions/postcccashreceipt.sql
@@ -33,7 +33,7 @@ BEGIN
 
   IF (_c.ccard_type IS NOT NULL) THEN
     _cardType = _c.ccard_type;
-  ELSE IF (_c.ccpay_card_type IS NOT NULL) THEN
+  ELSIF (_c.ccpay_card_type IS NOT NULL) THEN
     -- Support External Pre-Auths where the Card Type is pushed into ccpay.
     -- There is no ccpay_ccard_id to join ccard on and get ccard_type.
     _cardType = _c.ccpay_card_type;

diff --git a/foundation-database/public/functions/postcccredit.sql b/foundation-database/public/functions/postcccredit.sql
index 6c0f09f..01f98be 100644 (file)
--- a/foundation-database/public/functions/postcccredit.sql
+++ b/foundation-database/public/functions/postcccredit.sql
@@ -52,7 +52,7 @@ BEGIN
 
   IF (_c.ccard_type IS NOT NULL) THEN
     _cardType = _c.ccard_type;
-  ELSE IF (_c.ccpay_card_type IS NOT NULL) THEN
+  ELSIF (_c.ccpay_card_type IS NOT NULL) THEN
     -- Support External Pre-Auths where the Card Type is pushed into ccpay.
     -- There is no ccpay_ccard_id to join ccard on and get ccard_type.
     _cardType = _c.ccpay_card_type;