APPS.AME_RUL_BUS dependencies on AME_RULE_USAGES

Line 429: from ame_rule_usages

425: l_proc varchar2(72) := g_package||'chk_delete';
426: tempCount integer;
427: cursor c_sel1 is
428: select null
429: from ame_rule_usages
430: where
431: rule_id = p_rule_id and
432: p_effective_date between start_date and
433: nvl(end_date - ame_util.oneSecond, p_effective_date) ;

Line 450: -- ame_rule_usages

446: p_effective_date between start_date and
447: nvl(end_date - ame_util.oneSecond, p_effective_date) ;
448: l_exists varchar2(1);
449: begin
450: -- ame_rule_usages
451: open c_sel1;
452: fetch c_sel1 into l_exists;
453: if c_sel1%found then
454: close c_sel1;