DROP SEQUENCE ACA.REQUEST_PROGRAM_S;

CREATE SEQUENCE ACA.REQUEST_PROGRAM_S
  START WITH 1
  MAXVALUE 9999999999999999999999999999
  MINVALUE 1
  NOCYCLE
  CACHE 50
  NOORDER;


CREATE OR REPLACE PUBLIC SYNONYM REQUEST_PROGRAM_S FOR ACA.REQUEST_PROGRAM_S;


GRANT SELECT ON ACA.REQUEST_PROGRAM_S TO ACA_SEQ_R;
DROP SEQUENCE ACA.HEALTH_CARE_PERIOD_S;

CREATE SEQUENCE ACA.HEALTH_CARE_PERIOD_S
  START WITH 947024
  MAXVALUE 9999999999999999999999999999
  MINVALUE 1
  NOCYCLE
  CACHE 50
  NOORDER;


CREATE OR REPLACE PUBLIC SYNONYM HEALTH_CARE_PERIOD_S FOR ACA.HEALTH_CARE_PERIOD_S;


GRANT SELECT ON ACA.HEALTH_CARE_PERIOD_S TO ACA_SEQ_R;
DROP SEQUENCE ACA.APPLICANT_IDENTITY_S;

CREATE SEQUENCE ACA.APPLICANT_IDENTITY_S
  START WITH 1151034
  MAXVALUE 9999999999999999999999999999
  MINVALUE 1
  NOCYCLE
  CACHE 50
  NOORDER;


CREATE OR REPLACE PUBLIC SYNONYM APPLICANT_IDENTITY_S FOR ACA.APPLICANT_IDENTITY_S;


GRANT SELECT ON ACA.APPLICANT_IDENTITY_S TO ACA_SEQ_R;
DROP SEQUENCE ACA.AFFORDABLE_CARE_REQUEST_S;

CREATE SEQUENCE ACA.AFFORDABLE_CARE_REQUEST_S
  START WITH 10120993
  MAXVALUE 9999999999999999999999999999
  MINVALUE 1
  NOCYCLE
  CACHE 50
  NOORDER;


CREATE OR REPLACE PUBLIC SYNONYM AFFORDABLE_CARE_REQUEST_S FOR ACA.AFFORDABLE_CARE_REQUEST_S;


GRANT SELECT ON ACA.AFFORDABLE_CARE_REQUEST_S TO ACA_SEQ_R;
