1246: if p_position_name is not NULL then
1247: --
1248: select po.position_id
1249: into v_position_id
1250: from per_positions po
1251: where upper(po.name) = upper(p_position_name)
1252: and po.business_group_id + 0 = v_business_group_id
1253: and v_effective_start_date between po.date_effective
1254: and nvl(po.date_end,v_end_of_time);