APPS.HR_H2PI_MAIN_UPLOAD dependencies on HR_H2PI_PATCH_STATUS

Line 55: DELETE FROM hr_h2pi_patch_status

51:
52: DELETE FROM hr_h2pi_org_payment_methods
53: WHERE client_id = p_from_client_id;
54:
55: DELETE FROM hr_h2pi_patch_status
56: WHERE client_id = p_from_client_id;
57:
58: DELETE FROM hr_h2pi_federal_tax_rules
59: WHERE client_id = p_from_client_id;

Line 226: from hr_h2pi_patch_status

222: where client_id = l_from_client_id;
223:
224: select l_stage_rec_count + count(*)
225: into l_stage_rec_count
226: from hr_h2pi_patch_status
227: where client_id = l_from_client_id;
228:
229: select l_stage_rec_count + count(*)
230: into l_stage_rec_count