Insert into HRIS_FISCAL_YEARS (FISCAL_YEAR_ID,START_DATE,END_DATE,CREATED_DT,MODIFIED_DT,STATUS,REMARKS,FISCAL_YEAR_NAME) values (1,to_date('01-JUL-18','DD-MON-RR'),to_date('30-JUN-19','DD-MON-RR'),to_date('05-AUG-18','DD-MON-RR'),null,'E',null,'2018/2019');


Insert into HRIS_MONTH_CODE (FISCAL_YEAR_ID,MONTH_ID,MONTH_EDESC,MONTH_NDESC,FROM_DATE,TO_DATE,REMARKS,CREATED_DT,MODIFIED_DT,STATUS,YEAR,MONTH_NO,FISCAL_YEAR_MONTH_NO) values (1,1,'July','July',to_date('01-JUL-18','DD-MON-RR'),to_date('31-JUL-18','DD-MON-RR'),null,to_date('27-FEB-19','DD-MON-RR'),null,'E',2018,7,1);
Insert into HRIS_MONTH_CODE (FISCAL_YEAR_ID,MONTH_ID,MONTH_EDESC,MONTH_NDESC,FROM_DATE,TO_DATE,REMARKS,CREATED_DT,MODIFIED_DT,STATUS,YEAR,MONTH_NO,FISCAL_YEAR_MONTH_NO) values (1,2,'August','August',to_date('01-AUG-18','DD-MON-RR'),to_date('31-AUG-18','DD-MON-RR'),null,to_date('27-FEB-19','DD-MON-RR'),null,'E',2018,8,2);
Insert into HRIS_MONTH_CODE (FISCAL_YEAR_ID,MONTH_ID,MONTH_EDESC,MONTH_NDESC,FROM_DATE,TO_DATE,REMARKS,CREATED_DT,MODIFIED_DT,STATUS,YEAR,MONTH_NO,FISCAL_YEAR_MONTH_NO) values (1,3,'September','September',to_date('01-SEP-18','DD-MON-RR'),to_date('30-SEP-18','DD-MON-RR'),null,to_date('27-FEB-19','DD-MON-RR'),null,'E',2018,9,3);
Insert into HRIS_MONTH_CODE (FISCAL_YEAR_ID,MONTH_ID,MONTH_EDESC,MONTH_NDESC,FROM_DATE,TO_DATE,REMARKS,CREATED_DT,MODIFIED_DT,STATUS,YEAR,MONTH_NO,FISCAL_YEAR_MONTH_NO) values (1,4,'October','October',to_date('01-OCT-18','DD-MON-RR'),to_date('31-OCT-18','DD-MON-RR'),null,to_date('27-FEB-19','DD-MON-RR'),null,'E',2018,10,4);
Insert into HRIS_MONTH_CODE (FISCAL_YEAR_ID,MONTH_ID,MONTH_EDESC,MONTH_NDESC,FROM_DATE,TO_DATE,REMARKS,CREATED_DT,MODIFIED_DT,STATUS,YEAR,MONTH_NO,FISCAL_YEAR_MONTH_NO) values (1,5,'November','November',to_date('01-NOV-18','DD-MON-RR'),to_date('30-NOV-18','DD-MON-RR'),null,to_date('27-FEB-19','DD-MON-RR'),null,'E',2018,11,5);
Insert into HRIS_MONTH_CODE (FISCAL_YEAR_ID,MONTH_ID,MONTH_EDESC,MONTH_NDESC,FROM_DATE,TO_DATE,REMARKS,CREATED_DT,MODIFIED_DT,STATUS,YEAR,MONTH_NO,FISCAL_YEAR_MONTH_NO) values (1,6,'December','December',to_date('01-DEC-18','DD-MON-RR'),to_date('31-DEC-18','DD-MON-RR'),null,to_date('27-FEB-19','DD-MON-RR'),null,'E',2018,12,6);
Insert into HRIS_MONTH_CODE (FISCAL_YEAR_ID,MONTH_ID,MONTH_EDESC,MONTH_NDESC,FROM_DATE,TO_DATE,REMARKS,CREATED_DT,MODIFIED_DT,STATUS,YEAR,MONTH_NO,FISCAL_YEAR_MONTH_NO) values (1,7,'January','January',to_date('01-JAN-19','DD-MON-RR'),to_date('31-JAN-19','DD-MON-RR'),null,to_date('27-FEB-19','DD-MON-RR'),null,'E',2019,1,7);
Insert into HRIS_MONTH_CODE (FISCAL_YEAR_ID,MONTH_ID,MONTH_EDESC,MONTH_NDESC,FROM_DATE,TO_DATE,REMARKS,CREATED_DT,MODIFIED_DT,STATUS,YEAR,MONTH_NO,FISCAL_YEAR_MONTH_NO) values (1,8,'February','February',to_date('01-FEB-19','DD-MON-RR'),to_date('28-FEB-19','DD-MON-RR'),null,to_date('27-FEB-19','DD-MON-RR'),null,'E',2019,2,8);
Insert into HRIS_MONTH_CODE (FISCAL_YEAR_ID,MONTH_ID,MONTH_EDESC,MONTH_NDESC,FROM_DATE,TO_DATE,REMARKS,CREATED_DT,MODIFIED_DT,STATUS,YEAR,MONTH_NO,FISCAL_YEAR_MONTH_NO) values (1,9,'March','March',to_date('01-MAR-19','DD-MON-RR'),to_date('31-MAR-19','DD-MON-RR'),null,to_date('27-FEB-19','DD-MON-RR'),null,'E',2019,3,9);
Insert into HRIS_MONTH_CODE (FISCAL_YEAR_ID,MONTH_ID,MONTH_EDESC,MONTH_NDESC,FROM_DATE,TO_DATE,REMARKS,CREATED_DT,MODIFIED_DT,STATUS,YEAR,MONTH_NO,FISCAL_YEAR_MONTH_NO) values (1,10,'April','April',to_date('01-APR-19','DD-MON-RR'),to_date('30-APR-19','DD-MON-RR'),null,to_date('27-FEB-19','DD-MON-RR'),null,'E',2019,4,10);
Insert into HRIS_MONTH_CODE (FISCAL_YEAR_ID,MONTH_ID,MONTH_EDESC,MONTH_NDESC,FROM_DATE,TO_DATE,REMARKS,CREATED_DT,MODIFIED_DT,STATUS,YEAR,MONTH_NO,FISCAL_YEAR_MONTH_NO) values (1,11,'May','May',to_date('01-MAY-19','DD-MON-RR'),to_date('31-MAY-19','DD-MON-RR'),null,to_date('27-FEB-19','DD-MON-RR'),null,'E',2019,5,11);
Insert into HRIS_MONTH_CODE (FISCAL_YEAR_ID,MONTH_ID,MONTH_EDESC,MONTH_NDESC,FROM_DATE,TO_DATE,REMARKS,CREATED_DT,MODIFIED_DT,STATUS,YEAR,MONTH_NO,FISCAL_YEAR_MONTH_NO) values (1,12,'June','June',to_date('01-JUN-19','DD-MON-RR'),to_date('30-JUN-19','DD-MON-RR'),null,to_date('27-FEB-19','DD-MON-RR'),null,'E',2019,6,12);
