TRUNCATE cb_payroll_approval_invoice;
TRUNCATE cb_payroll_approval_invoice_details;
TRUNCATE cb_payroll_disbursement;
TRUNCATE cb_payroll_disbursement_details;
TRUNCATE cb_payroll_emf; 
TRUNCATE cb_payroll_emf_change;
TRUNCATE cb_payroll_emf_ext;
TRUNCATE cb_payroll_emf_file_info;
TRUNCATE cb_payroll_emf_history;
TRUNCATE cb_payroll_emf_log;
TRUNCATE cb_payroll_emf_types;
TRUNCATE cb_payroll_invoice_info;   
TRUNCATE cb_payroll_invoice_sattlement;
TRUNCATE cb_payroll_process;
TRUNCATE cb_payroll_process_error_log;
TRUNCATE cb_payroll_process_info;
TRUNCATE cb_payroll_process_log;
TRUNCATE cb_payroll_summary;
TRUNCATE tsk_assigned_task;
TRUNCATE tsk_assigned_task_details; 
TRUNCATE tsk_assigned_task_log;
TRUNCATE tsk_task_messages;
TRUNCATE cb_payroll_process_compositions;
TRUNCATE cb_payroll_tax_deductions;
TRUNCATE cb_payroll_payments_transactions;
TRUNCATE cb_payroll_payments_transactions_logs;

DELETE FROM approval_queue
WHERE module_id = (SELECT id FROM modules WHERE name LIKE 'payroll');