269: DELETE FROM hr_h2pi_locations
270: WHERE client_id = p_from_client_id
271: AND status = 'C';
272:
273: DELETE FROM hr_h2pi_pay_bases
274: WHERE client_id = p_from_client_id
275: AND status = 'C';
276:
277: DELETE FROM hr_h2pi_hr_organizations
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;
362:
363: DELETE FROM hr_h2pi_org_payment_methods
364: WHERE client_id = p_from_client_id;