411: -- Check for a valid position id
412: -- Changed 12-Oct-99 SCNair (per_positions to hr_positions) dt track position req.
413: --
414: select 1 415: from hr_positions_f 416: where position_id = p_primary_key_value
417: and p_start_date between date_effective
418: and nvl (hr_general.get_position_date_end(position_id), hr_general.end_of_time);
419: --