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