301: DELETE FROM hr_h2pi_element_links
302: WHERE client_id = p_from_client_id
303: AND status = 'C';
304:
305: DELETE FROM hr_h2pi_bg_and_gre
306: WHERE client_id = p_from_client_id
307: AND status = 'C';
308:
309: DELETE FROM hr_h2pi_org_payment_methods
350: WHERE client_id = p_from_client_id
351: AND status = 'C';
352:
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;