293: DELETE FROM hr_h2pi_element_types
294: WHERE client_id = p_from_client_id
295: AND status = 'C';
296:
297: DELETE FROM hr_h2pi_input_values
298: WHERE client_id = p_from_client_id
299: AND status = 'C';
300:
301: DELETE FROM hr_h2pi_element_links
365:
366: DELETE FROM hr_h2pi_element_types
367: WHERE client_id = p_from_client_id;
368:
369: DELETE FROM hr_h2pi_input_values
370: WHERE client_id = p_from_client_id;
371:
372: DELETE FROM hr_h2pi_element_links
373: WHERE client_id = p_from_client_id;