CREATE TABLE TB_PARAM_MST  
   (	PK_TB_COMPANY_CONF_PARAM NUMBER(10,0) NOT NULL ENABLE,  
	PARAMETER_NAME VARCHAR2(50 CHAR) NOT NULL ENABLE,  
	CREATED_ON DATE NOT NULL ENABLE,  
	CREATED_BY NUMBER(10,0) NOT NULL ENABLE,  
	MODIFIED_ON DATE,  
	MODIFIED_BY NUMBER(10,0),  
	REC_STATUS VARCHAR2(2 CHAR) NOT NULL ENABLE 
   ) 

CREATE TABLE TB_PARAM_DTL  
   (	PK_TB_COMPANY_CONF_REG_DEF NUMBER(10,0) NOT NULL ENABLE,  
	REGION_SHORT_CODE VARCHAR2(2 CHAR) NOT NULL ENABLE,  
	FK_TB_COMPANY_CONF_PARAM NUMBER(10,0) NOT NULL ENABLE,  
	DEFAULT_PARAM_VALUE VARCHAR2(100 CHAR),  
	CREATED_ON DATE NOT NULL ENABLE,  
	CREATED_BY NUMBER(10,0) NOT NULL ENABLE,  
	MODIFIED_ON DATE,  
	MODIFIED_BY NUMBER(10,0),  
	REC_STATUS VARCHAR2(2 CHAR) NOT NULL ENABLE 
   ) 

Insert into TB_PARAM_MST (PK_TB_COMPANY_CONF_PARAM,PARAMETER_NAME,CREATED_ON,CREATED_BY,MODIFIED_ON,MODIFIED_BY,REC_STATUS)  
values (44,'CLIENT ACCESS TO CSP',to_date('25-JAN-12','DD-MON-RR'),1,null,null,'AC')

Insert into TB_PARAM_MST (PK_TB_COMPANY_CONF_PARAM,PARAMETER_NAME,CREATED_ON,CREATED_BY,MODIFIED_ON,MODIFIED_BY,REC_STATUS)  
values (51,'CLIENT ACCESS TO OCA',to_date('25-JAN-12','DD-MON-RR'),1,null,null,'AC')

Insert into TB_PARAM_MST (PK_TB_COMPANY_CONF_PARAM,PARAMETER_NAME,CREATED_ON,CREATED_BY,MODIFIED_ON,MODIFIED_BY,REC_STATUS)  
values (53,'CLIENT ACCESS TO GCMS',to_date('25-JAN-12','DD-MON-RR'),1,null,null,'AC')

Insert into TB_PARAM_DTL (PK_TB_COMPANY_CONF_REG_DEF,REGION_SHORT_CODE,FK_TB_COMPANY_CONF_PARAM,DEFAULT_PARAM_VALUE,CREATED_ON,CREATED_BY,MODIFIED_ON,MODIFIED_BY,REC_STATUS)  
values (121,'NA',44,'Y',to_date('17-OCT-16','DD-MON-RR'),1,null,null,'AC')

Insert into TB_PARAM_DTL (PK_TB_COMPANY_CONF_REG_DEF,REGION_SHORT_CODE,FK_TB_COMPANY_CONF_PARAM,DEFAULT_PARAM_VALUE,CREATED_ON,CREATED_BY,MODIFIED_ON,MODIFIED_BY,REC_STATUS)  
values (147,'NA',44,'Y',to_date('19-OCT-16','DD-MON-RR'),1,null,null,'AC')

Insert into TB_PARAM_DTL (PK_TB_COMPANY_CONF_REG_DEF,REGION_SHORT_CODE,FK_TB_COMPANY_CONF_PARAM,DEFAULT_PARAM_VALUE,CREATED_ON,CREATED_BY,MODIFIED_ON,MODIFIED_BY,REC_STATUS)  
values (161,'NA',51,'Y',to_date('19-OCT-16','DD-MON-RR'),1,null,null,'AC')

Insert into TB_PARAM_DTL (PK_TB_COMPANY_CONF_REG_DEF,REGION_SHORT_CODE,FK_TB_COMPANY_CONF_PARAM,DEFAULT_PARAM_VALUE,CREATED_ON,CREATED_BY,MODIFIED_ON,MODIFIED_BY,REC_STATUS)  
values (163,'NA',53,'Login ID',to_date('19-OCT-16','DD-MON-RR'),1,null,null,'AC')