APPS.HR_H2PI_MAIN_UPLOAD dependencies on HR_H2PI_ASSIGNMENTS

Line 16: DELETE FROM hr_h2pi_assignments

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;
18:
19: DELETE FROM hr_h2pi_periods_of_service
20: WHERE client_id = p_from_client_id;

Line 136: from hr_h2pi_assignments

132: where client_id = l_from_client_id;
133: select l_stage_rec_count + count(*)
134:
135: into l_stage_rec_count
136: from hr_h2pi_assignments
137: where client_id = l_from_client_id;
138:
139: select l_stage_rec_count + count(*)
140: into l_stage_rec_count