508: ) is
509: --
510: cursor c_sel1 is
511: select action_type_id 512: from ame_action_types 513: where action_type_id = p_rec.action_type_id and
514: p_effective_date between
515: start_date and nvl(end_date - ame_util.oneSecond, sysdate)
516: for update nowait;