APPS.HR_POS_HIERARCHY_ELE_API dependencies on PER_POS_STRUCTURE_ELEMENTS

Line 27: per_pos_structure_elements.pos_structure_element_id%TYPE;

23: --
24: -- Declare cursors and local variables
25: --
26: l_pos_structure_element_id
27: per_pos_structure_elements.pos_structure_element_id%TYPE;
28: l_object_version_number
29: per_pos_structure_elements.object_version_number%TYPE;
30: l_proc varchar2(72) := g_package||'create_pos_hierarchy_ele';
31: l_effective_date date;

Line 29: per_pos_structure_elements.object_version_number%TYPE;

25: --
26: l_pos_structure_element_id
27: per_pos_structure_elements.pos_structure_element_id%TYPE;
28: l_object_version_number
29: per_pos_structure_elements.object_version_number%TYPE;
30: l_proc varchar2(72) := g_package||'create_pos_hierarchy_ele';
31: l_effective_date date;
32: --
33: cursor get_old_element is select pos_structure_element_id,

Line 35: from per_pos_structure_elements

31: l_effective_date date;
32: --
33: cursor get_old_element is select pos_structure_element_id,
34: object_version_number
35: from per_pos_structure_elements
36: where subordinate_position_id = p_subordinate_position_id
37: and pos_structure_version_id = p_pos_structure_version_id;
38: --
39:

Line 44: FROM per_pos_structure_elements a

40: --start changes for bug 6139893
41: --cursor returns values when the passing 'Parent' is already present as a 'Child' in the below hierarchy
42: cursor chk_child_sub_node is
43: SELECT distinct '1'
44: FROM per_pos_structure_elements a
45: WHERE a.business_group_id = p_business_group_id
46: AND a.POS_structure_version_id = p_pos_structure_version_id
47: AND a.parent_position_id = p_subordinate_position_id
48: AND p_parent_position_id IN

Line 51: FROM per_pos_structure_elements b

47: AND a.parent_position_id = p_subordinate_position_id
48: AND p_parent_position_id IN
49: (SELECT subordinate_position_id
50: FROM ( SELECT * /*Added this subquery for bug#14158576*/
51: FROM per_pos_structure_elements b
52: WHERE b.business_group_id = p_business_group_id
53: AND b.pos_structure_version_id = p_pos_structure_version_id)
54: CONNECT BY parent_position_id = prior subordinate_position_id
55: START WITH parent_position_id = a.parent_position_id

Line 219: l_object_version_number per_pos_structure_elements

215: -- Declare cursors and local variables
216: --
217: l_effective_date date;
218: l_proc varchar2(72) := g_package||'update_pos_hierarchy_ele';
219: l_object_version_number per_pos_structure_elements
220: .object_version_number%TYPE;
221: l_temp_ovn number := p_object_version_number;
222: begin
223: hr_utility.set_location('Entering:'|| l_proc, 10);