APPS.HR_GL_COST_CENTERS dependencies on PER_BUSINESS_GROUPS

Line 249: l_bg_name per_business_groups.name%type := null;

245:
246: Procedure writeHeaderFileHeader(p_file in utl_file.file_type
247: ,p_bgid in NUMBER
248: ,p_datfile in VARCHAR2) IS
249: l_bg_name per_business_groups.name%type := null;
250: l_proc varchar2(50) := g_package||'.writeHeaderFileHeader';
251: l_tab varchar2(5) := fnd_global.tab;
252: BEGIN
253: hr_utility.set_location('Entering : '||l_proc,10);

Line 256: from PER_BUSINESS_GROUPS

252: BEGIN
253: hr_utility.set_location('Entering : '||l_proc,10);
254: BEGIN
255: SELECT name INTO l_bg_name
256: from PER_BUSINESS_GROUPS
257: WHERE business_group_id = p_bgid;
258:
259: utl_file.put_line(P_FILE, 'Header'||l_tab||'Start');
260: utl_file.put_line(P_FILE, 'Batch Name'||l_tab||

Line 348: per_business_groups per

344:
345: open c_bg_list for 'select distinct rep.business_group_id,
346: per.name
347: from '||p_hr_cc_reporting_temp ||' rep,
348: per_business_groups per
349: where rep.business_group_id=per.business_group_id';
350: loop
351: hr_utility.set_location(l_proc,30);
352: fetch c_bg_list into l_bg_id, l_bg_name;