APPS.HR_H2PI_MAIN_UPLOAD dependencies on HR_H2PI_ELEMENT_TYPES

Line 40: DELETE FROM hr_h2pi_element_types

36:
37: DELETE FROM hr_h2pi_payrolls
38: WHERE client_id = p_from_client_id;
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;

Line 101: DELETE FROM hr_h2pi_element_types

97:
98: DELETE FROM hr_h2pi_org_payment_methods
99: WHERE client_id = p_from_client_id;
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;

Line 181: from hr_h2pi_element_types

177: where client_id = l_from_client_id;
178:
179: select l_stage_rec_count + count(*)
180: into l_stage_rec_count
181: from hr_h2pi_element_types
182: where client_id = l_from_client_id;
183:
184: select l_stage_rec_count + count(*)
185: into l_stage_rec_count