APPS.PER_POSITIONS_PKG dependencies on PER_POS_STRUCTURE_ELEMENTS

Line 18: from per_pos_structure_elements pse

14: select 'Y'
15: into l_exists
16: from sys.dual
17: where exists (select null
18: from per_pos_structure_elements pse
19: where pse.pos_structure_VERSION_id = X_Pos_Structure_Version_Id
20: and ((pse.subordinate_position_id = X_Position_Id
21: or pse.parent_position_id = X_Position_Id)
22: or X_Position_Id is null)

Line 173: from per_pos_structure_elements e

169:
170: begin
171: select e.pos_structure_element_id
172: into l_pos_structure_element_id
173: from per_pos_structure_elements e
174: where e.parent_position_id = p_position_id
175: and not exists (
176: select null
177: from per_pos_structure_elements e2

Line 177: from per_pos_structure_elements e2

173: from per_pos_structure_elements e
174: where e.parent_position_id = p_position_id
175: and not exists (
176: select null
177: from per_pos_structure_elements e2
178: where e2.subordinate_position_id = p_position_id)
179: and 1 = (
180: select count(e3.pos_structure_element_id)
181: from per_pos_structure_elements e3

Line 181: from per_pos_structure_elements e3

177: from per_pos_structure_elements e2
178: where e2.subordinate_position_id = p_position_id)
179: and 1 = (
180: select count(e3.pos_structure_element_id)
181: from per_pos_structure_elements e3
182: where e3.parent_position_id = p_position_id);
183: exception when no_data_found then
184: null;
185: end;

Line 195: FROM PER_POS_STRUCTURE_ELEMENTS PSE

191: select '1'
192: into l_exists
193: from sys.dual
194: where exists(SELECT NULL
195: FROM PER_POS_STRUCTURE_ELEMENTS PSE
196: WHERE PSE.PARENT_POSITION_ID = p_position_id
197: OR PSE.SUBORDINATE_POSITION_ID = p_position_id) ;
198: exception when no_data_found then
199: null;