APPS.AME_RUL_BUS dependencies on AME_CONDITION_USAGES

Line 436: from ame_condition_usages

432: p_effective_date between start_date and
433: nvl(end_date - ame_util.oneSecond, p_effective_date) ;
434: cursor c_sel2 is
435: select null
436: from ame_condition_usages
437: where
438: rule_id = p_rule_id and
439: p_effective_date between start_date and
440: nvl(end_date - ame_util.oneSecond, p_effective_date) ;

Line 459: -- ame_condition_usages

455: fnd_message.set_name('PER','AME_400216_RUL_IN_USE');
456: fnd_message.raise_error;
457: end if;
458: close c_sel1;
459: -- ame_condition_usages
460: open c_sel2;
461: fetch c_sel2 into l_exists;
462: if c_sel2%found then
463: close c_sel2;