CREATE TABLE cmp_cwb_intcpt_appr_dtls (
    MGR_PERSON_EVENT_ID       NUMBER(18, 0),
    BUSINESS_GROUP_ID         NUMBER(18, 0)    NOT NULL,
    APPROVER_ASSIGNMENT_ID    NUMBER(18, 0),
    MANAGER_ASSIGNMENT_ID     NUMBER(18, 0)    NOT NULL,
    PLAN_ID                   NUMBER(18, 0)    NOT NULL,
    PERIOD_ID                 NUMBER(18, 0)    NOT NULL,
    APPROVAL_CODE             VARCHAR2(120),
    APPROVAL_DATE             DATE         ,
    APPROVAL_COMMENTS         CLOB         ,
    OBJECT_VERSION_NUMBER     NUMBER(9, 0)     NOT NULL,
    CREATED_BY                VARCHAR2(256)    NOT NULL,
    CREATION_DATE             TIMESTAMP(6)     NOT NULL,
    LAST_UPDATED_BY           VARCHAR2(256)    NOT NULL,
    LAST_UPDATE_DATE          TIMESTAMP(6)     NOT NULL,
    LAST_UPDATE_LOGIN         VARCHAR2(128),
    MGR_PERSON_EVENT_ID       NUMBER(18, 0),
    BUSINESS_GROUP_ID         NUMBER(18, 0)    NOT NULL,
    APPROVER_ASSIGNMENT_ID    NUMBER(18, 0),
    MANAGER_ASSIGNMENT_ID     NUMBER(18, 0)    NOT NULL,
    PLAN_ID                   NUMBER(18, 0)    NOT NULL,
    PERIOD_ID                 NUMBER(18, 0)    NOT NULL,
    APPROVAL_CODE             VARCHAR2(120),
    APPROVAL_DATE             DATE         ,
    APPROVAL_COMMENTS         CLOB         ,
    OBJECT_VERSION_NUMBER     NUMBER(9, 0)     NOT NULL,
    CREATED_BY                VARCHAR2(256)    NOT NULL,
    CREATION_DATE             TIMESTAMP(6)     NOT NULL,
    LAST_UPDATED_BY           VARCHAR2(256)    NOT NULL,
    LAST_UPDATE_DATE          TIMESTAMP(6)     NOT NULL,
    LAST_UPDATE_LOGIN         VARCHAR2(128),
    CONSTRAINT pk_cmp_cwb_intcpt_appr_dtls PRIMARY KEY (MGR_PERSON_EVENT_ID, APPROVER_ASSIGNMENT_ID, MGR_PERSON_EVENT_ID, APPROVER_ASSIGNMENT_ID)
);
