APPS.HR_PSF_DEL dependencies on PER_POS_STRUCTURE_ELEMENTS

Line 270: from per_pos_structure_elements e

266: end if;
267: begin
268: select e.pos_structure_element_id
269: into l_pos_structure_element_id
270: from per_pos_structure_elements e
271: where e.parent_position_id = p_position_id
272: and not exists (
273: select null
274: from per_pos_structure_elements e2

Line 274: from per_pos_structure_elements e2

270: from per_pos_structure_elements e
271: where e.parent_position_id = p_position_id
272: and not exists (
273: select null
274: from per_pos_structure_elements e2
275: where e2.subordinate_position_id = p_position_id)
276: and 1 = (
277: select count(e3.pos_structure_element_id)
278: from per_pos_structure_elements e3

Line 278: from per_pos_structure_elements e3

274: from per_pos_structure_elements e2
275: where e2.subordinate_position_id = p_position_id)
276: and 1 = (
277: select count(e3.pos_structure_element_id)
278: from per_pos_structure_elements e3
279: where e3.parent_position_id = p_position_id);
280: exception when no_data_found then
281: null;
282: end;

Line 296: FROM PER_POS_STRUCTURE_ELEMENTS PSE

292: select '1'
293: into l_exists
294: from sys.dual
295: where exists(SELECT NULL
296: FROM PER_POS_STRUCTURE_ELEMENTS PSE
297: WHERE PSE.PARENT_POSITION_ID = p_position_id
298: OR PSE.SUBORDINATE_POSITION_ID = p_position_id) ;
299: exception when no_data_found then
300: null;