APPS.HR_H2PI_MAIN_UPLOAD dependencies on HR_H2PI_EMPLOYEES

Line 10: DELETE FROM hr_h2pi_employees

6: PROCEDURE clear_staging_tables (p_from_client_id NUMBER) IS
7:
8: BEGIN
9:
10: DELETE FROM hr_h2pi_employees
11: WHERE client_id = p_from_client_id;
12:
13: DELETE FROM hr_h2pi_addresses
14: WHERE client_id = p_from_client_id;

Line 186: from hr_h2pi_employees

182: where client_id = l_from_client_id;
183:
184: select l_stage_rec_count + count(*)
185: into l_stage_rec_count
186: from hr_h2pi_employees
187: where client_id = l_from_client_id;
188:
189: select l_stage_rec_count + count(*)
190: into l_stage_rec_count