285: DELETE FROM hr_h2pi_organization_info
286: WHERE client_id = p_from_client_id
287: AND status = 'C';
288:
289: DELETE FROM hr_h2pi_payrolls
290: WHERE client_id = p_from_client_id
291: AND status = 'C';
292:
293: DELETE FROM hr_h2pi_element_types
353:
354: DELETE FROM hr_h2pi_bg_and_gre
355: WHERE client_id = p_from_client_id;
356:
357: DELETE FROM hr_h2pi_payrolls
358: WHERE client_id = p_from_client_id;
359:
360: DELETE FROM hr_h2pi_pay_bases
361: WHERE client_id = p_from_client_id;