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 50: FROM per_pos_structure_elements b

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
49: (SELECT subordinate_position_id
50: FROM per_pos_structure_elements b
51: WHERE a.business_group_id = b.business_group_id
52: AND a.POS_structure_version_id = b.pos_structure_version_id
53: CONNECT BY parent_position_id = prior subordinate_position_id
54: START WITH parent_position_id = a.parent_position_id

Line 218: l_object_version_number per_pos_structure_elements

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