APPS.HR_H2PI_MAIN_UPLOAD dependencies on HR_H2PI_US_CITY_NAMES

Line 110: DELETE FROM hr_h2pi_us_city_names

106:
107: DELETE FROM hr_h2pi_element_links
108: WHERE client_id = p_from_client_id;
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;

Line 261: from hr_h2pi_us_city_names

257: where client_id = l_from_client_id;
258:
259: select l_stage_rec_count + count(*)
260: into l_stage_rec_count
261: from hr_h2pi_us_city_names
262: where client_id = l_from_client_id;
263:
264: select l_stage_rec_count + count(*)
265: into l_stage_rec_count