DBA Data[Home] [Help]

APPS.AME_ENGINE dependencies on AME_STRING_VALUES

Line 3481: from ame_string_values

3477: cursor activeCondStringValueCursor is
3478: select
3479: condition_id,
3480: string_value
3481: from ame_string_values
3482: where
3483: condition_id in
3484: (select ame_condition_usages.condition_id
3485: from

Line 3509: ame_string_values.start_date and

3505: engEffectiveRuleDate between
3506: ame_rule_usages.start_date and
3507: nvl(ame_rule_usages.end_date - ame_util.oneSecond, engEffectiveRuleDate)) and
3508: engEffectiveRuleDate between
3509: ame_string_values.start_date and
3510: nvl(ame_string_values.end_date - ame_util.oneSecond, engEffectiveRuleDate)
3511: order by condition_id;
3512: cursor activeCondUsageCursor(processPrioritiesIn in varchar2,
3513: processProductionRulesIn in varchar2,

Line 3510: nvl(ame_string_values.end_date - ame_util.oneSecond, engEffectiveRuleDate)

3506: ame_rule_usages.start_date and
3507: nvl(ame_rule_usages.end_date - ame_util.oneSecond, engEffectiveRuleDate)) and
3508: engEffectiveRuleDate between
3509: ame_string_values.start_date and
3510: nvl(ame_string_values.end_date - ame_util.oneSecond, engEffectiveRuleDate)
3511: order by condition_id;
3512: cursor activeCondUsageCursor(processPrioritiesIn in varchar2,
3513: processProductionRulesIn in varchar2,
3514: combinationRulePriorityModeIn in varchar2,