The following lines contain the word 'select', 'insert', 'update' or 'delete':
DELETE FROM hr_h2pi_employees
WHERE client_id = p_from_client_id;
DELETE FROM hr_h2pi_addresses
WHERE client_id = p_from_client_id;
DELETE FROM hr_h2pi_assignments
WHERE client_id = p_from_client_id;
DELETE FROM hr_h2pi_periods_of_service
WHERE client_id = p_from_client_id;
DELETE FROM hr_h2pi_locations
WHERE client_id = p_from_client_id;
DELETE FROM hr_h2pi_pay_bases
WHERE client_id = p_from_client_id;
DELETE FROM hr_h2pi_hr_organizations
WHERE client_id = p_from_client_id;
DELETE FROM hr_h2pi_organization_class
WHERE client_id = p_from_client_id;
DELETE FROM hr_h2pi_organization_info
WHERE client_id = p_from_client_id;
DELETE FROM hr_h2pi_payrolls
WHERE client_id = p_from_client_id;
DELETE FROM hr_h2pi_element_types
WHERE client_id = p_from_client_id;
DELETE FROM hr_h2pi_input_values
WHERE client_id = p_from_client_id;
DELETE FROM hr_h2pi_element_links
WHERE client_id = p_from_client_id;
DELETE FROM hr_h2pi_bg_and_gre
WHERE client_id = p_from_client_id;
DELETE FROM hr_h2pi_org_payment_methods
WHERE client_id = p_from_client_id;
DELETE FROM hr_h2pi_patch_status
WHERE client_id = p_from_client_id;
DELETE FROM hr_h2pi_federal_tax_rules
WHERE client_id = p_from_client_id;
DELETE FROM hr_h2pi_state_tax_rules
WHERE client_id = p_from_client_id;
DELETE FROM hr_h2pi_county_tax_rules
WHERE client_id = p_from_client_id;
DELETE FROM hr_h2pi_city_tax_rules
WHERE client_id = p_from_client_id;
DELETE FROM hr_h2pi_salaries
WHERE client_id = p_from_client_id;
DELETE FROM hr_h2pi_cost_allocations
WHERE client_id = p_from_client_id;
DELETE FROM hr_h2pi_payment_methods
WHERE client_id = p_from_client_id;
DELETE FROM hr_h2pi_element_names
WHERE client_id = p_from_client_id;
DELETE FROM hr_h2pi_element_entries
WHERE client_id = p_from_client_id;
DELETE FROM hr_h2pi_element_entry_values
WHERE client_id = p_from_client_id;
DELETE FROM hr_h2pi_bg_and_gre
WHERE client_id = p_from_client_id;
DELETE FROM hr_h2pi_payrolls
WHERE client_id = p_from_client_id;
DELETE FROM hr_h2pi_pay_bases
WHERE client_id = p_from_client_id;
DELETE FROM hr_h2pi_org_payment_methods
WHERE client_id = p_from_client_id;
DELETE FROM hr_h2pi_element_types
WHERE client_id = p_from_client_id;
DELETE FROM hr_h2pi_input_values
WHERE client_id = p_from_client_id;
DELETE FROM hr_h2pi_element_links
WHERE client_id = p_from_client_id;
DELETE FROM hr_h2pi_us_city_names
WHERE client_id = p_from_client_id;
DELETE FROM hr_h2pi_us_modified_geocodes
WHERE client_id = p_from_client_id;
select l_stage_rec_count + count(*)
into l_stage_rec_count
from hr_h2pi_addresses
where client_id = l_from_client_id;
select l_stage_rec_count + count(*)
into l_stage_rec_count
from hr_h2pi_assignments
where client_id = l_from_client_id;
select l_stage_rec_count + count(*)
into l_stage_rec_count
from hr_h2pi_bg_and_gre
where client_id = l_from_client_id;
select l_stage_rec_count + count(*)
into l_stage_rec_count
from hr_h2pi_city_tax_rules
where client_id = l_from_client_id;
select l_stage_rec_count + count(*)
into l_stage_rec_count
from hr_h2pi_cost_allocations
where client_id = l_from_client_id;
select l_stage_rec_count + count(*)
into l_stage_rec_count
from hr_h2pi_county_tax_rules
where client_id = l_from_client_id;
select l_stage_rec_count + count(*)
into l_stage_rec_count
from hr_h2pi_element_entries
where client_id = l_from_client_id;
select l_stage_rec_count + count(*)
into l_stage_rec_count
from hr_h2pi_element_entry_values
where client_id = l_from_client_id;
select l_stage_rec_count + count(*)
into l_stage_rec_count
from hr_h2pi_element_links
where client_id = l_from_client_id;
select l_stage_rec_count + count(*)
into l_stage_rec_count
from hr_h2pi_element_names
where client_id = l_from_client_id;
select l_stage_rec_count + count(*)
into l_stage_rec_count
from hr_h2pi_element_types
where client_id = l_from_client_id;
select l_stage_rec_count + count(*)
into l_stage_rec_count
from hr_h2pi_employees
where client_id = l_from_client_id;
select l_stage_rec_count + count(*)
into l_stage_rec_count
from hr_h2pi_federal_tax_rules
where client_id = l_from_client_id;
select l_stage_rec_count + count(*)
into l_stage_rec_count
from hr_h2pi_hr_organizations
where client_id = l_from_client_id;
select l_stage_rec_count + count(*)
into l_stage_rec_count
from hr_h2pi_input_values
where client_id = l_from_client_id;
select l_stage_rec_count + count(*)
into l_stage_rec_count
from hr_h2pi_locations
where client_id = l_from_client_id;
select l_stage_rec_count + count(*)
into l_stage_rec_count
from hr_h2pi_organization_class
where client_id = l_from_client_id;
select l_stage_rec_count + count(*)
into l_stage_rec_count
from hr_h2pi_organization_info
where client_id = l_from_client_id;
select l_stage_rec_count + count(*)
into l_stage_rec_count
from hr_h2pi_org_payment_methods
where client_id = l_from_client_id;
select l_stage_rec_count + count(*)
into l_stage_rec_count
from hr_h2pi_patch_status
where client_id = l_from_client_id;
select l_stage_rec_count + count(*)
into l_stage_rec_count
from hr_h2pi_payment_methods
where client_id = l_from_client_id;
select l_stage_rec_count + count(*)
into l_stage_rec_count
from hr_h2pi_payrolls
where client_id = l_from_client_id;
select l_stage_rec_count + count(*)
into l_stage_rec_count
from hr_h2pi_pay_bases
where client_id = l_from_client_id;
select l_stage_rec_count + count(*)
into l_stage_rec_count
from hr_h2pi_periods_of_service
where client_id = l_from_client_id;
select l_stage_rec_count + count(*)
into l_stage_rec_count
from hr_h2pi_salaries
where client_id = l_from_client_id;
select l_stage_rec_count + count(*)
into l_stage_rec_count
from hr_h2pi_state_tax_rules
where client_id = l_from_client_id;
select l_stage_rec_count + count(*)
into l_stage_rec_count
from hr_h2pi_us_city_names
where client_id = l_from_client_id;
select l_stage_rec_count + count(*)
into l_stage_rec_count
from hr_h2pi_us_modified_geocodes
where client_id = l_from_client_id;
DELETE FROM hr_h2pi_message_lines
WHERE to_business_group_id = hr_h2pi_upload.g_to_business_group_id;