Rem drv: <migrate type="data_upgrade" version="10.2.0.4.0" pos="-"/>
Rem
Rem sidb_data_upgrade_102040.sql
Rem
Rem Copyright (c) 2007, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      sidb_data_upgrade_102040.sql - <one-line expansion of the name>
Rem
Rem    DESCRIPTION
Rem      <short description of component this file declares/defines>
Rem
Rem    NOTES
Rem      <other useful comments, qualifications, etc.>
Rem
Rem    MODIFIED   (MM/DD/YY)
Rem    bpaliwal    10/01/07 - 
Rem    mningomb    09/30/07 - 
Rem    bpaliwal    09/30/07 - Created
Rem

BEGIN

	UPDATE mgmt_paf_procedures
	SET base_guid =
	  (SELECT procedure_guid
	   FROM mgmt_paf_procedures procs,
	      (SELECT name,
	       application_name,
	       MIN(version) AS
	    min_version
	     FROM mgmt_paf_procedures
	     WHERE application_name = 'SIDB'
	     AND name = 'SIDBDP'
	     AND is_oracle = 'Y'
	     GROUP BY name,
	       application_name)
	  min_ver
	   WHERE procs.application_name = 'SIDB'
	   AND procs.name = 'SIDBDP'
	   AND procs.version = min_ver.min_version
	   AND procs.is_oracle = 'Y')
	WHERE application_name = 'SIDB'
	 AND name = 'SIDBDP'
	 AND is_oracle = 'Y';

	COMMIT;
	EXCEPTION WHEN OTHERS THEN NULL;
END;
/