APPS.HR_H2PI_MAIN_UPLOAD dependencies on HR_H2PI_PAY_BASES

Line 25: DELETE FROM hr_h2pi_pay_bases

21:
22: DELETE FROM hr_h2pi_locations
23: WHERE client_id = p_from_client_id;
24:
25: DELETE FROM hr_h2pi_pay_bases
26: WHERE client_id = p_from_client_id;
27:
28: DELETE FROM hr_h2pi_hr_organizations
29: WHERE client_id = p_from_client_id;

Line 95: DELETE FROM hr_h2pi_pay_bases

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

Line 241: from hr_h2pi_pay_bases

237: where client_id = l_from_client_id;
238:
239: select l_stage_rec_count + count(*)
240: into l_stage_rec_count
241: from hr_h2pi_pay_bases
242: where client_id = l_from_client_id;
243:
244: select l_stage_rec_count + count(*)
245: into l_stage_rec_count