408: nvl(end_date - ame_util.oneSecond, sysdate);
409: cursor getConfigVarsCur is
410: select variable_name,
411: object_version_number
412: from ame_config_vars
413: where application_id = p_application_id
414: and sysdate between start_date and
415: nvl(end_date - ame_util.oneSecond, sysdate);
416: type varsList is table of ame_config_vars.variable_name%type
412: from ame_config_vars
413: where application_id = p_application_id
414: and sysdate between start_date and
415: nvl(end_date - ame_util.oneSecond, sysdate);
416: type varsList is table of ame_config_vars.variable_name%type
417: index by binary_integer;
418: l_proc varchar2(72) := g_package||'delete_ame_transaction_type';
419: l_object_version_number number;
420: l_start_date date;