APPS.HR_H2PI_DOWNLOAD dependencies on HR_ALL_ORGANIZATION_UNITS

Line 19: l_business_group_name hr_all_organization_units.name%TYPE;

15: p_request_id in number,
16: p_start_date in date,
17: p_end_date in date) is
18:
19: l_business_group_name hr_all_organization_units.name%TYPE;
20: l_proc varchar2(72) := g_package || 'record_extract_history' ;
21: begin
22: hr_utility.set_location('Entering:' || l_proc,10);
23: select name

Line 25: from hr_all_organization_units

21: begin
22: hr_utility.set_location('Entering:' || l_proc,10);
23: select name
24: into l_business_group_name
25: from hr_all_organization_units
26: where organization_id = p_bg_id;
27: insert into hr_h2pi_data_feed_hist
28: (start_date,
29: end_date,