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