INSERT INTO HRIS_AUTO_NOTIFICATION(
    NOTIFICATION_HEAD_ID,
    NOTIFICATION_HEAD_NAME,
    FREQUENCY,
    LAST_EXECUTED_ON,
    EMAIL_FLAG,
    SYSTEM_NOTIFICATION_FLAG
) VALUES(
    1,
    'Birthday Notification',
    'D',
    null,
    'Y',
    'N'
);

INSERT INTO HRIS_AUTO_NOTIFICATION_QUERY(
NOTIFICATION_QUERY_ID,
NOTIFICATION_HEAD_ID,
QUERY,
PRIORITY_INDEX
) VALUES(
1,
1,
'SELECT * FROM HRIS_EMPLOYEES WHERE 
TO_CHAR(BIRTH_DATE, ''DD-MM'') = TO_CHAR(CURRENT_DATE, ''DD-MM'')',
1
);