APPS.PER_QH_POPULATE dependencies on HR_ALL_ORGANIZATION_UNITS

Line 49: l_organization_name hr_all_organization_units.name%type;

45: function get_organization
46: (p_organization_id number) return varchar2 is
47: --
48: l_proc varchar2(72) :=g_package||'get_organization';
49: l_organization_name hr_all_organization_units.name%type;
50: --
51: cursor csr_organization is
52: select hotl.name
53: from hr_all_organization_units ho

Line 53: from hr_all_organization_units ho

49: l_organization_name hr_all_organization_units.name%type;
50: --
51: cursor csr_organization is
52: select hotl.name
53: from hr_all_organization_units ho
54: , hr_all_organization_units_tl hotl
55: where ho.organization_id=p_organization_id
56: and hotl.organization_id=ho.organization_id
57: and hotl.language=userenv('LANG');

Line 54: , hr_all_organization_units_tl hotl

50: --
51: cursor csr_organization is
52: select hotl.name
53: from hr_all_organization_units ho
54: , hr_all_organization_units_tl hotl
55: where ho.organization_id=p_organization_id
56: and hotl.organization_id=ho.organization_id
57: and hotl.language=userenv('LANG');
58: begin

Line 336: from hr_all_organization_units

332: and org_information_context='DEFAULT_GRE_INFO';
333: --
334: cursor get_loc is
335: select location_id
336: from hr_all_organization_units
337: where organization_id=p_business_group_id;
338: --
339: begin
340: hr_utility.set_location('Entering: '||l_proc,10);

Line 692: from hr_all_organization_units

688: and org_information_context='DEFAULT_HR_INFO';
689: --
690: cursor get_loc is
691: select location_id
692: from hr_all_organization_units
693: where organization_id=p_organization_id;
694: --
695: --
696: cursor get_vac is