1533: and sysdate between start_date
1534: and nvl(end_date - ame_util.oneSecond,sysdate);
1535: cursor getActionTypeName(actionTypeIdIn in number) is
1536: select user_action_type_name 1537: from ame_action_types_vl 1538: where action_type_id = actionTypeIdIn
1539: and sysdate between start_date
1540: and nvl(end_date - ame_util.oneSecond,sysdate);
1541: --+