APPS.AME_ENGINE dependencies on AME_ACTION_TYPES

Line 4827: ame_action_types.name,

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
4831: ame_action_type_config,

Line 4828: ame_action_types.procedure_name,

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
4831: ame_action_type_config,
4832: ame_action_types,

Line 4832: ame_action_types,

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
4836: ame_action_types.action_type_id = ame_action_type_config.action_type_id and

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 4837: ame_action_type_usages.action_type_id = ame_action_types.action_type_id and

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.
4841: */

Line 4847: ame_action_types.start_date 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
4850: ame_action_type_usages.start_date and
4851: nvl(ame_action_type_usages.end_date - ame_util.oneSecond, engEffectiveRuleDate)

Line 4848: nvl(ame_action_types.end_date - ame_util.oneSecond, engEffectiveRuleDate) and

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
4850: ame_action_type_usages.start_date and
4851: nvl(ame_action_type_usages.end_date - ame_util.oneSecond, engEffectiveRuleDate)
4852: order by ame_action_types.action_type_id;

Line 4852: order by ame_action_types.action_type_id;

4848: nvl(ame_action_types.end_date - ame_util.oneSecond, engEffectiveRuleDate) and
4849: engEffectiveRuleDate between
4850: ame_action_type_usages.start_date and
4851: nvl(ame_action_type_usages.end_date - ame_util.oneSecond, engEffectiveRuleDate)
4852: order by ame_action_types.action_type_id;
4853: cursor configVarCursor is
4854: select
4855: decode(nvl(application_id,0),0,0,-1) application_id,
4856: /* modified from