APPS.HR_H2PI_MAIN_UPLOAD dependencies on HR_H2PI_PAYROLLS

Line 37: DELETE FROM hr_h2pi_payrolls

33:
34: DELETE FROM hr_h2pi_organization_info
35: WHERE client_id = p_from_client_id;
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;

Line 92: DELETE FROM hr_h2pi_payrolls

88:
89: DELETE FROM hr_h2pi_bg_and_gre
90: WHERE client_id = p_from_client_id;
91:
92: DELETE FROM hr_h2pi_payrolls
93: WHERE client_id = p_from_client_id;
94:
95: DELETE FROM hr_h2pi_pay_bases
96: WHERE client_id = p_from_client_id;

Line 236: from hr_h2pi_payrolls

232: where client_id = l_from_client_id;
233:
234: select l_stage_rec_count + count(*)
235: into l_stage_rec_count
236: from hr_h2pi_payrolls
237: where client_id = l_from_client_id;
238:
239: select l_stage_rec_count + count(*)
240: into l_stage_rec_count