SELECT  * FROM HRIS_OVERTIME WHERE
DESCRIPTION='THIS IS AUTOGENERATED OT REQUEST FROM COMPULSORY OT.' and overtime_date='19-AUG-18'
AND EMPLOYEE_ID IN (SELECT EMPLOYEE_ID FROM HRIS_EMPLOYEES WHERE employee_id=700061);

SELECT *  FROM HRIS_OVERTIME_DETAIL WHERE OVERTIME_ID IN (SELECT  OVERTIME_ID FROM HRIS_OVERTIME WHERE
DESCRIPTION='THIS IS AUTOGENERATED OT REQUEST FROM COMPULSORY OT.' and overtime_date='19-AUG-18'
AND EMPLOYEE_ID IN (SELECT EMPLOYEE_ID FROM HRIS_EMPLOYEES WHERE employee_id=700061));

SELECT * FROM HRIS_NOTIFICATION WHERE MESSAGE_TITLE ='Compulsory OT' 
AND MESSAGE_DESC=(SELECT 'OT REQUEST OF '||FULL_NAME||' FROM THE DATE 19-AUG-2018' FROM HRIS_EMPLOYEES WHERE EMPLOYEE_ID=700061);




DELETE FROM HRIS_OVERTIME_DETAIL WHERE OVERTIME_ID IN (SELECT  OVERTIME_ID FROM HRIS_OVERTIME WHERE
DESCRIPTION='THIS IS AUTOGENERATED OT REQUEST FROM COMPULSORY OT.' and overtime_date='19-AUG-18'
AND EMPLOYEE_ID IN (SELECT EMPLOYEE_ID FROM HRIS_EMPLOYEES WHERE employee_id=700061));

DELETE FROM HRIS_OVERTIME WHERE
DESCRIPTION='THIS IS AUTOGENERATED OT REQUEST FROM COMPULSORY OT.' and overtime_date='19-AUG-18'
AND EMPLOYEE_ID IN (SELECT EMPLOYEE_ID FROM HRIS_EMPLOYEES WHERE employee_id=700061);

DELETE FROM HRIS_NOTIFICATION WHERE MESSAGE_TITLE ='Compulsory OT' 
AND MESSAGE_DESC=(SELECT 'OT REQUEST OF '||FULL_NAME||' FROM THE DATE 19-AUG-2018' FROM HRIS_EMPLOYEES WHERE EMPLOYEE_ID=700061);