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'),'OC Comparison Report','/application/citizen/occupancy-certificate/comparison-report',null,(select id from eg_module where name='BPA Transanctions'),
  (select max(ordernumber)+1 from EG_ACTION),'Citizen can view oc and bpa application comparison report','false','bpa',0,1,now(),1,now(),
  (select id from eg_module where name='BPA'));
  
  Insert into eg_roleaction (roleid,actionid) values ((select id from eg_role where name='BUSINESS'),
  (select id from eg_action where name='OC Comparison Report'));
  
  Insert into eg_roleaction (roleid,actionid) values ((select id from eg_role where name='CITIZEN'),
  (select id from eg_action where name='OC Comparison Report'));
  
  Insert into eg_roleaction (roleid,actionid) values ((select id from eg_role where name='BPA Approver'),
  (select id from eg_action where name='OC Comparison Report'));
  
  Insert into eg_roleaction (roleid,actionid) values ((select id from eg_role where name='SYSTEM'),
  (select id from eg_action where name='OC Comparison Report'));