78:
79: DELETE FROM hr_h2pi_element_names
80: WHERE client_id = p_from_client_id;
81:
82: DELETE FROM hr_h2pi_element_entries
83: WHERE client_id = p_from_client_id;
84:
85: DELETE FROM hr_h2pi_element_entry_values
86: WHERE client_id = p_from_client_id;
157: where client_id = l_from_client_id;
158:
159: select l_stage_rec_count + count(*)
160: into l_stage_rec_count
161: from hr_h2pi_element_entries
162: where client_id = l_from_client_id;
163:
164: select l_stage_rec_count + count(*)
165: into l_stage_rec_count