DROP TABLE PF.PF_ANOMALIES_TMP CASCADE CONSTRAINTS;

CREATE GLOBAL TEMPORARY TABLE PF.PF_ANOMALIES_TMP
(
  ID                   VARCHAR2(10 BYTE)        NOT NULL,
  FVD_TYPE             VARCHAR2(10 BYTE)        NOT NULL,
  CLIENT_ID            VARCHAR2(10 BYTE),
  SEDOL_CODE           VARCHAR2(7 BYTE),
  PLAN_ID              VARCHAR2(10 BYTE),
  LTY_ID               VARCHAR2(10 BYTE),
  ORIG_PRICE_CCY       VARCHAR2(3 BYTE),
  CUSTOM_ANOMALY_DESC  VARCHAR2(300 BYTE),
  ANOMALY_ERROR_CODE   NUMBER(9)
)
ON COMMIT PRESERVE ROWS
NOCACHE;


DROP PUBLIC SYNONYM PF_ANOMALIES_TMP;

CREATE PUBLIC SYNONYM PF_ANOMALIES_TMP FOR PF.PF_ANOMALIES_TMP;


GRANT DELETE, INSERT, SELECT, UPDATE ON PF.PF_ANOMALIES_TMP TO PF_USER;

            OPEN anomalies_cursor
            FOR
                SELECT      pat.client_id
                FROM        pf_anomalies_tmp pat;

        RETURN anomalies_cursor