518: --
519: begin
520: select null
521: into l_dummy 522: from ame_actions 523: where action_id = p_rec.action_id
524: and p_effective_date between start_date and
525: nvl(end_date - ame_util.oneSecond, p_effective_date)
526: for update of end_date nowait;