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
302: WHERE client_id = p_from_client_id
303: AND status = 'C';
304:
305: DELETE FROM hr_h2pi_bg_and_gre
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;
374:
375: DELETE FROM hr_h2pi_us_modified_geocodes
376: WHERE client_id = p_from_client_id;