text: INSERT INTO COMM_MEMBER_ROLES (COMM_MEMBER_ROLES_ID,COMM_MEMBERSHIP_ID_FK,MEMBERSHIP_ROLE_CODE,START_DATE,END_DATE,UPDATE_USER,UPDATE_TIMESTAMP,OBJ_ID,VER_NBR) 
      VALUES (SEQ_COMMITTEE_ID.NEXTVAL,(SELECT COMM_MEMBERSHIP_ID FROM COMM_MEMBERSHIPS WHERE PERSON_ID = '10000000005'),(SELECT MEMBERSHIP_ROLE_CODE FROM MEMBERSHIP_ROLE WHERE DESCRIPTION = 'Chair'),TO_DATE('20100701','YYYYMMDD'),TO_DATE('20150701','YYYYMMDD'),'quickstart',SYSDATE,SYS_GUID(),0)
  /
  INSERT INTO COMM_MEMBER_ROLES (COMM_MEMBER_ROLES_ID,COMM_MEMBERSHIP_ID_FK,MEMBERSHIP_ROLE_CODE,START_DATE,END_DATE,UPDATE_USER,UPDATE_TIMESTAMP,OBJ_ID,VER_NBR) 
      VALUES (SEQ_COMMITTEE_ID.NEXTVAL,(SELECT COMM_MEMBERSHIP_ID FROM COMM_MEMBERSHIPS WHERE PERSON_ID = '10000000006'),(SELECT MEMBERSHIP_ROLE_CODE FROM MEMBERSHIP_ROLE WHERE DESCRIPTION = 'Member'),TO_DATE('20100701','YYYYMMDD'),TO_DATE('20150701','YYYYMMDD'),'quickstart',SYSDATE,SYS_GUID(),0)
  /
  INSERT INTO COMM_MEMBER_ROLES (COMM_MEMBER_ROLES_ID,COMM_MEMBERSHIP_ID_FK,MEMBERSHIP_ROLE_CODE,START_DATE,END_DATE,UPDATE_USER,UPDATE_TIMESTAMP,OBJ_ID,VER_NBR) 
      VALUES (SEQ_COMMITTEE_ID.NEXTVAL,(SELECT COMM_MEMBERSHIP_ID FROM COMM_MEMBERSHIPS WHERE PERSON_ID = '10000000007'),(SELECT MEMBERSHIP_ROLE_CODE FROM MEMBERSHIP_ROLE WHERE DESCRIPTION = 'Alternate'),TO_DATE('20100701','YYYYMMDD'),TO_DATE('20150701','YYYYMMDD'),'quickstart',SYSDATE,SYS_GUID(),0)
  /
  INSERT INTO COMM_MEMBER_ROLES (COMM_MEMBER_ROLES_ID,COMM_MEMBERSHIP_ID_FK,MEMBERSHIP_ROLE_CODE,START_DATE,END_DATE,UPDATE_USER,UPDATE_TIMESTAMP,OBJ_ID,VER_NBR) 
      VALUES (SEQ_COMMITTEE_ID.NEXTVAL,(SELECT COMM_MEMBERSHIP_ID FROM COMM_MEMBERSHIPS WHERE PERSON_ID = '10000000008'),(SELECT MEMBERSHIP_ROLE_CODE FROM MEMBERSHIP_ROLE WHERE DESCRIPTION = 'Member'),TO_DATE('20080101','YYYYMMDD'),TO_DATE('20100701','YYYYMMDD'),'quickstart',SYSDATE,SYS_GUID(),0)
  /
  INSERT INTO COMM_MEMBER_ROLES (COMM_MEMBER_ROLES_ID,COMM_MEMBERSHIP_ID_FK,MEMBERSHIP_ROLE_CODE,START_DATE,END_DATE,UPDATE_USER,UPDATE_TIMESTAMP,OBJ_ID,VER_NBR) 
      VALUES (SEQ_COMMITTEE_ID.NEXTVAL,(SELECT COMM_MEMBERSHIP_ID FROM COMM_MEMBERSHIPS WHERE PERSON_ID = '10000000008'),(SELECT MEMBERSHIP_ROLE_CODE FROM MEMBERSHIP_ROLE WHERE DESCRIPTION = 'Inactive'),TO_DATE('20100702','YYYYMMDD'),TO_DATE('20120701','YYYYMMDD'),'quickstart',SYSDATE,SYS_GUID(),0)
  /
  INSERT INTO COMM_MEMBER_ROLES (COMM_MEMBER_ROLES_ID,COMM_MEMBERSHIP_ID_FK,MEMBERSHIP_ROLE_CODE,START_DATE,END_DATE,UPDATE_USER,UPDATE_TIMESTAMP,OBJ_ID,VER_NBR) 
      VALUES (SEQ_COMMITTEE_ID.NEXTVAL,(SELECT COMM_MEMBERSHIP_ID FROM COMM_MEMBERSHIPS WHERE PERSON_ID = '10000000008'),(SELECT MEMBERSHIP_ROLE_CODE FROM MEMBERSHIP_ROLE WHERE DESCRIPTION = 'Member'),TO_DATE('20120702','YYYYMMDD'),TO_DATE('20150701','YYYYMMDD'),'quickstart',SYSDATE,SYS_GUID(),0)
  /
  INSERT INTO COMM_MEMBER_ROLES (COMM_MEMBER_ROLES_ID,COMM_MEMBERSHIP_ID_FK,MEMBERSHIP_ROLE_CODE,START_DATE,END_DATE,UPDATE_USER,UPDATE_TIMESTAMP,OBJ_ID,VER_NBR) 
      VALUES (SEQ_COMMITTEE_ID.NEXTVAL,(SELECT COMM_MEMBERSHIP_ID FROM COMM_MEMBERSHIPS WHERE PERSON_ID = '10000000059'),(SELECT MEMBERSHIP_ROLE_CODE FROM MEMBERSHIP_ROLE WHERE DESCRIPTION = 'Member - Scientist'),TO_DATE('20010701','YYYYMMDD'),TO_DATE('20100701','YYYYMMDD'),'quickstart',SYSDATE,SYS_GUID(),0)
  /
  INSERT INTO COMM_MEMBER_ROLES (COMM_MEMBER_ROLES_ID,COMM_MEMBERSHIP_ID_FK,MEMBERSHIP_ROLE_CODE,START_DATE,END_DATE,UPDATE_USER,UPDATE_TIMESTAMP,OBJ_ID,VER_NBR) 
      VALUES (SEQ_COMMITTEE_ID.NEXTVAL,(SELECT COMM_MEMBERSHIP_ID FROM COMM_MEMBERSHIPS WHERE PERSON_ID = '10000000004'),(SELECT MEMBERSHIP_ROLE_CODE FROM MEMBERSHIP_ROLE WHERE DESCRIPTION = 'Prisoner Representative'),TO_DATE('20100701','YYYYMMDD'),TO_DATE('20130701','YYYYMMDD'),'quickstart',SYSDATE,SYS_GUID(),0)
  /
  INSERT INTO COMM_MEMBER_ROLES (COMM_MEMBER_ROLES_ID,COMM_MEMBERSHIP_ID_FK,MEMBERSHIP_ROLE_CODE,START_DATE,END_DATE,UPDATE_USER,UPDATE_TIMESTAMP,OBJ_ID,VER_NBR) 
      VALUES (SEQ_COMMITTEE_ID.NEXTVAL,(SELECT COMM_MEMBERSHIP_ID FROM COMM_MEMBERSHIPS WHERE PERSON_ID = '10000000002'),(SELECT MEMBERSHIP_ROLE_CODE FROM MEMBERSHIP_ROLE WHERE DESCRIPTION = 'Alternate'),TO_DATE('20100701','YYYYMMDD'),TO_DATE('20150701','YYYYMMDD'),'quickstart',SYSDATE,SYS_GUID(),0)
  /
  INSERT INTO COMM_MEMBER_ROLES (COMM_MEMBER_ROLES_ID,COMM_MEMBERSHIP_ID_FK,MEMBERSHIP_ROLE_CODE,START_DATE,END_DATE,UPDATE_USER,UPDATE_TIMESTAMP,OBJ_ID,VER_NBR) 
      VALUES (SEQ_COMMITTEE_ID.NEXTVAL,(SELECT COMM_MEMBERSHIP_ID FROM COMM_MEMBERSHIPS WHERE PERSON_ID = '10000000002'),(SELECT MEMBERSHIP_ROLE_CODE FROM MEMBERSHIP_ROLE WHERE DESCRIPTION = 'Member'),TO_DATE('20100701','YYYYMMDD'),TO_DATE('20150701','YYYYMMDD'),'quickstart',SYSDATE,SYS_GUID(),0)
  /
  