DBA Data[Home] [Help]

APPS.AME_RUL_BUS dependencies on AME_ACTION_USAGES

Line 443: from ame_action_usages

439: p_effective_date between start_date and
440: nvl(end_date - ame_util.oneSecond, p_effective_date) ;
441: cursor c_sel3 is
442: select null
443: from ame_action_usages
444: where
445: rule_id = p_rule_id and
446: p_effective_date between start_date and
447: nvl(end_date - ame_util.oneSecond, p_effective_date) ;

Line 468: -- ame_action_usages

464: fnd_message.set_name('PER','AME_400216_RUL_IN_USE');
465: fnd_message.raise_error;
466: end if;
467: close c_sel2;
468: -- ame_action_usages
469: open c_sel3;
470: fetch c_sel3 into l_exists;
471: if c_sel3%found then
472: close c_sel3;