delete script for HRIS SPC

use 'dps_hris_db';
delete from hris_emp_personalinfo where pi_id in (5,4,17,104,103,80,90,93,171,172);
delete from hris_assess_applicant where pi_id in (5,4,17,104,103,80,90,93,171,172);
delete from hris_benefits_offer where pi_id in (5,4,17,104,103,80,90,93,171,172);
delete from hris_demo_teaching_eval where pi_id in (5,4,17,104,103,80,90,93,171,172);
delete from hris_emp_affiliation where pi_id in (5,4,17,104,103,80,90,93,171,172);
delete from hris_emp_certification where pi_id in (5,4,17,104,103,80,90,93,171,172);
delete from hris_emp_charref where pi_id in (5,4,17,104,103,80,90,93,171,172);
delete from hris_emp_education where pi_id in (5,4,17,104,103,80,90,93,171,172);
delete from hris_emp_exam_result where pi_id in (5,4,17,104,103,80,90,93,171,172);
delete from hris_emp_otherinfo where pi_id in (5,4,17,104,103,80,90,93,171,172);