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
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,
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,