200: for update nowait;
201: --
202: cursor csr_lck is
203: select null 204: from AME_CONDITIONS 205: where condition_id = p_condition_id
206: and p_effective_date between start_date
207: and nvl(end_date - ame_util.oneSecond, p_effective_date)
208: for update of object_version_number nowait;