APPS.HR_H2PI_MAIN_UPLOAD dependencies on HR_H2PI_ORGANIZATION_CLASS

Line 31: DELETE FROM hr_h2pi_organization_class

27:
28: DELETE FROM hr_h2pi_hr_organizations
29: WHERE client_id = p_from_client_id;
30:
31: DELETE FROM hr_h2pi_organization_class
32: WHERE client_id = p_from_client_id;
33:
34: DELETE FROM hr_h2pi_organization_info
35: WHERE client_id = p_from_client_id;

Line 211: from hr_h2pi_organization_class

207: where client_id = l_from_client_id;
208:
209: select l_stage_rec_count + count(*)
210: into l_stage_rec_count
211: from hr_h2pi_organization_class
212: where client_id = l_from_client_id;
213:
214: select l_stage_rec_count + count(*)
215: into l_stage_rec_count