APPS.HR_H2PI_MAIN_UPLOAD dependencies on HR_H2PI_BG_AND_GRE

Line 49: DELETE FROM hr_h2pi_bg_and_gre

45:
46: DELETE FROM hr_h2pi_element_links
47: WHERE client_id = p_from_client_id;
48:
49: DELETE FROM hr_h2pi_bg_and_gre
50: WHERE client_id = p_from_client_id;
51:
52: DELETE FROM hr_h2pi_org_payment_methods
53: WHERE client_id = p_from_client_id;

Line 89: DELETE FROM hr_h2pi_bg_and_gre

85: DELETE FROM hr_h2pi_element_entry_values
86: WHERE client_id = p_from_client_id;
87:
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;

Line 141: from hr_h2pi_bg_and_gre

137: where client_id = l_from_client_id;
138:
139: select l_stage_rec_count + count(*)
140: into l_stage_rec_count
141: from hr_h2pi_bg_and_gre
142: where client_id = l_from_client_id;
143:
144: select l_stage_rec_count + count(*)
145: into l_stage_rec_count

Line 321: p_table_name => 'HR_H2PI_BG_AND_GRE',

317: IF l_from_business_group_id = -1 THEN
318: hr_utility.set_location(l_proc, 20);
319: hr_h2pi_error.data_error
320: (p_from_id => hr_h2pi_upload.g_to_business_group_id,
321: p_table_name => 'HR_H2PI_BG_AND_GRE',
322: p_message_level => 'FATAL',
323: p_message_name => 'HR_289241_MAPPING_ID_MISSING');
324: END IF;
325: