3899: l_ovn number;
3900: begin
3901: select per.object_version_number
3902: into l_ovn 3903: from per_people_f per, 3904: hr_pump_batch_line_user_keys key
3905: where key.user_key_value = p_person_user_key
3906: and per.person_id = key.unique_key_id
3907: and p_effective_date between