APPS.HR_PSF_BUS dependencies on PER_POS_STRUCTURE_ELEMENTS

Line 7271: from per_pos_structure_elements e

7267: end if;
7268: begin
7269: select e.pos_structure_element_id
7270: into l_pos_structure_element_id
7271: from per_pos_structure_elements e
7272: where e.parent_position_id = p_position_id
7273: and not exists (
7274: select null
7275: from per_pos_structure_elements e2

Line 7275: from per_pos_structure_elements e2

7271: from per_pos_structure_elements e
7272: where e.parent_position_id = p_position_id
7273: and not exists (
7274: select null
7275: from per_pos_structure_elements e2
7276: where e2.subordinate_position_id = p_position_id)
7277: and 1 = (
7278: select count(e3.pos_structure_element_id)
7279: from per_pos_structure_elements e3

Line 7279: from per_pos_structure_elements e3

7275: from per_pos_structure_elements e2
7276: where e2.subordinate_position_id = p_position_id)
7277: and 1 = (
7278: select count(e3.pos_structure_element_id)
7279: from per_pos_structure_elements e3
7280: where e3.parent_position_id = p_position_id);
7281: exception when no_data_found then
7282: null;
7283: end;

Line 7294: FROM PER_POS_STRUCTURE_ELEMENTS PSE

7290: select '1'
7291: into l_exists
7292: from sys.dual
7293: where exists(SELECT NULL
7294: FROM PER_POS_STRUCTURE_ELEMENTS PSE
7295: WHERE PSE.PARENT_POSITION_ID = p_position_id
7296: OR PSE.SUBORDINATE_POSITION_ID = p_position_id) ;
7297: exception when no_data_found then
7298: null;