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 343: from hr_all_organization_units

339: and org_information_context='DEFAULT_GRE_INFO';
340: --
341: cursor get_loc is
342: select location_id
343: from hr_all_organization_units
344: where organization_id=p_business_group_id;
345: --
346: begin
347: hr_utility.set_location('Entering: '||l_proc,10);

Line 699: from hr_all_organization_units

695: and org_information_context='DEFAULT_HR_INFO';
696: --
697: cursor get_loc is
698: select location_id
699: from hr_all_organization_units
700: where organization_id=p_organization_id;
701: --
702: --
703: cursor get_vac is