APPS.HR_H2PI_MAIN_UPLOAD dependencies on HR_H2PI_PERIODS_OF_SERVICE

Line 19: DELETE FROM hr_h2pi_periods_of_service

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;
21:
22: DELETE FROM hr_h2pi_locations
23: WHERE client_id = p_from_client_id;

Line 246: from hr_h2pi_periods_of_service

242: where client_id = l_from_client_id;
243:
244: select l_stage_rec_count + count(*)
245: into l_stage_rec_count
246: from hr_h2pi_periods_of_service
247: where client_id = l_from_client_id;
248:
249: select l_stage_rec_count + count(*)
250: into l_stage_rec_count