/* $Id$ */
/*============================================================================*
 |                 Copyright (c) 2008 Applaud Solutions UK Ltd                |
 |                             All rights reserved                            |
 *===========================================================================*/

SET VERIFY OFF
SET FEEDBACK OFF
WHENEVER OSERROR  EXIT FAILURE ROLLBACK
WHENEVER SQLERROR EXIT FAILURE ROLLBACK

CREATE TABLE xxas_perf_review_steps
  (perf_review_step_id             number       NOT NULL PRIMARY KEY
  ,perf_review_form_id             number
  ,perf_review_templ_step_id       number  
  ,status_code                     varchar2(30)
  ,created_by               number              NOT NULL
  ,creation_date            date                NOT NULL
  ,last_update_date         date                NOT NULL
  ,last_updated_by          number              NOT NULL
  ,last_update_login        number              NOT NULL
  );
  
  GRANT ALL ON xxas_perf_review_steps TO &1 WITH GRANT OPTION;

COMMIT;
EXIT;