text: ------------------START------------------
  Insert into EG_PARTYTYPE (ID,CODE,PARENTID,DESCRIPTION,CREATEDBY,CREATEDDATE,LASTMODIFIEDBY,LASTMODIFIEDDATE) values (NEXTVAL('SEQ_EG_PARTYTYPE'),'Contractor',null,'Contractor',1,now(),null,now());
  -------------------END-------------------
  
  ------------------START------------------
  Insert into EGW_TYPEOFWORK (ID,CODE,PARENTID,DESCRIPTION,CREATEDBY,CREATEDDATE,LASTMODIFIEDBY,LASTMODIFIEDDATE,PARTYTYPEID) values (NEXTVAL('SEQ_EGW_TYPEOFWORK'),'Roads',null,'Roads',1,now(),null,null,(select id from EG_PARTYTYPE where code='Contractor'));
  Insert into EGW_TYPEOFWORK (ID,CODE,PARENTID,DESCRIPTION,CREATEDBY,CREATEDDATE,LASTMODIFIEDBY,LASTMODIFIEDDATE,PARTYTYPEID) values (NEXTVAL('SEQ_EGW_TYPEOFWORK'),'Footpath',null,'Footpath',1,now(),null,null,(select id from EG_PARTYTYPE where code='Contractor'));
  Insert into EGW_TYPEOFWORK (ID,CODE,PARENTID,DESCRIPTION,CREATEDBY,CREATEDDATE,LASTMODIFIEDBY,LASTMODIFIEDDATE,PARTYTYPEID) values (NEXTVAL('SEQ_EGW_TYPEOFWORK'),'Road Cut',null,'Road Cut Restoration',1,now(),null,null,(select id from EG_PARTYTYPE where code='Contractor'));
  Insert into EGW_TYPEOFWORK (ID,CODE,PARENTID,DESCRIPTION,CREATEDBY,CREATEDDATE,LASTMODIFIEDBY,LASTMODIFIEDDATE,PARTYTYPEID) values (NEXTVAL('SEQ_EGW_TYPEOFWORK'),'Storm Water Drain',null,'Storm Water Drain',1,now(),null,null,(select id from EG_PARTYTYPE where code='Contractor'));
  Insert into EGW_TYPEOFWORK (ID,CODE,PARENTID,DESCRIPTION,CREATEDBY,CREATEDDATE,LASTMODIFIEDBY,LASTMODIFIEDDATE,PARTYTYPEID) values (NEXTVAL('SEQ_EGW_TYPEOFWORK'),'Electrical',null,'Electrical',1,now(),null,null,(select id from EG_PARTYTYPE where code='Contractor'));
  Insert into EGW_TYPEOFWORK (ID,CODE,PARENTID,DESCRIPTION,CREATEDBY,CREATEDDATE,LASTMODIFIEDBY,LASTMODIFIEDDATE,PARTYTYPEID) values (NEXTVAL('SEQ_EGW_TYPEOFWORK'),'Culvert',null,'Culvert',1,now(),null,null,(select id from EG_PARTYTYPE where code='Contractor'));
  Insert into EGW_TYPEOFWORK (ID,CODE,PARENTID,DESCRIPTION,CREATEDBY,CREATEDDATE,LASTMODIFIEDBY,LASTMODIFIEDDATE,PARTYTYPEID) values (NEXTVAL('SEQ_EGW_TYPEOFWORK'),'Subway',null,'Subway',1,now(),null,null,(select id from EG_PARTYTYPE where code='Contractor'));
  Insert into EGW_TYPEOFWORK (ID,CODE,PARENTID,DESCRIPTION,CREATEDBY,CREATEDDATE,LASTMODIFIEDBY,LASTMODIFIEDDATE,PARTYTYPEID) values (NEXTVAL('SEQ_EGW_TYPEOFWORK'),'Grade Separator',null,'Flyovers',1,now(),null,null,(select id from EG_PARTYTYPE where code='Contractor'));
  Insert into EGW_TYPEOFWORK (ID,CODE,PARENTID,DESCRIPTION,CREATEDBY,CREATEDDATE,LASTMODIFIEDBY,LASTMODIFIEDDATE,PARTYTYPEID) values (NEXTVAL('SEQ_EGW_TYPEOFWORK'),'Buildings',null,'Buildings',1,now(),null,null,(select id from EG_PARTYTYPE where code='Contractor'));
  Insert into EGW_TYPEOFWORK (ID,CODE,PARENTID,DESCRIPTION,CREATEDBY,CREATEDDATE,LASTMODIFIEDBY,LASTMODIFIEDDATE,PARTYTYPEID) values (NEXTVAL('SEQ_EGW_TYPEOFWORK'),'Bridges',null,'Bridges',1,to_date('26-05-10','DD-MM-RR'),null,null,(select id from EG_PARTYTYPE where code='Contractor'));
  Insert into EGW_TYPEOFWORK (ID,CODE,PARENTID,DESCRIPTION,CREATEDBY,CREATEDDATE,LASTMODIFIEDBY,LASTMODIFIEDDATE,PARTYTYPEID) values (NEXTVAL('SEQ_EGW_TYPEOFWORK'),'Overbridges',null,'Overbridges',1,now(),null,null,(select id from EG_PARTYTYPE where code='Contractor'));
  Insert into EGW_TYPEOFWORK (ID,CODE,PARENTID,DESCRIPTION,CREATEDBY,CREATEDDATE,LASTMODIFIEDBY,LASTMODIFIEDDATE,PARTYTYPEID) values (NEXTVAL('SEQ_EGW_TYPEOFWORK'),'Parks',null,'Parks',1,now(),null,null,(select id from EG_PARTYTYPE where code='Contractor'));
  Insert into EGW_TYPEOFWORK (ID,CODE,PARENTID,DESCRIPTION,CREATEDBY,CREATEDDATE,LASTMODIFIEDBY,LASTMODIFIEDDATE,PARTYTYPEID) values (NEXTVAL('SEQ_EGW_TYPEOFWORK'),'Playfields',null,'Playfields',1,now(),null,null,(select id from EG_PARTYTYPE where code='Contractor'));
  Insert into EGW_TYPEOFWORK (ID,CODE,PARENTID,DESCRIPTION,CREATEDBY,CREATEDDATE,LASTMODIFIEDBY,LASTMODIFIEDDATE,PARTYTYPEID) values (NEXTVAL('SEQ_EGW_TYPEOFWORK'),'Slum roads-Forming',(select id from EGW_TYPEOFWORK where code='Roads'),'Slum roads - Forming',1,now(),null,null,(select id from EG_PARTYTYPE where code='Contractor'));
  Insert into EGW_TYPEOFWORK (ID,CODE,PARENTID,DESCRIPTION,CREATEDBY,CREATEDDATE,LASTMODIFIEDBY,LASTMODIFIEDDATE,PARTYTYPEID) values (NEXTVAL('SEQ_EGW_TYPEOFWORK'),'Slum roads-Relaying',(select id from EGW_TYPEOFWORK where code='Roads'),'Slum roads - Relaying',1,now(),null,null,(select id from EG_PARTYTYPE where code='Contractor'));
  Insert into EGW_TYPEOFWORK (ID,CODE,PARENTID,DESCRIPTION,CREATEDBY,CREATEDDATE,LASTMODIFIEDBY,LASTMODIFIEDDATE,PARTYTYPEID) values (NEXTVAL('SEQ_EGW_TYPEOFWORK'),'Slum road-Patch Work',(select id from EGW_TYPEOFWORK where code='Roads'),'Slum roads - Patch Work',1,now(),null,null,(select id from EG_PARTYTYPE where code='Contractor'));
  Insert into EGW_TYPEOFWORK (ID,CODE,PARENTID,DESCRIPTION,CREATEDBY,CREATEDDATE,LASTMODIFIEDBY,LASTMODIFIEDDATE,PARTYTYPEID) values (NEXTVAL('SEQ_EGW_TYPEOFWORK'),'Slum roads-Widening',(select id from EGW_TYPEOFWORK where code='Roads'),'Slum roads - Widening',1,now(),null,null,(select id from EG_PARTYTYPE where code='Contractor'));
  Insert into EGW_TYPEOFWORK (ID,CODE,PARENTID,DESCRIPTION,CREATEDBY,CREATEDDATE,LASTMODIFIEDBY,LASTMODIFIEDDATE,PARTYTYPEID) values (NEXTVAL('SEQ_EGW_TYPEOFWORK'),'Slum roads-Reforming',(select id from EGW_TYPEOFWORK where code='Roads'),'Slum roads - Reforming',1,now(),null,null,(select id from EG_PARTYTYPE where code='Contractor'));
  Insert into EGW_TYPEOFWORK (ID,CODE,PARENTID,DESCRIPTION,CREATEDBY,CREATEDDATE,LASTMODIFIEDBY,LASTMODIFIEDDATE,PARTYTYPEID) values (NEXTVAL('SEQ_EGW_TYPEOFWORK'),'Slum roads-Outlining',(select id from EGW_TYPEOFWORK where code='Roads'),'Slum roads - Outlining',1,now(),null,null,(select id from EG_PARTYTYPE where code='Contractor'));
  Insert into EGW_TYPEOFWORK (ID,CODE,PARENTID,DESCRIPTION,CREATEDBY,CREATEDDATE,LASTMODIFIEDBY,LASTMODIFIEDDATE,PARTYTYPEID) values (NEXTVAL('SEQ_EGW_TYPEOFWORK'),'Slum roads-Milling',(select id from EGW_TYPEOFWORK where code='Roads'),'Slum roads - Milling',1,now(),null,null,(select id from EG_PARTYTYPE where code='Contractor'));
  Insert into EGW_TYPEOFWORK (ID,CODE,PARENTID,DESCRIPTION,CREATEDBY,CREATEDDATE,LASTMODIFIEDBY,LASTMODIFIEDDATE,PARTYTYPEID) values (NEXTVAL('SEQ_EGW_TYPEOFWORK'),'IRR-Forming',(select id from EGW_TYPEOFWORK where code='Roads'),'IRR - Forming',1,now(),null,null,(select id from EG_PARTYTYPE where code='Contractor'));
  Insert into EGW_TYPEOFWORK (ID,CODE,PARENTID,DESCRIPTION,CREATEDBY,CREATEDDATE,LASTMODIFIEDBY,LASTMODIFIEDDATE,PARTYTYPEID) values (NEXTVAL('SEQ_EGW_TYPEOFWORK'),'IRR-Relaying',(select id from EGW_TYPEOFWORK where code='Roads'),'IRR - Relaying',1,now(),null,null,(select id from EG_PARTYTYPE where code='Contractor'));
  Insert into EGW_TYPEOFWORK (ID,CODE,PARENTID,DESCRIPTION,CREATEDBY,CREATEDDATE,LASTMODIFIEDBY,LASTMODIFIEDDATE,PARTYTYPEID) values (NEXTVAL('SEQ_EGW_TYPEOFWORK'),'IRR-Widening',(select id from EGW_TYPEOFWORK where code='Roads'),'IRR - Widening',1,now(),null,null,(select id from EG_PARTYTYPE where code='Contractor'));
  Insert into EGW_TYPEOFWORK (ID,CODE,PARENTID,DESCRIPTION,CREATEDBY,CREATEDDATE,LASTMODIFIEDBY,LASTMODIFIEDDATE,PARTYTYPEID) values (NEXTVAL('SEQ_EGW_TYPEOFWORK'),'IRR-Patch Work',(select id from EGW_TYPEOFWORK where code='Roads'),'IRR - Patch Work',1,now(),null,null,(select id from EG_PARTYTYPE where code='Contractor'));
  Insert into EGW_TYPEOFWORK (ID,CODE,PARENTID,DESCRIPTION,CREATEDBY,CREATEDDATE,LASTMODIFIEDBY,LASTMODIFIEDDATE,PARTYTYPEID) values (NEXTVAL('SEQ_EGW_TYPEOFWORK'),'IRR-Reforming',(select id from EGW_TYPEOFWORK where code='Roads'),'IRR - Reforming',1,now(),null,null,(select id from EG_PARTYTYPE where code='Contractor'));
  Insert into EGW_TYPEOFWORK (ID,CODE,PARENTID,DESCRIPTION,CREATEDBY,CREATEDDATE,LASTMODIFIEDBY,LASTMODIFIEDDATE,PARTYTYPEID) values (NEXTVAL('SEQ_EGW_TYPEOFWORK'),'IRR-Outlining',(select id from EGW_TYPEOFWORK where code='Roads'),'IRR - Outlining',1,now(),null,null,(select id from EG_PARTYTYPE where code='Contractor'));
  Insert into EGW_TYPEOFWORK (ID,CODE,PARENTID,DESCRIPTION,CREATEDBY,CREATEDDATE,LASTMODIFIEDBY,LASTMODIFIEDDATE,PARTYTYPEID) values (NEXTVAL('SEQ_EGW_TYPEOFWORK'),'IRR-Milling',(select id from EGW_TYPEOFWORK where code='Roads'),'IRR - Milling',1,now(),null,null,(select id from EG_PARTYTYPE where code='Contractor'));
  Insert into EGW_TYPEOFWORK (ID,CODE,PARENTID,DESCRIPTION,CREATEDBY,CREATEDDATE,LASTMODIFIEDBY,LASTMODIFIEDDATE,PARTYTYPEID) values (NEXTVAL('SEQ_EGW_TYPEOFWORK'),'BRR - Forming',(select id from EGW_TYPEOFWORK where code='Roads'),'BRR - Forming',1,now(),null,null,(select id from EG_PARTYTYPE where code='Contractor'));
  Insert into EGW_TYPEOFWORK (ID,CODE,PARENTID,DESCRIPTION,CREATEDBY,CREATEDDATE,LASTMODIFIEDBY,LASTMODIFIEDDATE,PARTYTYPEID) values (NEXTVAL('SEQ_EGW_TYPEOFWORK'),'BRR-Relaying',(select id from EGW_TYPEOFWORK where code='Roads'),'BRR - Relaying',1,now(),null,null,(select id from EG_PARTYTYPE where code='Contractor'));
  Insert into EGW_TYPEOFWORK (ID,CODE,PARENTID,DESCRIPTION,CREATEDBY,CREATEDDATE,LASTMODIFIEDBY,LASTMODIFIEDDATE,PARTYTYPEID) values (NEXTVAL('SEQ_EGW_TYPEOFWORK'),'BRR-Widening',(select id from EGW_TYPEOFWORK where code='Roads'),'BRR - Widening',1,now(),null,null,(select id from EG_PARTYTYPE where code='Contractor'));
  Insert into EGW_TYPEOFWORK (ID,CODE,PARENTID,DESCRIPTION,CREATEDBY,CREATEDDATE,LASTMODIFIEDBY,LASTMODIFIEDDATE,PARTYTYPEID) values (NEXTVAL('SEQ_EGW_TYPEOFWORK'),'BRR-Patch Work',(select id from EGW_TYPEOFWORK where code='Roads'),'BRR - Patch Work',1,now(),null,null,(select id from EG_PARTYTYPE where code='Contractor'));
  Insert into EGW_TYPEOFWORK (ID,CODE,PARENTID,DESCRIPTION,CREATEDBY,CREATEDDATE,LASTMODIFIEDBY,LASTMODIFIEDDATE,PARTYTYPEID) values (NEXTVAL('SEQ_EGW_TYPEOFWORK'),'BRR-Reforming',(select id from EGW_TYPEOFWORK where code='Roads'),'BRR - Reforming',1,now(),null,null,(select id from EG_PARTYTYPE where code='Contractor'));
  Insert into EGW_TYPEOFWORK (ID,CODE,PARENTID,DESCRIPTION,CREATEDBY,CREATEDDATE,LASTMODIFIEDBY,LASTMODIFIEDDATE,PARTYTYPEID) values (NEXTVAL('SEQ_EGW_TYPEOFWORK'),'BRR-Outlining',(select id from EGW_TYPEOFWORK where code='Roads'),'BRR - Outlining',1,now(),null,null,(select id from EG_PARTYTYPE where code='Contractor'));
  Insert into EGW_TYPEOFWORK (ID,CODE,PARENTID,DESCRIPTION,CREATEDBY,CREATEDDATE,LASTMODIFIEDBY,LASTMODIFIEDDATE,PARTYTYPEID) values (NEXTVAL('SEQ_EGW_TYPEOFWORK'),'BRR-Milling',(select id from EGW_TYPEOFWORK where code='Roads'),'BRR - Milling',1,now(),null,null,(select id from EG_PARTYTYPE where code='Contractor'));
  Insert into EGW_TYPEOFWORK (ID,CODE,PARENTID,DESCRIPTION,CREATEDBY,CREATEDDATE,LASTMODIFIEDBY,LASTMODIFIEDDATE,PARTYTYPEID) values (NEXTVAL('SEQ_EGW_TYPEOFWORK'),'Permanent',(select id from EGW_TYPEOFWORK where code='Road Cut'),'Permanent',1,now(),null,null,(select id from EG_PARTYTYPE where code='Contractor'));
  Insert into EGW_TYPEOFWORK (ID,CODE,PARENTID,DESCRIPTION,CREATEDBY,CREATEDDATE,LASTMODIFIEDBY,LASTMODIFIEDDATE,PARTYTYPEID) values (NEXTVAL('SEQ_EGW_TYPEOFWORK'),'Casual Labour',(select id from EGW_TYPEOFWORK where code='Road Cut'),'Casual Labour',1,now(),null,null,(select id from EG_PARTYTYPE where code='Contractor'));
  Insert into EGW_TYPEOFWORK (ID,CODE,PARENTID,DESCRIPTION,CREATEDBY,CREATEDDATE,LASTMODIFIEDBY,LASTMODIFIEDDATE,PARTYTYPEID) values (NEXTVAL('SEQ_EGW_TYPEOFWORK'),'Forming',(select id from EGW_TYPEOFWORK where code='Footpath'),'Forming',1,now(),null,null,(select id from EG_PARTYTYPE where code='Contractor'));
  Insert into EGW_TYPEOFWORK (ID,CODE,PARENTID,DESCRIPTION,CREATEDBY,CREATEDDATE,LASTMODIFIEDBY,LASTMODIFIEDDATE,PARTYTYPEID) values (NEXTVAL('SEQ_EGW_TYPEOFWORK'),'Improvement',(select id from EGW_TYPEOFWORK where code='Footpath'),'Improvement',1,now(),null,null,(select id from EG_PARTYTYPE where code='Contractor'));
  Insert into EGW_TYPEOFWORK (ID,CODE,PARENTID,DESCRIPTION,CREATEDBY,CREATEDDATE,LASTMODIFIEDBY,LASTMODIFIEDDATE,PARTYTYPEID) values (NEXTVAL('SEQ_EGW_TYPEOFWORK'),'Buildings-New',(select id from EGW_TYPEOFWORK where code='Buildings'),'Buildings-New',1,now(),null,null,(select id from EG_PARTYTYPE where code='Contractor'));
  Insert into EGW_TYPEOFWORK (ID,CODE,PARENTID,DESCRIPTION,CREATEDBY,CREATEDDATE,LASTMODIFIEDBY,LASTMODIFIEDDATE,PARTYTYPEID) values (NEXTVAL('SEQ_EGW_TYPEOFWORK'),'Buildings-Alteration',(select id from EGW_TYPEOFWORK where code='Buildings'),'Buildings-Alteration',1,now(),null,null,(select id from EG_PARTYTYPE where code='Contractor'));
  Insert into EGW_TYPEOFWORK (ID,CODE,PARENTID,DESCRIPTION,CREATEDBY,CREATEDDATE,LASTMODIFIEDBY,LASTMODIFIEDDATE,PARTYTYPEID) values (NEXTVAL('SEQ_EGW_TYPEOFWORK'),'Buildings-Maint ',(select id from EGW_TYPEOFWORK where code='Buildings'),'Buildings-Maintenance ',1,now(),null,null,(select id from EG_PARTYTYPE where code='Contractor'));
  Insert into EGW_TYPEOFWORK (ID,CODE,PARENTID,DESCRIPTION,CREATEDBY,CREATEDDATE,LASTMODIFIEDBY,LASTMODIFIEDDATE,PARTYTYPEID) values (NEXTVAL('SEQ_EGW_TYPEOFWORK'),'SWD-New',(select id from EGW_TYPEOFWORK where code='Storm Water Drain'),'SWD-New',1,now(),null,null,(select id from EG_PARTYTYPE where code='Contractor'));
  Insert into EGW_TYPEOFWORK (ID,CODE,PARENTID,DESCRIPTION,CREATEDBY,CREATEDDATE,LASTMODIFIEDBY,LASTMODIFIEDDATE,PARTYTYPEID) values (NEXTVAL('SEQ_EGW_TYPEOFWORK'),'SWD-Maintenance',(select id from EGW_TYPEOFWORK where code='Storm Water Drain'),'SWD-Maintenance',1,now(),null,null,(select id from EG_PARTYTYPE where code='Contractor'));
  Insert into EGW_TYPEOFWORK (ID,CODE,PARENTID,DESCRIPTION,CREATEDBY,CREATEDDATE,LASTMODIFIEDBY,LASTMODIFIEDDATE,PARTYTYPEID) values (NEXTVAL('SEQ_EGW_TYPEOFWORK'),'Electrical-New',(select id from EGW_TYPEOFWORK where code='Electrical'),'Electrical-New',1,now(),null,null,(select id from EG_PARTYTYPE where code='Contractor'));
  Insert into EGW_TYPEOFWORK (ID,CODE,PARENTID,DESCRIPTION,CREATEDBY,CREATEDDATE,LASTMODIFIEDBY,LASTMODIFIEDDATE,PARTYTYPEID) values (NEXTVAL('SEQ_EGW_TYPEOFWORK'),'Electrical-Maint',(select id from EGW_TYPEOFWORK where code='Electrical'),'Electrical-Maintenance',1,now(),null,null,(select id from EG_PARTYTYPE where code='Contractor'));
  Insert into EGW_TYPEOFWORK (ID,CODE,PARENTID,DESCRIPTION,CREATEDBY,CREATEDDATE,LASTMODIFIEDBY,LASTMODIFIEDDATE,PARTYTYPEID) values (NEXTVAL('SEQ_EGW_TYPEOFWORK'),'Culvert-Box',(select id from EGW_TYPEOFWORK where code='Culvert'),'Culvert-Box',1,now(),null,null,(select id from EG_PARTYTYPE where code='Contractor'));
  Insert into EGW_TYPEOFWORK (ID,CODE,PARENTID,DESCRIPTION,CREATEDBY,CREATEDDATE,LASTMODIFIEDBY,LASTMODIFIEDDATE,PARTYTYPEID) values (NEXTVAL('SEQ_EGW_TYPEOFWORK'),'Culvert-Slab',(select id from EGW_TYPEOFWORK where code='Culvert'),'Culvert-Slab',1,now(),null,null,(select id from EG_PARTYTYPE where code='Contractor'));
  Insert into EGW_TYPEOFWORK (ID,CODE,PARENTID,DESCRIPTION,CREATEDBY,CREATEDDATE,LASTMODIFIEDBY,LASTMODIFIEDDATE,PARTYTYPEID) values (NEXTVAL('SEQ_EGW_TYPEOFWORK'),'Subway-New',(select id from EGW_TYPEOFWORK where code='Subway'),'Subway-New',1,now(),null,null,(select id from EG_PARTYTYPE where code='Contractor'));
  Insert into EGW_TYPEOFWORK (ID,CODE,PARENTID,DESCRIPTION,CREATEDBY,CREATEDDATE,LASTMODIFIEDBY,LASTMODIFIEDDATE,PARTYTYPEID) values (NEXTVAL('SEQ_EGW_TYPEOFWORK'),'Subway-Maintenance',(select id from EGW_TYPEOFWORK where code='Subway'),'Subway-Maintenance',1,now(),null,null,(select id from EG_PARTYTYPE where code='Contractor'));
  Insert into EGW_TYPEOFWORK (ID,CODE,PARENTID,DESCRIPTION,CREATEDBY,CREATEDDATE,LASTMODIFIEDBY,LASTMODIFIEDDATE,PARTYTYPEID) values (NEXTVAL('SEQ_EGW_TYPEOFWORK'),'Overbridge-New',(select id from EGW_TYPEOFWORK where code='Overbridges'),'Overbridge-New',1,now(),null,null,(select id from EG_PARTYTYPE where code='Contractor'));
  Insert into EGW_TYPEOFWORK (ID,CODE,PARENTID,DESCRIPTION,CREATEDBY,CREATEDDATE,LASTMODIFIEDBY,LASTMODIFIEDDATE,PARTYTYPEID) values (NEXTVAL('SEQ_EGW_TYPEOFWORK'),'Overbridge-Maint',(select id from EGW_TYPEOFWORK where code='Overbridges'),'Overbridge-Maintenance',1,now(),null,null,(select id from EG_PARTYTYPE where code='Contractor'));
  Insert into EGW_TYPEOFWORK (ID,CODE,PARENTID,DESCRIPTION,CREATEDBY,CREATEDDATE,LASTMODIFIEDBY,LASTMODIFIEDDATE,PARTYTYPEID) values (NEXTVAL('SEQ_EGW_TYPEOFWORK'),'GradeSeparator-New',(select id from EGW_TYPEOFWORK where code='Grade Separator'),'GradeSeparator-New',1,now(),null,null,(select id from EG_PARTYTYPE where code='Contractor'));
  Insert into EGW_TYPEOFWORK (ID,CODE,PARENTID,DESCRIPTION,CREATEDBY,CREATEDDATE,LASTMODIFIEDBY,LASTMODIFIEDDATE,PARTYTYPEID) values (NEXTVAL('SEQ_EGW_TYPEOFWORK'),'GradeSeparator-Maint',(select id from EGW_TYPEOFWORK where code='Grade Separator'),'GradeSeparator-Maintenance',1,now(),null,null,(select id from EG_PARTYTYPE where code='Contractor'));
  Insert into EGW_TYPEOFWORK (ID,CODE,PARENTID,DESCRIPTION,CREATEDBY,CREATEDDATE,LASTMODIFIEDBY,LASTMODIFIEDDATE,PARTYTYPEID) values (NEXTVAL('SEQ_EGW_TYPEOFWORK'),'Bridges-New',(select id from EGW_TYPEOFWORK where code='Bridges'),'Bridges-New',1,now(),null,null,(select id from EG_PARTYTYPE where code='Contractor'));
  Insert into EGW_TYPEOFWORK (ID,CODE,PARENTID,DESCRIPTION,CREATEDBY,CREATEDDATE,LASTMODIFIEDBY,LASTMODIFIEDDATE,PARTYTYPEID) values (NEXTVAL('SEQ_EGW_TYPEOFWORK'),'Bridges-Maintenance',(select id from EGW_TYPEOFWORK where code='Bridges'),'Bridges-Maintenance',1,now(),null,null,(select id from EG_PARTYTYPE where code='Contractor'));
  -------------------END-------------------
  
  ------------------START------------------
  Insert into EGW_SCHEDULECATEGORY (ID,CODE,CREATED_BY,CREATED_DATE,DESCRIPTION,MODIFIED_BY,MODIFIED_DATE) values (NEXTVAL('SEQ_EGW_SCHEDULECATEGORY'),'BRIDGES',1,now(),'Bridges',null,null);
  Insert into EGW_SCHEDULECATEGORY (ID,CODE,CREATED_BY,CREATED_DATE,DESCRIPTION,MODIFIED_BY,MODIFIED_DATE) values (NEXTVAL('SEQ_EGW_SCHEDULECATEGORY'),'BUILDINGS',1,now(),'Buildings',null,null);
  -------------------END-------------------
  
  ------------------START------------------
  Insert into EGW_SCHEDULEOFRATE (ID,CODE,CREATED_BY,CREATED_DATE,DESCRIPTION,MODIFIED_BY,MODIFIED_DATE,UOM_ID,SOR_CATEGORY_ID) values (NEXTVAL('SEQ_EGW_SCHEDULEOFRATE'),'Br - 1',1,now(),'Drilling holes for piles of finished diameter of 1000 mm in all types of soil, pavement, all types of rock,weathered rock,Hard rock using rotary drilling equipment for depths upto 20 m  including all equipment, tools, labours, consumable, Bentonite, Casing materials and removal of all equipment,materials and debris  on completion of concreting etc. complete as directed by the Engineer.  ( Source :MoRTH  Standard data book for analysis of rates,First revision, Page   424) NOTE :     For depth beyond 20 m the rates will be :   1 )  Above 20 m   up to 25 m = The rate up to 20 m plus 5 pct. of the rate up to 20 m,2 )Above 25 m   up to 30 m = The rate up to 20 m plus 10 pct. of the rate up to 20 m and so on',1,now(),(select id from EG_UOM where UOM='MTR'),(select id from egw_schedulecategory where code='BRIDGES'));
  Insert into EGW_SCHEDULEOFRATE (ID,CODE,CREATED_BY,CREATED_DATE,DESCRIPTION,MODIFIED_BY,MODIFIED_DATE,UOM_ID,SOR_CATEGORY_ID) values (NEXTVAL('SEQ_EGW_SCHEDULEOFRATE'),'Br - 2',1,now(),'Drilling holes for piles of finished diameter of 1200 mm in all types of soil, pavement, all types of rock,weathered rock,Hard rock using rotary drilling equipment for depths upto 20 m  including all equipment, tools, labours, consumable, Bentonite, Casing materials and removal of all equipment,materials and debris  on completion of concreting etc. complete as directed by the Engineer.  ( Source :MoRTH  Standard data book for analysis of rates,First revision, Page   ,426 ) NOTE:    For depth beyond 20 m the rates will be :   1 )  Above 20 m   up to 25 m = The rate up to 20 m plus 5 pct. of the rate up to 20 m ,2 ) Above 25 m   up to 30 m = The rate up to 20 m plus 10 pct. of the rate up to 20 m and so on',1,now(),(select id from EG_UOM where UOM='MTR'),(select id from egw_schedulecategory where code='BRIDGES'));
  Insert into EGW_SCHEDULEOFRATE (ID,CODE,CREATED_BY,CREATED_DATE,DESCRIPTION,MODIFIED_BY,MODIFIED_DATE,UOM_ID,SOR_CATEGORY_ID) values (NEXTVAL('SEQ_EGW_SCHEDULEOFRATE'),'Br - 3',1,now(),'Providing  vibrated Reinforced controlled Ready Mix  cement concrete M35 design mix ( To be designed with the material to be used) using  20 mm ISS size HBG metal including cost and conveyance of all materials to site including cement, handling charges for the same,  mixing , lncluding placing the pump in position , erecting the horizontal and vertical pipe line to the required distance and height, laying in the holes drilled ,  providing cover blocks, tremie concreting,laying,using tremie compacting including curing all other tools and plants employed and all other incidental charges etc., complete ( Excluding cost and fabrication charges of steel and form work) confirming to MoRTH specifications, as directed by the Engineer for PILE CONCRETE 1000 mm Dia  ( Source :MoRTH  Standard data book for analysis of rates,First revision, Page   345 and 346 Case II,424 and 355 )',1,now(),(select id from EG_UOM where UOM='MTR'),(select id from egw_schedulecategory where code='BRIDGES'));
  Insert into EGW_SCHEDULEOFRATE (ID,CODE,CREATED_BY,CREATED_DATE,DESCRIPTION,MODIFIED_BY,MODIFIED_DATE,UOM_ID,SOR_CATEGORY_ID) values (NEXTVAL('SEQ_EGW_SCHEDULEOFRATE'),'Br - 4',1,now(),'Providing  vibrated Reinforced controlled Ready Mix  cement concrete M 40 design mix ( To be designed with the material to be used)using  20 mm ISS size  HBG metal including cost and conveyance of all materials to site including cement, handling charges for the same,  mixing , lncluding placing the pump in position , erecting the horizontal and vertical pipe line to the required distance and height, laying in the holes drilled ,  providing cover blocks, tremie concreting,laying,using tremie compacting including curing all other tools and plants employed and all other incidental charges etc., complete ( Excluding cost and fabrication charges of steel and form work) confirming to MoRTH specifications, as directed by the Engineer for PILE CONCRETE 1000 mm Dia  ( Source :MoRTH  Standard data book for analysis of rates,First revision, Page   482 and 483 Case II,424,355 )',1,now(),(select id from EG_UOM where UOM='MTR'),(select id from egw_schedulecategory where code='BRIDGES'));
  Insert into EGW_SCHEDULEOFRATE (ID,CODE,CREATED_BY,CREATED_DATE,DESCRIPTION,MODIFIED_BY,MODIFIED_DATE,UOM_ID,SOR_CATEGORY_ID) values (NEXTVAL('SEQ_EGW_SCHEDULEOFRATE'),'Br - 5',1,now(),'Providing  vibrated Reinforced controlled Ready Mix  cement concrete M35 design mix ( To be designed with the material to be used) using  20 mm ISS size  HBG metal cost and conveyance of all materials to site including cement, handling charges for the same,  mixing , lncluding placing the pump in position , erecting the horizontal and vertical pipe line to the required distance and height, laying in the holes drilled ,  providing cover blocks, tremie concreting,laying,using tremie compacting including curing all other tools and plants employed and all other incidental charges etc., complete ( Excluding cost and fabrication charges of steel and form work) confirming to MoRTH specifications, as directed by the Engineer.for PILE CONCRETE 1200 mm Dia  ( Source :MoRTH  Standard data book for analysis of rates,First revision, Page  345 and 346 Case II,426  and 355 )',1,now(),(select id from EG_UOM where UOM='MTR'),(select id from egw_schedulecategory where code='BRIDGES'));
  Insert into EGW_SCHEDULEOFRATE (ID,CODE,CREATED_BY,CREATED_DATE,DESCRIPTION,MODIFIED_BY,MODIFIED_DATE,UOM_ID,SOR_CATEGORY_ID) values (NEXTVAL('SEQ_EGW_SCHEDULEOFRATE'),'Br - 6',1,now(),'Providing  vibrated Reinforced controlled Ready Mix  cement concrete M 40 design mix ( To be designed with the material to be used) using  20 mm ISS size  HBG metal including cost and conveyance of all materials to site including cement, handling charges for the same,  mixing , lncluding placing the pump in position , erecting the horizontal and vertical pipe line to the required distance and height, laying in the holes drilled ,  providing cover blocks, tremie concreting,laying,using tremie compacting including curing all other tools and plants employed and all other incidental charges etc., complete ( Excluding cost and fabrication charges of steel and form work) confirming to MoRTH specifications, as directed by the Engineer.for PILE CONCRETE 1200 mm Dia. ( Source :MoRTH  Standard data book for analysis of rates,First revision, Page 482 and 483 Case  II, 426  and 355 )',1,now(),(select id from EG_UOM where UOM='MTR'),(select id from egw_schedulecategory where code='BRIDGES'));
  Insert into EGW_SCHEDULEOFRATE (ID,CODE,CREATED_BY,CREATED_DATE,DESCRIPTION,MODIFIED_BY,MODIFIED_DATE,UOM_ID,SOR_CATEGORY_ID) values (NEXTVAL('SEQ_EGW_SCHEDULEOFRATE'),'Br - 7',1,now(),'Stripping of concrete at pile  top of   piles for the required depth  to expose the pile reinforcement so as to anchor the same with pile cap reinforcement ,bending ,cleaning including labour charges, hire charges for tools and plants and all other incidental charges etc complete including cutting extra length of reinforcement if found necessary and as conforming MoRTH specification as directed by the Engineer.  ( Source :MoRTH  Standard data book for analysis of rates,First revision, Page   441 )',1,now(),(select id from EG_UOM where UOM='No'),(select id from egw_schedulecategory where code='BRIDGES'));
  Insert into EGW_SCHEDULEOFRATE (ID,CODE,CREATED_BY,CREATED_DATE,DESCRIPTION,MODIFIED_BY,MODIFIED_DATE,UOM_ID,SOR_CATEGORY_ID) values (NEXTVAL('SEQ_EGW_SCHEDULEOFRATE'),'Br - 8',1,now(),'Providing all equipment,kentledge, materials, instruments and manpower and conducting Initial Pile Load Test/Routine pile load test including preparation of pile, conducting observations and submitting Report, removing all arrangement, kentledge, etc., on Completion, but excluding cost of pile, complete as per IS:2911 Part IV and MOST specifications and as directed by the Engineer.',1,now(),(select id from EG_UOM where UOM='MTR'),(select id from egw_schedulecategory where code='BRIDGES'));
  Insert into EGW_SCHEDULEOFRATE (ID,CODE,CREATED_BY,CREATED_DATE,DESCRIPTION,MODIFIED_BY,MODIFIED_DATE,UOM_ID,SOR_CATEGORY_ID) values (NEXTVAL('SEQ_EGW_SCHEDULEOFRATE'),'Br - 9',1,now(),'Providing  vibrated  controlled cement concrete M 15 design mix using mixer machine ( To be designed with the material to be used) using  40 mm ISS size  HBG metal including cost and conveyance of all materials to site including cement, handling charges for the same,  mixing , laying , compacting , finishing smooth the surface, including vibration charges,curing concrete,   all other tools and plants employed and all other incidental charges etc., complete ( Excluding cost of form work) confirming to MoRTH specifications, as directed by the Engineer. ( Source :MoRTH  Standard data book for analysis of rates,First revision, Page   335,Case A)',1,now(),(select id from EG_UOM where UOM='CUM'),(select id from egw_schedulecategory where code='BRIDGES'));
  Insert into EGW_SCHEDULEOFRATE (ID,CODE,CREATED_BY,CREATED_DATE,DESCRIPTION,MODIFIED_BY,MODIFIED_DATE,UOM_ID,SOR_CATEGORY_ID) values (NEXTVAL('SEQ_EGW_SCHEDULEOFRATE'),'Br - 10',1,now(),'Providing  vibrated  controlled cement concrete M 15 design mix using mixer machine ( To be designed with the material to be used) using  20 mm ISS size  HBG metal including cost and conveyance of all materials to site including cement, handling charges for the same,  mixing , laying , compacting , finishing smooth the surface, including vibration charges,curing concrete,   all other tools and plants employed and all other incidental charges etc., complete ( Excluding cost of form work) confirming to MoRTH specifications, as directed by the Engineer.',1,now(),(select id from EG_UOM where UOM='CUM'),(select id from egw_schedulecategory where code='BRIDGES'));
  -------------------END-------------------
  
  ------------------START------------------
  Insert into EGW_SOR_RATE (ID,CREATED_BY,CREATED_DATE,MODIFIED_BY,MODIFIED_DATE,VALUE,STARTDATE,ENDDATE,SCHEDULEOFRATE_ID,MY_SOR_INDEX) values (NEXTVAL('SEQ_EGW_SOR_RATE'),1,now(),1,now(),2657.93,to_date('01-04-2015','DD-MM-YYYY'),null,(select id from egw_scheduleofrate where code='Br - 1'),0);
  Insert into EGW_SOR_RATE (ID,CREATED_BY,CREATED_DATE,MODIFIED_BY,MODIFIED_DATE,VALUE,STARTDATE,ENDDATE,SCHEDULEOFRATE_ID,MY_SOR_INDEX) values (NEXTVAL('SEQ_EGW_SOR_RATE'),1,now(),1,now(),3801.85,to_date('01-04-2015','DD-MM-YYYY'),null,(select id from egw_scheduleofrate where code='Br - 2'),0);
  Insert into EGW_SOR_RATE (ID,CREATED_BY,CREATED_DATE,MODIFIED_BY,MODIFIED_DATE,VALUE,STARTDATE,ENDDATE,SCHEDULEOFRATE_ID,MY_SOR_INDEX) values (NEXTVAL('SEQ_EGW_SOR_RATE'),1,now(),1,now(),2379.58,to_date('01-04-2015','DD-MM-YYYY'),null,(select id from egw_scheduleofrate where code='Br - 3'),0);
  Insert into EGW_SOR_RATE (ID,CREATED_BY,CREATED_DATE,MODIFIED_BY,MODIFIED_DATE,VALUE,STARTDATE,ENDDATE,SCHEDULEOFRATE_ID,MY_SOR_INDEX) values (NEXTVAL('SEQ_EGW_SOR_RATE'),1,now(),1,now(),3063.51,to_date('01-04-2015','DD-MM-YYYY'),null,(select id from egw_scheduleofrate where code='Br - 4'),0);
  Insert into EGW_SOR_RATE (ID,CREATED_BY,CREATED_DATE,MODIFIED_BY,MODIFIED_DATE,VALUE,STARTDATE,ENDDATE,SCHEDULEOFRATE_ID,MY_SOR_INDEX) values (NEXTVAL('SEQ_EGW_SOR_RATE'),1,now(),1,now(),3444.76,to_date('01-04-2015','DD-MM-YYYY'),null,(select id from egw_scheduleofrate where code='Br - 5'),0);
  Insert into EGW_SOR_RATE (ID,CREATED_BY,CREATED_DATE,MODIFIED_BY,MODIFIED_DATE,VALUE,STARTDATE,ENDDATE,SCHEDULEOFRATE_ID,MY_SOR_INDEX) values (NEXTVAL('SEQ_EGW_SOR_RATE'),1,now(),1,now(),3847.15,to_date('01-04-2015','DD-MM-YYYY'),null,(select id from egw_scheduleofrate where code='Br - 6'),0);
  Insert into EGW_SOR_RATE (ID,CREATED_BY,CREATED_DATE,MODIFIED_BY,MODIFIED_DATE,VALUE,STARTDATE,ENDDATE,SCHEDULEOFRATE_ID,MY_SOR_INDEX) values (NEXTVAL('SEQ_EGW_SOR_RATE'),1,now(),1,now(),247.5,to_date('01-04-2015','DD-MM-YYYY'),null,(select id from egw_scheduleofrate where code='Br - 7'),0);
  Insert into EGW_SOR_RATE (ID,CREATED_BY,CREATED_DATE,MODIFIED_BY,MODIFIED_DATE,VALUE,STARTDATE,ENDDATE,SCHEDULEOFRATE_ID,MY_SOR_INDEX) values (NEXTVAL('SEQ_EGW_SOR_RATE'),1,now(),1,now(),2328.28,to_date('01-04-2015','DD-MM-YYYY'),null,(select id from egw_scheduleofrate where code='Br - 8'),0);
  Insert into EGW_SOR_RATE (ID,CREATED_BY,CREATED_DATE,MODIFIED_BY,MODIFIED_DATE,VALUE,STARTDATE,ENDDATE,SCHEDULEOFRATE_ID,MY_SOR_INDEX) values (NEXTVAL('SEQ_EGW_SOR_RATE'),1,now(),1,now(),2689.6,to_date('01-04-2015','DD-MM-YYYY'),null,(select id from egw_scheduleofrate where code='Br - 9'),0);
  Insert into EGW_SOR_RATE (ID,CREATED_BY,CREATED_DATE,MODIFIED_BY,MODIFIED_DATE,VALUE,STARTDATE,ENDDATE,SCHEDULEOFRATE_ID,MY_SOR_INDEX) values (NEXTVAL('SEQ_EGW_SOR_RATE'),1,now(),1,now(),123.2,to_date('01-04-2015','DD-MM-YYYY'),null,(select id from egw_scheduleofrate where code='Br - 10'),0);
  -------------------END-------------------
  
  ------------------START------------------
  Insert into EGW_SCHEDULEOFRATE (ID,CODE,CREATED_BY,CREATED_DATE,DESCRIPTION,MODIFIED_BY,MODIFIED_DATE,UOM_ID,SOR_CATEGORY_ID) values (NEXTVAL('SEQ_EGW_SCHEDULEOFRATE'),'745',1,now(),'Supplying and fixing stone ware oblique or Y junction 100mmx100mm dia. in the existing sewer line including necessary earth work excavation, refilling, ramming, clearing bedris, carting materials, etc., complete upto 2m deep for1 no. (M.D.24)',1,now(),(select id from EG_UOM where UOM='No'),(select id from egw_schedulecategory where code='BUILDINGS'));
  Insert into EGW_SCHEDULEOFRATE (ID,CODE,CREATED_BY,CREATED_DATE,DESCRIPTION,MODIFIED_BY,MODIFIED_DATE,UOM_ID,SOR_CATEGORY_ID) values (NEXTVAL('SEQ_EGW_SCHEDULEOFRATE'),'746',1,now(),'Supplying and fixing stall urinal with 32mm dia bell mouth wastepipe, 15mm dia wheel valve and 15mm dia lead and brassconnection, etc.,complete.',1,now(),(select id from EG_UOM where UOM='No'),(select id from egw_schedulecategory where code='BUILDINGS'));
  Insert into EGW_SCHEDULEOFRATE (ID,CODE,CREATED_BY,CREATED_DATE,DESCRIPTION,MODIFIED_BY,MODIFIED_DATE,UOM_ID,SOR_CATEGORY_ID) values (NEXTVAL('SEQ_EGW_SCHEDULEOFRATE'),'747',1,now(),'Supplying and fixing white glazed squatting urinal of 60cm lengthin C.M.1:3 ( 1 cement and 3 river sand) and pointing with cement,finishing the surface neatly, curing, etc.,complete.',1,now(),(select id from EG_UOM where UOM='No'),(select id from egw_schedulecategory where code='BUILDINGS'));
  Insert into EGW_SCHEDULEOFRATE (ID,CODE,CREATED_BY,CREATED_DATE,DESCRIPTION,MODIFIED_BY,MODIFIED_DATE,UOM_ID,SOR_CATEGORY_ID) values (NEXTVAL('SEQ_EGW_SCHEDULEOFRATE'),'748',1,now(),'Supplying and fixing in position cast iron steps of approvedquality and make.',1,now(),(select id from EG_UOM where UOM='No'),(select id from egw_schedulecategory where code='BUILDINGS'));
  Insert into EGW_SCHEDULEOFRATE (ID,CODE,CREATED_BY,CREATED_DATE,DESCRIPTION,MODIFIED_BY,MODIFIED_DATE,UOM_ID,SOR_CATEGORY_ID) values (NEXTVAL('SEQ_EGW_SCHEDULEOFRATE'),'749',1,now(),'Providing locking arrangements over the C.I.cover with necessaryM.S.flats as directed during execution.',1,now(),(select id from EG_UOM where UOM='No'),(select id from egw_schedulecategory where code='BUILDINGS'));
  Insert into EGW_SCHEDULEOFRATE (ID,CODE,CREATED_BY,CREATED_DATE,DESCRIPTION,MODIFIED_BY,MODIFIED_DATE,UOM_ID,SOR_CATEGORY_ID) values (NEXTVAL('SEQ_EGW_SCHEDULEOFRATE'),'750',1,now(),'Supplying and fixing hand pump No.2 with coupling,washers and necessary accessories etc.,complete.',1,now(),(select id from EG_UOM where UOM='No'),(select id from egw_schedulecategory where code='BUILDINGS'));
  Insert into EGW_SCHEDULEOFRATE (ID,CODE,CREATED_BY,CREATED_DATE,DESCRIPTION,MODIFIED_BY,MODIFIED_DATE,UOM_ID,SOR_CATEGORY_ID) values (NEXTVAL('SEQ_EGW_SCHEDULEOFRATE'),'751',1,now(),'Supplying and fixing hand pump No.4 and coupling,washers andnecessary materials etc.,complete.',1,now(),(select id from EG_UOM where UOM='No'),(select id from egw_schedulecategory where code='BUILDINGS'));
  Insert into EGW_SCHEDULEOFRATE (ID,CODE,CREATED_BY,CREATED_DATE,DESCRIPTION,MODIFIED_BY,MODIFIED_DATE,UOM_ID,SOR_CATEGORY_ID) values (NEXTVAL('SEQ_EGW_SCHEDULEOFRATE'),'752',1,now(),'Sinking of Tube Well Pump No.4 with 40mm dia G.I.Pipe to a depth of 7.32m including filter point 40mm dia, 40mm dia G.M.check valve, 40mm dia Barrel nipple.  40mm dia coupling and necessary specials, including masonry pedestal in C.M.1:3 of size23x23x61cm and plastering in C.M.1:3,12mm thick,etc.,complete.',1,now(),(select id from EG_UOM where UOM='No'),(select id from egw_schedulecategory where code='BUILDINGS'));
  Insert into EGW_SCHEDULEOFRATE (ID,CODE,CREATED_BY,CREATED_DATE,DESCRIPTION,MODIFIED_BY,MODIFIED_DATE,UOM_ID,SOR_CATEGORY_ID) values (NEXTVAL('SEQ_EGW_SCHEDULEOFRATE'),'753',1,now(),'Country wood wrought and put up(scantling) for Trusses andRafters,etc.,',1,now(),(select id from EG_UOM where UOM='CUM'),(select id from egw_schedulecategory where code='BUILDINGS'));
  Insert into EGW_SCHEDULEOFRATE (ID,CODE,CREATED_BY,CREATED_DATE,DESCRIPTION,MODIFIED_BY,MODIFIED_DATE,UOM_ID,SOR_CATEGORY_ID) values (NEXTVAL('SEQ_EGW_SCHEDULEOFRATE'),'754',1,now(),'Honey comb work using stock bricks 1st sort 9"x4 1/2"x3" inC.M.1:3 ( 1 cement and 3 river sand) 3/4" thick joints.  Thejoints shall have 2 1/4" lap and maintaining 4 1/2" holes.  The exposed surfaces and holes shall be colour washed two coats of approved colour over one coat of white washing,etc.,complete.',1,now(),(select id from EG_UOM where UOM='SQM'),(select id from egw_schedulecategory where code='BUILDINGS'));
  -------------------END-------------------
  
  ------------------START------------------
  Insert into EGW_SOR_RATE (ID,CREATED_BY,CREATED_DATE,MODIFIED_BY,MODIFIED_DATE,VALUE,STARTDATE,ENDDATE,SCHEDULEOFRATE_ID,MY_SOR_INDEX) values (NEXTVAL('SEQ_EGW_SOR_RATE'),1,now(),1,now(),177,to_date('01-04-2015','DD-MM-YYYY'),null,(select id from egw_scheduleofrate where code='745'),0);
  Insert into EGW_SOR_RATE (ID,CREATED_BY,CREATED_DATE,MODIFIED_BY,MODIFIED_DATE,VALUE,STARTDATE,ENDDATE,SCHEDULEOFRATE_ID,MY_SOR_INDEX) values (NEXTVAL('SEQ_EGW_SOR_RATE'),1,now(),1,now(),266,to_date('01-04-2015','DD-MM-YYYY'),null,(select id from egw_scheduleofrate where code='746'),0);
  Insert into EGW_SOR_RATE (ID,CREATED_BY,CREATED_DATE,MODIFIED_BY,MODIFIED_DATE,VALUE,STARTDATE,ENDDATE,SCHEDULEOFRATE_ID,MY_SOR_INDEX) values (NEXTVAL('SEQ_EGW_SOR_RATE'),1,now(),1,now(),375,to_date('01-04-2015','DD-MM-YYYY'),null,(select id from egw_scheduleofrate where code='747'),0);
  Insert into EGW_SOR_RATE (ID,CREATED_BY,CREATED_DATE,MODIFIED_BY,MODIFIED_DATE,VALUE,STARTDATE,ENDDATE,SCHEDULEOFRATE_ID,MY_SOR_INDEX) values (NEXTVAL('SEQ_EGW_SOR_RATE'),1,now(),1,now(),444.4,to_date('01-04-2015','DD-MM-YYYY'),null,(select id from egw_scheduleofrate where code='748'),0);
  Insert into EGW_SOR_RATE (ID,CREATED_BY,CREATED_DATE,MODIFIED_BY,MODIFIED_DATE,VALUE,STARTDATE,ENDDATE,SCHEDULEOFRATE_ID,MY_SOR_INDEX) values (NEXTVAL('SEQ_EGW_SOR_RATE'),1,now(),1,now(),31621.6,to_date('01-04-2015','DD-MM-YYYY'),null,(select id from egw_scheduleofrate where code='749'),0);
  Insert into EGW_SOR_RATE (ID,CREATED_BY,CREATED_DATE,MODIFIED_BY,MODIFIED_DATE,VALUE,STARTDATE,ENDDATE,SCHEDULEOFRATE_ID,MY_SOR_INDEX) values (NEXTVAL('SEQ_EGW_SOR_RATE'),1,now(),1,now(),542,to_date('01-04-2015','DD-MM-YYYY'),null,(select id from egw_scheduleofrate where code='750'),0);
  Insert into EGW_SOR_RATE (ID,CREATED_BY,CREATED_DATE,MODIFIED_BY,MODIFIED_DATE,VALUE,STARTDATE,ENDDATE,SCHEDULEOFRATE_ID,MY_SOR_INDEX) values (NEXTVAL('SEQ_EGW_SOR_RATE'),1,now(),1,now(),694.1,to_date('01-04-2015','DD-MM-YYYY'),null,(select id from egw_scheduleofrate where code='751'),0);
  Insert into EGW_SOR_RATE (ID,CREATED_BY,CREATED_DATE,MODIFIED_BY,MODIFIED_DATE,VALUE,STARTDATE,ENDDATE,SCHEDULEOFRATE_ID,MY_SOR_INDEX) values (NEXTVAL('SEQ_EGW_SOR_RATE'),1,now(),1,now(),433.5,to_date('01-04-2015','DD-MM-YYYY'),null,(select id from egw_scheduleofrate where code='752'),0);
  Insert into EGW_SOR_RATE (ID,CREATED_BY,CREATED_DATE,MODIFIED_BY,MODIFIED_DATE,VALUE,STARTDATE,ENDDATE,SCHEDULEOFRATE_ID,MY_SOR_INDEX) values (NEXTVAL('SEQ_EGW_SOR_RATE'),1,now(),1,now(),215.6,to_date('01-04-2015','DD-MM-YYYY'),null,(select id from egw_scheduleofrate where code='753'),0);
  Insert into EGW_SOR_RATE (ID,CREATED_BY,CREATED_DATE,MODIFIED_BY,MODIFIED_DATE,VALUE,STARTDATE,ENDDATE,SCHEDULEOFRATE_ID,MY_SOR_INDEX) values (NEXTVAL('SEQ_EGW_SOR_RATE'),1,now(),1,now(),3778.1,to_date('01-04-2015','DD-MM-YYYY'),null,(select id from egw_scheduleofrate where code='754'),0);
  -------------------END-------------------
  
  
  --rollback delete from EGW_TYPEOFWORK;
  --rollback delete from EG_PARTYTYPE where CODE='Contractor';
  
  --rollback delete from EGW_SOR_RATE;
  --rollback delete from EGW_SCHEDULEOFRATE;
  --rollback delete from EGW_SCHEDULECATEGORY;
  
  