text: 
  insert into EG_ACTION (id,name,url,queryparams,parentmodule,ordernumber,displayname,enabled,contextroot,version,createdby,createddate,lastmodifiedby,lastmodifieddate,application) values (nextval('SEQ_EG_ACTION'),'Add/Edit DCB','/search/searchProperty-commonForm.action','applicationType=Add_demand',(select id from eg_module where name='Existing property'),1,'Add Demand',true,'ptis',0,1,now(),1,now(),(select id from eg_module where name='Property Tax'));
  
  Insert into EG_ACTION (id,name,url,queryparams,parentmodule,ordernumber,displayname,enabled,contextroot,version,createdby,createddate,lastmodifiedby,lastmodifieddate,application) values (nextval('SEQ_EG_ACTION'),'Add/Edit DCB Form','/edit/addDemand-newAddForm.action',null,(select id from eg_module where name='Existing property'),1,'Add/Edit DCB Form',false,'ptis',0,1,now(),1,now(),(select id from eg_module where name='Property Tax'));
  
  Insert into EG_ACTION (id,name,url,queryparams,parentmodule,ordernumber,displayname,enabled,contextroot,version,createdby,createddate,lastmodifiedby,lastmodifieddate,application) values (nextval('SEQ_EG_ACTION'),'Add/Edit DCB Update Form','/edit/addDemand-update.action',null,(select id from eg_module where name='Existing property'),1,'Add/Edit DCB Form',false,'ptis',0,1,now(),1,now(),(select id from eg_module where name='Property Tax'));
  
  insert into eg_roleaction (actionid, roleid) select (select id from eg_action where name = 'Add/Edit DCB' and contextroot='ptis'), id from eg_role where name in ('Property Approver');
  
  insert into eg_roleaction (actionid, roleid) select (select id from eg_action where name = 'Add/Edit DCB Form' and contextroot='ptis'), id from eg_role where name in ('Property Approver');
  
  insert into eg_roleaction (actionid, roleid) select (select id from eg_action where name = 'Add/Edit DCB Update Form' and contextroot='ptis'), id from eg_role where name in ('Property Approver');
  
  