Index: openacs-4/packages/acs-service-contract/sql/oracle/upgrade/upgrade-4.5-4.5.1.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-service-contract/sql/oracle/upgrade/upgrade-4.5-4.5.1.sql,v
diff -u -N -r1.1 -r1.2
--- openacs-4/packages/acs-service-contract/sql/oracle/upgrade/upgrade-4.5-4.5.1.sql	17 Aug 2002 03:59:38 -0000	1.1
+++ openacs-4/packages/acs-service-contract/sql/oracle/upgrade/upgrade-4.5-4.5.1.sql	20 Aug 2002 21:05:04 -0000	1.2
@@ -172,7 +172,7 @@
        impl_pl				acs_sc_impl_aliases.impl_pl%TYPE
    ) return acs_sc_impl_aliases.impl_id%TYPE
    is
-       v_impl_id			acs_sc_impls.impl_id%TYPE;
+       v_impl_id		acs_sc_impls.impl_id%TYPE;
    begin
 
        v_impl_id := acs_sc_impl.get_id(impl_contract_name,impl_name);
@@ -203,14 +203,14 @@
        impl_operation_name	acs_sc_operations.operation_name%TYPE
    ) return acs_sc_impls.impl_id%TYPE
    is
-       v_impl_id			acs_sc_impls.impl_id%TYPE;
+       v_impl_id		acs_sc_impls.impl_id%TYPE;
    begin
        v_impl_id := acs_sc_impl.get_id(impl_contract_name,impl_name);
 
        delete from acs_sc_impl_aliases
-       where impl_contract_name = delete_alias.impl_contract_name
-       and impl_name = delete_alias.impl_name
-       and impl_operation_name = delete_alias.impl_operation_name;
+       where impl_contract_name = acs_sc_impl_alias.delete.impl_contract_name
+       and impl_name = acs_sc_impl_alias.delete.impl_name
+       and impl_operation_name = acs_sc_impl_alias.delete.impl_operation_name;
 
        return v_impl_id;
 
@@ -220,7 +220,6 @@
 /
 show errors
 
-
 -- UPGRADE ISSUE 2
 -- acs_sc_binding.exists_p was broken on Oracle if you installed
 -- tested a binding for which the implementation was installed, but the