APPS.HR_H2PI_MAIN_UPLOAD dependencies on HR_H2PI_US_MODIFIED_GEOCODES

Line 113: DELETE FROM hr_h2pi_us_modified_geocodes

109:
110: DELETE FROM hr_h2pi_us_city_names
111: WHERE client_id = p_from_client_id;
112:
113: DELETE FROM hr_h2pi_us_modified_geocodes
114: WHERE client_id = p_from_client_id;
115:
116: END;
117:

Line 266: from hr_h2pi_us_modified_geocodes

262: where client_id = l_from_client_id;
263:
264: select l_stage_rec_count + count(*)
265: into l_stage_rec_count
266: from hr_h2pi_us_modified_geocodes
267: where client_id = l_from_client_id;
268:
269: hr_utility.set_location('Leaving:'|| l_proc, 30);
270: if l_stage_rec_count > 0 then