APPS.HR_PSF_BUS dependencies on PER_POS_STRUCTURE_ELEMENTS

Line 7389: from per_pos_structure_elements e

7385: /**** Commented for Bug 9146790 **********
7386: begin
7387: select e.pos_structure_element_id
7388: into l_pos_structure_element_id
7389: from per_pos_structure_elements e
7390: where e.parent_position_id = p_position_id
7391: and not exists (
7392: select null
7393: from per_pos_structure_elements e2

Line 7393: from per_pos_structure_elements e2

7389: from per_pos_structure_elements e
7390: where e.parent_position_id = p_position_id
7391: and not exists (
7392: select null
7393: from per_pos_structure_elements e2
7394: where e2.subordinate_position_id = p_position_id)
7395: and 1 = (
7396: select count(e3.pos_structure_element_id)
7397: from per_pos_structure_elements e3

Line 7397: from per_pos_structure_elements e3

7393: from per_pos_structure_elements e2
7394: where e2.subordinate_position_id = p_position_id)
7395: and 1 = (
7396: select count(e3.pos_structure_element_id)
7397: from per_pos_structure_elements e3
7398: where e3.parent_position_id = p_position_id);
7399: exception when no_data_found then
7400: null;
7401: end;

Line 7413: FROM PER_POS_STRUCTURE_ELEMENTS PSE

7409: select '1'
7410: into l_exists
7411: from sys.dual
7412: where exists(SELECT NULL
7413: FROM PER_POS_STRUCTURE_ELEMENTS PSE
7414: WHERE PSE.PARENT_POSITION_ID = p_position_id
7415: OR PSE.SUBORDINATE_POSITION_ID = p_position_id) ;
7416: exception when no_data_found then
7417: null;