APPS.AME_ENGINE dependencies on AME_ACTION_TYPE_CONFIG

Line 4823: ame_action_type_config.action_type_id,

4819: end fetchOtherAttributeValues;
4820: procedure fetchConfigVars as
4821: cursor actionTypeConfigCursor is
4822: select
4823: ame_action_type_config.action_type_id,
4824: ame_action_type_config.voting_regime,
4825: ame_action_type_config.order_number,
4826: ame_action_type_config.chain_ordering_mode,
4827: ame_action_types.name,

Line 4824: ame_action_type_config.voting_regime,

4820: procedure fetchConfigVars as
4821: cursor actionTypeConfigCursor is
4822: select
4823: ame_action_type_config.action_type_id,
4824: ame_action_type_config.voting_regime,
4825: ame_action_type_config.order_number,
4826: ame_action_type_config.chain_ordering_mode,
4827: ame_action_types.name,
4828: ame_action_types.procedure_name,

Line 4825: ame_action_type_config.order_number,

4821: cursor actionTypeConfigCursor is
4822: select
4823: ame_action_type_config.action_type_id,
4824: ame_action_type_config.voting_regime,
4825: ame_action_type_config.order_number,
4826: ame_action_type_config.chain_ordering_mode,
4827: ame_action_types.name,
4828: ame_action_types.procedure_name,
4829: ame_action_type_usages.rule_type

Line 4826: ame_action_type_config.chain_ordering_mode,

4822: select
4823: ame_action_type_config.action_type_id,
4824: ame_action_type_config.voting_regime,
4825: ame_action_type_config.order_number,
4826: ame_action_type_config.chain_ordering_mode,
4827: ame_action_types.name,
4828: ame_action_types.procedure_name,
4829: ame_action_type_usages.rule_type
4830: from

Line 4831: ame_action_type_config,

4827: ame_action_types.name,
4828: ame_action_types.procedure_name,
4829: ame_action_type_usages.rule_type
4830: from
4831: ame_action_type_config,
4832: ame_action_types,
4833: ame_action_type_usages
4834: where
4835: ame_action_type_config.application_id = engAmeApplicationId and

Line 4835: ame_action_type_config.application_id = engAmeApplicationId and

4831: ame_action_type_config,
4832: ame_action_types,
4833: ame_action_type_usages
4834: where
4835: ame_action_type_config.application_id = engAmeApplicationId and
4836: ame_action_types.action_type_id = ame_action_type_config.action_type_id and
4837: ame_action_type_usages.action_type_id = ame_action_types.action_type_id and
4838: /*
4839: Only action types for list-creation and exception rules have two action-type usages;

Line 4836: ame_action_types.action_type_id = ame_action_type_config.action_type_id and

4832: ame_action_types,
4833: ame_action_type_usages
4834: where
4835: ame_action_type_config.application_id = engAmeApplicationId and
4836: ame_action_types.action_type_id = ame_action_type_config.action_type_id and
4837: ame_action_type_usages.action_type_id = ame_action_types.action_type_id and
4838: /*
4839: Only action types for list-creation and exception rules have two action-type usages;
4840: all other action types have exactly one (current) action-type usage each.

Line 4844: ame_action_type_config.start_date and

4840: all other action types have exactly one (current) action-type usage each.
4841: */
4842: ame_action_type_usages.rule_type <> ame_util.exceptionRuleType and
4843: engEffectiveRuleDate between
4844: ame_action_type_config.start_date and
4845: nvl(ame_action_type_config.end_date - ame_util.oneSecond, engEffectiveRuleDate) and
4846: engEffectiveRuleDate between
4847: ame_action_types.start_date and
4848: nvl(ame_action_types.end_date - ame_util.oneSecond, engEffectiveRuleDate) and

Line 4845: nvl(ame_action_type_config.end_date - ame_util.oneSecond, engEffectiveRuleDate) and

4841: */
4842: ame_action_type_usages.rule_type <> ame_util.exceptionRuleType and
4843: engEffectiveRuleDate between
4844: ame_action_type_config.start_date and
4845: nvl(ame_action_type_config.end_date - ame_util.oneSecond, engEffectiveRuleDate) and
4846: engEffectiveRuleDate between
4847: ame_action_types.start_date and
4848: nvl(ame_action_types.end_date - ame_util.oneSecond, engEffectiveRuleDate) and
4849: engEffectiveRuleDate between