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
310: WHERE client_id = p_from_client_id
311: AND status = 'C';
312:
313: DELETE FROM hr_h2pi_federal_tax_rules
359:
360: DELETE FROM hr_h2pi_pay_bases
361: WHERE client_id = p_from_client_id;
362:
363: DELETE FROM hr_h2pi_org_payment_methods
364: WHERE client_id = p_from_client_id;
365:
366: DELETE FROM hr_h2pi_element_types
367: WHERE client_id = p_from_client_id;