492: ) is
493: --
494: cursor c_sel1 is
495: select action_type_id 496: from ame_action_types 497: where action_type_id = p_rec.action_type_id and
498: p_effective_date between
499: start_date and nvl(end_date - ame_util.oneSecond, sysdate)
500: for update nowait;