APPS.HR_H2PI_MAIN_UPLOAD dependencies on HR_H2PI_ADDRESSES

Line 13: DELETE FROM hr_h2pi_addresses

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;
15:
16: DELETE FROM hr_h2pi_assignments
17: WHERE client_id = p_from_client_id;

Line 131: from hr_h2pi_addresses

127: l_from_client_id := hr_h2pi_upload.get_from_client_id;
128:
129: select l_stage_rec_count + count(*)
130: into l_stage_rec_count
131: from hr_h2pi_addresses
132: where client_id = l_from_client_id;
133: select l_stage_rec_count + count(*)
134:
135: into l_stage_rec_count