497: ) is
498: --
499: cursor csr_lck is
500: select null 501: from AME_CONDITIONS 502: where condition_id = p_rec.condition_id
503: and p_effective_date between start_date
504: and nvl(end_date - ame_util.oneSecond, p_effective_date)
505: for update nowait;