APPS.HR_H2PI_MAIN_UPLOAD dependencies on HR_H2PI_ELEMENT_LINKS

Line 46: DELETE FROM hr_h2pi_element_links

42:
43: DELETE FROM hr_h2pi_input_values
44: WHERE client_id = p_from_client_id;
45:
46: DELETE FROM hr_h2pi_element_links
47: WHERE client_id = p_from_client_id;
48:
49: DELETE FROM hr_h2pi_bg_and_gre
50: WHERE client_id = p_from_client_id;

Line 107: DELETE FROM hr_h2pi_element_links

103:
104: DELETE FROM hr_h2pi_input_values
105: WHERE client_id = p_from_client_id;
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;

Line 171: from hr_h2pi_element_links

167: where client_id = l_from_client_id;
168:
169: select l_stage_rec_count + count(*)
170: into l_stage_rec_count
171: from hr_h2pi_element_links
172: where client_id = l_from_client_id;
173:
174: select l_stage_rec_count + count(*)
175: into l_stage_rec_count