APPS.HR_PSF_DEL dependencies on PER_POS_STRUCTURE_ELEMENTS

Line 271: from per_pos_structure_elements e

267: /****** Commented for bug 9146790 ********
268: begin
269: select e.pos_structure_element_id
270: into l_pos_structure_element_id
271: from per_pos_structure_elements e
272: where e.parent_position_id = p_position_id
273: and not exists (
274: select null
275: from per_pos_structure_elements e2

Line 275: from per_pos_structure_elements e2

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

Line 279: from per_pos_structure_elements e3

275: from per_pos_structure_elements e2
276: where e2.subordinate_position_id = p_position_id)
277: and 1 = (
278: select count(e3.pos_structure_element_id)
279: from per_pos_structure_elements e3
280: where e3.parent_position_id = p_position_id);
281: exception when no_data_found then
282: null;
283: 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;