SET DEFINE OFF;
Insert into DATASOURCE_TEST
   (POLICYNO, POLICYISSUEDATE, POLICYINFORCEDATE, APPLICATIONCODE, POLICYSTATUS, 
    AGENTID, SERVICINGBRANCHID, BRANCHNAME, AURASTATUS, POLICYREJECTIONREASON, 
    APPLICATIONBRANCHRECVDATE, APPLICATIONSIGNDATE, APPLICATIONRECVDATE, PAYMENTMETHOD, PAYMENTFREQUENCY, 
    GROSSANNUALPREMIUM, PLANID, PLANDESCRIPTION, SALESCHANNELCD, SALESCHANNEL, 
    INITIALPREMIUM, UWDECDATE, MAIL_DATE, CVG_UWGDECN_CD, UW_DEC, 
    RCP_RECPT_DATE, AURA_STAT, POLICYDELIVERYDATE, POLICYSTATUSCHANGEDATE, MEDICAL_NONMEDICALFLAG, 
    HNI_TYPE, STP_FLAG, INPUTACCURACY_NCLEAN, UW_NCLEAN, LINE_NAME, 
    MEDICAL_NCLEAN)
 Values
   (1697608, TO_DATE('05/08/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), TO_DATE('05/08/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'A9527850', '1', 
    '181764', 235, 'GUWAHATI BRANCH', 3, NULL, 
    TO_DATE('05/05/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), TO_DATE('05/05/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), TO_DATE('05/07/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), '1', 12, 
    80000, '26F001', 'Gold Plus II FAV Term 8 Pay 3', 'DA', 'DSF Individual Agent', 
    80000, TO_DATE('05/08/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), TO_DATE('05/09/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'AC', 'Approved by the clear case process', 
    NULL, 'Accept Cases', NULL, TO_DATE('05/08/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), NULL, 
    NULL, NULL, NULL, NULL, NULL, 
    NULL);
Insert into DATASOURCE_TEST
   (POLICYNO, POLICYISSUEDATE, POLICYINFORCEDATE, APPLICATIONCODE, POLICYSTATUS, 
    AGENTID, SERVICINGBRANCHID, BRANCHNAME, AURASTATUS, POLICYREJECTIONREASON, 
    APPLICATIONBRANCHRECVDATE, APPLICATIONSIGNDATE, APPLICATIONRECVDATE, PAYMENTMETHOD, PAYMENTFREQUENCY, 
    GROSSANNUALPREMIUM, PLANID, PLANDESCRIPTION, SALESCHANNELCD, SALESCHANNEL, 
    INITIALPREMIUM, UWDECDATE, MAIL_DATE, CVG_UWGDECN_CD, UW_DEC, 
    RCP_RECPT_DATE, AURA_STAT, POLICYDELIVERYDATE, POLICYSTATUSCHANGEDATE, MEDICAL_NONMEDICALFLAG, 
    HNI_TYPE, STP_FLAG, INPUTACCURACY_NCLEAN, UW_NCLEAN, LINE_NAME, 
    MEDICAL_NCLEAN)
 Values
   (1820529, TO_DATE('07/22/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), TO_DATE('07/22/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'A6839544', '1', 
    '001295', 0, 'HEAD OFFICE - BIRLA SUN LIFE', 4, NULL, 
    TO_DATE('06/30/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), TO_DATE('06/30/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), TO_DATE('07/03/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), '1', 12, 
    9987.5, '23F001', 'Dream Plan- FAV Option 100%', 'A3', 'Alternate -Brokers', 
    9987.5, TO_DATE('07/22/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), TO_DATE('07/23/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'AE', 'Approved by an underwriter', 
    NULL, 'Cases due for interactive underwriting', NULL, TO_DATE('07/22/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), NULL, 
    NULL, NULL, NULL, NULL, NULL, 
    NULL);
Insert into DATASOURCE_TEST
   (POLICYNO, POLICYISSUEDATE, POLICYINFORCEDATE, APPLICATIONCODE, POLICYSTATUS, 
    AGENTID, SERVICINGBRANCHID, BRANCHNAME, AURASTATUS, POLICYREJECTIONREASON, 
    APPLICATIONBRANCHRECVDATE, APPLICATIONSIGNDATE, APPLICATIONRECVDATE, PAYMENTMETHOD, PAYMENTFREQUENCY, 
    GROSSANNUALPREMIUM, PLANID, PLANDESCRIPTION, SALESCHANNELCD, SALESCHANNEL, 
    INITIALPREMIUM, UWDECDATE, MAIL_DATE, CVG_UWGDECN_CD, UW_DEC, 
    RCP_RECPT_DATE, AURA_STAT, POLICYDELIVERYDATE, POLICYSTATUSCHANGEDATE, MEDICAL_NONMEDICALFLAG, 
    HNI_TYPE, STP_FLAG, INPUTACCURACY_NCLEAN, UW_NCLEAN, LINE_NAME, 
    MEDICAL_NCLEAN)
 Values
   (1990822, TO_DATE('08/28/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), NULL, 'A11109406', 'PERU', 
    '001408', 0, 'HEAD OFFICE - BIRLA SUN LIFE', 4, NULL, 
    TO_DATE('08/29/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), TO_DATE('08/29/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), TO_DATE('09/01/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), '1', 12, 
    12010.72, '23F001', 'Dream Plan- FAV Option 100%', 'A2', 'Alternate -Corporate Agents', 
    NULL, TO_DATE('09/02/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), NULL, 'PE', 'Pending a decision by an underwriter', 
    NULL, 'Cases due for interactive underwriting', NULL, TO_DATE('09/04/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), NULL, 
    NULL, NULL, NULL, NULL, NULL, 
    NULL);
Insert into DATASOURCE_TEST
   (POLICYNO, POLICYISSUEDATE, POLICYINFORCEDATE, APPLICATIONCODE, POLICYSTATUS, 
    AGENTID, SERVICINGBRANCHID, BRANCHNAME, AURASTATUS, POLICYREJECTIONREASON, 
    APPLICATIONBRANCHRECVDATE, APPLICATIONSIGNDATE, APPLICATIONRECVDATE, PAYMENTMETHOD, PAYMENTFREQUENCY, 
    GROSSANNUALPREMIUM, PLANID, PLANDESCRIPTION, SALESCHANNELCD, SALESCHANNEL, 
    INITIALPREMIUM, UWDECDATE, MAIL_DATE, CVG_UWGDECN_CD, UW_DEC, 
    RCP_RECPT_DATE, AURA_STAT, POLICYDELIVERYDATE, POLICYSTATUSCHANGEDATE, MEDICAL_NONMEDICALFLAG, 
    HNI_TYPE, STP_FLAG, INPUTACCURACY_NCLEAN, UW_NCLEAN, LINE_NAME, 
    MEDICAL_NCLEAN)
 Values
   (1762065, TO_DATE('06/16/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), TO_DATE('06/16/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'A11829883', '1', 
    'AZ1088', 825, 'Nandyal', 3, NULL, 
    TO_DATE('05/31/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), TO_DATE('05/31/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), TO_DATE('06/07/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), '1', 6, 
    6748.5, '23F001', 'Dream Plan- FAV Option 100%', 'DA', 'DSF Individual Agent', 
    3375, TO_DATE('06/16/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), TO_DATE('06/21/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'AC', 'Approved by the clear case process', 
    NULL, 'Accept Cases', NULL, TO_DATE('06/16/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), NULL, 
    NULL, NULL, NULL, NULL, NULL, 
    NULL);
Insert into DATASOURCE_TEST
   (POLICYNO, POLICYISSUEDATE, POLICYINFORCEDATE, APPLICATIONCODE, POLICYSTATUS, 
    AGENTID, SERVICINGBRANCHID, BRANCHNAME, AURASTATUS, POLICYREJECTIONREASON, 
    APPLICATIONBRANCHRECVDATE, APPLICATIONSIGNDATE, APPLICATIONRECVDATE, PAYMENTMETHOD, PAYMENTFREQUENCY, 
    GROSSANNUALPREMIUM, PLANID, PLANDESCRIPTION, SALESCHANNELCD, SALESCHANNEL, 
    INITIALPREMIUM, UWDECDATE, MAIL_DATE, CVG_UWGDECN_CD, UW_DEC, 
    RCP_RECPT_DATE, AURA_STAT, POLICYDELIVERYDATE, POLICYSTATUSCHANGEDATE, MEDICAL_NONMEDICALFLAG, 
    HNI_TYPE, STP_FLAG, INPUTACCURACY_NCLEAN, UW_NCLEAN, LINE_NAME, 
    MEDICAL_NCLEAN)
 Values
   (1762105, TO_DATE('06/16/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), TO_DATE('06/16/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'A9218227', '1', 
    'JR1645', 236, 'JORHAT', 3, NULL, 
    TO_DATE('06/03/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), TO_DATE('06/03/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), TO_DATE('06/07/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), '1', 6, 
    3607.45, '23F001', 'Dream Plan- FAV Option 100%', 'DA', 'DSF Individual Agent', 
    1804, TO_DATE('06/10/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), TO_DATE('06/18/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'AC', 'Approved by the clear case process', 
    NULL, 'Accept Cases', NULL, TO_DATE('06/16/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), NULL, 
    NULL, NULL, NULL, NULL, NULL, 
    NULL);
Insert into DATASOURCE_TEST
   (POLICYNO, POLICYISSUEDATE, POLICYINFORCEDATE, APPLICATIONCODE, POLICYSTATUS, 
    AGENTID, SERVICINGBRANCHID, BRANCHNAME, AURASTATUS, POLICYREJECTIONREASON, 
    APPLICATIONBRANCHRECVDATE, APPLICATIONSIGNDATE, APPLICATIONRECVDATE, PAYMENTMETHOD, PAYMENTFREQUENCY, 
    GROSSANNUALPREMIUM, PLANID, PLANDESCRIPTION, SALESCHANNELCD, SALESCHANNEL, 
    INITIALPREMIUM, UWDECDATE, MAIL_DATE, CVG_UWGDECN_CD, UW_DEC, 
    RCP_RECPT_DATE, AURA_STAT, POLICYDELIVERYDATE, POLICYSTATUSCHANGEDATE, MEDICAL_NONMEDICALFLAG, 
    HNI_TYPE, STP_FLAG, INPUTACCURACY_NCLEAN, UW_NCLEAN, LINE_NAME, 
    MEDICAL_NCLEAN)
 Values
   (1697646, TO_DATE('05/08/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), TO_DATE('05/08/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'A11090042', '1', 
    '731142', NULL, '-', 3, NULL, 
    TO_DATE('04/30/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), TO_DATE('04/30/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), TO_DATE('05/06/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), '1', 6, 
    5174, '23F001', 'Dream Plan- FAV Option 100%', 'DA', 'DSF Individual Agent', 
    2587, TO_DATE('05/08/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), TO_DATE('05/12/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'AC', 'Approved by the clear case process', 
    NULL, 'Accept Cases', NULL, TO_DATE('05/08/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), NULL, 
    NULL, NULL, NULL, NULL, NULL, 
    NULL);
Insert into DATASOURCE_TEST
   (POLICYNO, POLICYISSUEDATE, POLICYINFORCEDATE, APPLICATIONCODE, POLICYSTATUS, 
    AGENTID, SERVICINGBRANCHID, BRANCHNAME, AURASTATUS, POLICYREJECTIONREASON, 
    APPLICATIONBRANCHRECVDATE, APPLICATIONSIGNDATE, APPLICATIONRECVDATE, PAYMENTMETHOD, PAYMENTFREQUENCY, 
    GROSSANNUALPREMIUM, PLANID, PLANDESCRIPTION, SALESCHANNELCD, SALESCHANNEL, 
    INITIALPREMIUM, UWDECDATE, MAIL_DATE, CVG_UWGDECN_CD, UW_DEC, 
    RCP_RECPT_DATE, AURA_STAT, POLICYDELIVERYDATE, POLICYSTATUSCHANGEDATE, MEDICAL_NONMEDICALFLAG, 
    HNI_TYPE, STP_FLAG, INPUTACCURACY_NCLEAN, UW_NCLEAN, LINE_NAME, 
    MEDICAL_NCLEAN)
 Values
   (1990837, TO_DATE('08/26/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), NULL, 'A12199403', 'PERU', 
    'GV1043', 510, 'Muktsar', 4, NULL, 
    TO_DATE('08/26/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), TO_DATE('08/26/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), TO_DATE('09/01/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), '1', 3, 
    50000, '26F001', 'Gold Plus II FAV Term 8 Pay 3', 'DA', 'DSF Individual Agent', 
    NULL, TO_DATE('09/02/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), NULL, 'PE', 'Pending a decision by an underwriter', 
    NULL, 'Cases due for interactive underwriting', NULL, NULL, NULL, 
    NULL, NULL, NULL, NULL, NULL, 
    NULL);
Insert into DATASOURCE_TEST
   (POLICYNO, POLICYISSUEDATE, POLICYINFORCEDATE, APPLICATIONCODE, POLICYSTATUS, 
    AGENTID, SERVICINGBRANCHID, BRANCHNAME, AURASTATUS, POLICYREJECTIONREASON, 
    APPLICATIONBRANCHRECVDATE, APPLICATIONSIGNDATE, APPLICATIONRECVDATE, PAYMENTMETHOD, PAYMENTFREQUENCY, 
    GROSSANNUALPREMIUM, PLANID, PLANDESCRIPTION, SALESCHANNELCD, SALESCHANNEL, 
    INITIALPREMIUM, UWDECDATE, MAIL_DATE, CVG_UWGDECN_CD, UW_DEC, 
    RCP_RECPT_DATE, AURA_STAT, POLICYDELIVERYDATE, POLICYSTATUSCHANGEDATE, MEDICAL_NONMEDICALFLAG, 
    HNI_TYPE, STP_FLAG, INPUTACCURACY_NCLEAN, UW_NCLEAN, LINE_NAME, 
    MEDICAL_NCLEAN)
 Values
   (1820754, TO_DATE('07/18/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), TO_DATE('07/22/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'A10799702', '1', 
    '381252', 950, 'JAIPUR', 8, NULL, 
    TO_DATE('06/30/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), TO_DATE('06/30/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), TO_DATE('07/03/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), '1', 12, 
    19245, '25F001', 'Saral Jeevan - FAV', 'DA', 'DSF Individual Agent', 
    19245, TO_DATE('07/05/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), TO_DATE('07/26/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'AC', 'Approved by the clear case process', 
    NULL, 'Accept cases - Interactive Underwriting', TO_DATE('07/28/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), TO_DATE('07/22/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), NULL, 
    NULL, NULL, NULL, NULL, NULL, 
    NULL);
COMMIT;


data for requirementtable_test;


SET DEFINE OFF;
Insert into REQUIREMENTTABLE_TEST
   (POLICYNO, POLICYSTATUS, REQMNT_PPOLICY_CCLIENT_LEVEL, REQMNTID, REQMNTCREATEDATE, 
    REQMNTSTATUS, REQMNTEFFECTIVEDATE, TESTDATE, REQMNTTEXT, REQMNTRECEIVEDDATE, 
    REQMNTORDEREDDATE, REQMNTACCEPTEDDATE, REQMNTCANCELLEDDATE, REQMNTWAIVEDDATE)
 Values
   (1697608, '1', 'P', 'CWA', TO_DATE('04/13/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 
    'RAC', TO_DATE('04/13/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), TO_DATE('04/13/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), NULL, NULL, 
    NULL, NULL, NULL, NULL);
Insert into REQUIREMENTTABLE_TEST
   (POLICYNO, POLICYSTATUS, REQMNT_PPOLICY_CCLIENT_LEVEL, REQMNTID, REQMNTCREATEDATE, 
    REQMNTSTATUS, REQMNTEFFECTIVEDATE, TESTDATE, REQMNTTEXT, REQMNTRECEIVEDDATE, 
    REQMNTORDEREDDATE, REQMNTACCEPTEDDATE, REQMNTCANCELLEDDATE, REQMNTWAIVEDDATE)
 Values
   (1820529, '1', 'P', 'CWA', TO_DATE('07/08/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 
    'RAC', TO_DATE('07/08/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), TO_DATE('07/08/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), NULL, NULL, 
    NULL, NULL, NULL, NULL);
Insert into REQUIREMENTTABLE_TEST
   (POLICYNO, POLICYSTATUS, REQMNT_PPOLICY_CCLIENT_LEVEL, REQMNTID, REQMNTCREATEDATE, 
    REQMNTSTATUS, REQMNTEFFECTIVEDATE, TESTDATE, REQMNTTEXT, REQMNTRECEIVEDDATE, 
    REQMNTORDEREDDATE, REQMNTACCEPTEDDATE, REQMNTCANCELLEDDATE, REQMNTWAIVEDDATE)
 Values
   (1990822, '1', 'P', 'CWA', TO_DATE('06/15/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 
    'RAC', TO_DATE('06/15/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), TO_DATE('06/15/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), NULL, NULL, 
    NULL, NULL, NULL, NULL);
Insert into REQUIREMENTTABLE_TEST
   (POLICYNO, POLICYSTATUS, REQMNT_PPOLICY_CCLIENT_LEVEL, REQMNTID, REQMNTCREATEDATE, 
    REQMNTSTATUS, REQMNTEFFECTIVEDATE, TESTDATE, REQMNTTEXT, REQMNTRECEIVEDDATE, 
    REQMNTORDEREDDATE, REQMNTACCEPTEDDATE, REQMNTCANCELLEDDATE, REQMNTWAIVEDDATE)
 Values
   (1762065, '1', 'P', 'CWA', TO_DATE('07/08/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 
    'RAC', TO_DATE('07/08/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), TO_DATE('07/08/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), NULL, NULL, 
    NULL, NULL, NULL, NULL);
Insert into REQUIREMENTTABLE_TEST
   (POLICYNO, POLICYSTATUS, REQMNT_PPOLICY_CCLIENT_LEVEL, REQMNTID, REQMNTCREATEDATE, 
    REQMNTSTATUS, REQMNTEFFECTIVEDATE, TESTDATE, REQMNTTEXT, REQMNTRECEIVEDDATE, 
    REQMNTORDEREDDATE, REQMNTACCEPTEDDATE, REQMNTCANCELLEDDATE, REQMNTWAIVEDDATE)
 Values
   (1762105, 'R', 'P', 'CWA', TO_DATE('06/15/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 
    'RAC', TO_DATE('06/15/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), TO_DATE('06/15/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), NULL, NULL, 
    NULL, NULL, NULL, NULL);
Insert into REQUIREMENTTABLE_TEST
   (POLICYNO, POLICYSTATUS, REQMNT_PPOLICY_CCLIENT_LEVEL, REQMNTID, REQMNTCREATEDATE, 
    REQMNTSTATUS, REQMNTEFFECTIVEDATE, TESTDATE, REQMNTTEXT, REQMNTRECEIVEDDATE, 
    REQMNTORDEREDDATE, REQMNTACCEPTEDDATE, REQMNTCANCELLEDDATE, REQMNTWAIVEDDATE)
 Values
   (1697646, '1', 'P', 'REQ61', TO_DATE('06/18/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 
    'CAN', TO_DATE('06/28/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), NULL, 'INCOME PROOF REQUIRED, AS THE SUBMITTED BANK ACCOUNT STATEMENT IS NOT AUTHORIZED AND ATTESTED BY THE BANK', NULL, 
    NULL, NULL, TO_DATE('06/28/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), NULL);
Insert into REQUIREMENTTABLE_TEST
   (POLICYNO, POLICYSTATUS, REQMNT_PPOLICY_CCLIENT_LEVEL, REQMNTID, REQMNTCREATEDATE, 
    REQMNTSTATUS, REQMNTEFFECTIVEDATE, TESTDATE, REQMNTTEXT, REQMNTRECEIVEDDATE, 
    REQMNTORDEREDDATE, REQMNTACCEPTEDDATE, REQMNTCANCELLEDDATE, REQMNTWAIVEDDATE)
 Values
   (1990837, '1', 'P', 'EP', TO_DATE('05/27/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 
    'RAC', TO_DATE('06/13/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), NULL, 'EP=RS100.00  ANNUALLY', NULL, 
    TO_DATE('05/27/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), TO_DATE('06/13/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), NULL, NULL);
Insert into REQUIREMENTTABLE_TEST
   (POLICYNO, POLICYSTATUS, REQMNT_PPOLICY_CCLIENT_LEVEL, REQMNTID, REQMNTCREATEDATE, 
    REQMNTSTATUS, REQMNTEFFECTIVEDATE, TESTDATE, REQMNTTEXT, REQMNTRECEIVEDDATE, 
    REQMNTORDEREDDATE, REQMNTACCEPTEDDATE, REQMNTCANCELLEDDATE, REQMNTWAIVEDDATE)
 Values
   (1820754, 'I', 'P', 'CWA', TO_DATE('04/28/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 
    'RAC', TO_DATE('04/29/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), TO_DATE('04/29/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), NULL, NULL, 
    NULL, NULL, NULL, NULL);
Insert into REQUIREMENTTABLE_TEST
   (POLICYNO, POLICYSTATUS, REQMNT_PPOLICY_CCLIENT_LEVEL, REQMNTID, REQMNTCREATEDATE, 
    REQMNTSTATUS, REQMNTEFFECTIVEDATE, TESTDATE, REQMNTTEXT, REQMNTRECEIVEDDATE, 
    REQMNTORDEREDDATE, REQMNTACCEPTEDDATE, REQMNTCANCELLEDDATE, REQMNTWAIVEDDATE)
 Values
   (1681774, '1', 'P', 'CWA', TO_DATE('04/28/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 
    'RAC', TO_DATE('05/12/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), TO_DATE('05/12/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), NULL, NULL, 
    NULL, NULL, NULL, NULL);
Insert into REQUIREMENTTABLE_TEST
   (POLICYNO, POLICYSTATUS, REQMNT_PPOLICY_CCLIENT_LEVEL, REQMNTID, REQMNTCREATEDATE, 
    REQMNTSTATUS, REQMNTEFFECTIVEDATE, TESTDATE, REQMNTTEXT, REQMNTRECEIVEDDATE, 
    REQMNTORDEREDDATE, REQMNTACCEPTEDDATE, REQMNTCANCELLEDDATE, REQMNTWAIVEDDATE)
 Values
   (1654562, '1', 'P', 'CWA', TO_DATE('04/04/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 
    'RAC', TO_DATE('04/04/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), TO_DATE('04/04/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), NULL, NULL, 
    NULL, NULL, NULL, NULL);
COMMIT;