APPS.HR_H2PI_MAIN_UPLOAD dependencies on HR_H2PI_HR_ORGANIZATIONS

Line 28: DELETE FROM hr_h2pi_hr_organizations

24:
25: DELETE FROM hr_h2pi_pay_bases
26: WHERE client_id = p_from_client_id;
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;

Line 196: from hr_h2pi_hr_organizations

192: where client_id = l_from_client_id;
193:
194: select l_stage_rec_count + count(*)
195: into l_stage_rec_count
196: from hr_h2pi_hr_organizations
197: where client_id = l_from_client_id;
198:
199: select l_stage_rec_count + count(*)
200: into l_stage_rec_count