159: errorMessage ame_util.longestStringType;
160: begin
161: select name
162: into groupNameOut 163: from ame_approval_groups 164: where approval_group_id = groupIdIn
165: and sysdate between start_date
166: and nvl(end_date - ame_util.oneSecond, sysdate);
167: exception