APPS.HR_H2PI_MAIN_UPLOAD dependencies on HR_H2PI_ELEMENT_NAMES

Line 79: DELETE FROM hr_h2pi_element_names

75:
76: DELETE FROM hr_h2pi_payment_methods
77: WHERE client_id = p_from_client_id;
78:
79: DELETE FROM hr_h2pi_element_names
80: WHERE client_id = p_from_client_id;
81:
82: DELETE FROM hr_h2pi_element_entries
83: WHERE client_id = p_from_client_id;

Line 176: from hr_h2pi_element_names

172: where client_id = l_from_client_id;
173:
174: select l_stage_rec_count + count(*)
175: into l_stage_rec_count
176: from hr_h2pi_element_names
177: where client_id = l_from_client_id;
178:
179: select l_stage_rec_count + count(*)
180: into l_stage_rec_count