APPS.HR_H2PI_MAIN_UPLOAD dependencies on HR_H2PI_INPUT_VALUES

Line 43: DELETE FROM hr_h2pi_input_values

39:
40: DELETE FROM hr_h2pi_element_types
41: WHERE client_id = p_from_client_id;
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;

Line 104: DELETE FROM hr_h2pi_input_values

100:
101: DELETE FROM hr_h2pi_element_types
102: WHERE client_id = p_from_client_id;
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;

Line 201: from hr_h2pi_input_values

197: where client_id = l_from_client_id;
198:
199: select l_stage_rec_count + count(*)
200: into l_stage_rec_count
201: from hr_h2pi_input_values
202: where client_id = l_from_client_id;
203:
204: select l_stage_rec_count + count(*)
205: into l_stage_rec_count