1780: p_position_id number) return varchar2 is
1781: --
1782: cursor csr_position is
1783: select name
1784: from hr_positions_x
1785: where position_id = p_position_id;
1786: --
1787: v_position_current_name hr_positions_x.name%TYPE := null;
1788: --
1783: select name
1784: from hr_positions_x
1785: where position_id = p_position_id;
1786: --
1787: v_position_current_name hr_positions_x.name%TYPE := null;
1788: --
1789: begin
1790: --
1791: -- Only open the cursor if the parameter is going to retrieve anything