18:
19: DELETE FROM hr_h2pi_periods_of_service
20: WHERE client_id = p_from_client_id;
21:
22: DELETE FROM hr_h2pi_locations
23: WHERE client_id = p_from_client_id;
24:
25: DELETE FROM hr_h2pi_pay_bases
26: WHERE client_id = p_from_client_id;
202: where client_id = l_from_client_id;
203:
204: select l_stage_rec_count + count(*)
205: into l_stage_rec_count
206: from hr_h2pi_locations
207: where client_id = l_from_client_id;
208:
209: select l_stage_rec_count + count(*)
210: into l_stage_rec_count