APPS.AME_ENGINE dependencies on AME_ACTION_TYPE_CONFIG

Line 4783: ame_action_type_config.action_type_id,

4779: end fetchOtherAttributeValues;
4780: procedure fetchConfigVars as
4781: cursor actionTypeConfigCursor is
4782: select
4783: ame_action_type_config.action_type_id,
4784: ame_action_type_config.voting_regime,
4785: ame_action_type_config.order_number,
4786: ame_action_type_config.chain_ordering_mode,
4787: ame_action_types.name,

Line 4784: ame_action_type_config.voting_regime,

4780: procedure fetchConfigVars as
4781: cursor actionTypeConfigCursor is
4782: select
4783: ame_action_type_config.action_type_id,
4784: ame_action_type_config.voting_regime,
4785: ame_action_type_config.order_number,
4786: ame_action_type_config.chain_ordering_mode,
4787: ame_action_types.name,
4788: ame_action_types.procedure_name,

Line 4785: ame_action_type_config.order_number,

4781: cursor actionTypeConfigCursor is
4782: select
4783: ame_action_type_config.action_type_id,
4784: ame_action_type_config.voting_regime,
4785: ame_action_type_config.order_number,
4786: ame_action_type_config.chain_ordering_mode,
4787: ame_action_types.name,
4788: ame_action_types.procedure_name,
4789: ame_action_type_usages.rule_type

Line 4786: ame_action_type_config.chain_ordering_mode,

4782: select
4783: ame_action_type_config.action_type_id,
4784: ame_action_type_config.voting_regime,
4785: ame_action_type_config.order_number,
4786: ame_action_type_config.chain_ordering_mode,
4787: ame_action_types.name,
4788: ame_action_types.procedure_name,
4789: ame_action_type_usages.rule_type
4790: from

Line 4791: ame_action_type_config,

4787: ame_action_types.name,
4788: ame_action_types.procedure_name,
4789: ame_action_type_usages.rule_type
4790: from
4791: ame_action_type_config,
4792: ame_action_types,
4793: ame_action_type_usages
4794: where
4795: ame_action_type_config.application_id = engAmeApplicationId and

Line 4795: ame_action_type_config.application_id = engAmeApplicationId and

4791: ame_action_type_config,
4792: ame_action_types,
4793: ame_action_type_usages
4794: where
4795: ame_action_type_config.application_id = engAmeApplicationId and
4796: ame_action_types.action_type_id = ame_action_type_config.action_type_id and
4797: ame_action_type_usages.action_type_id = ame_action_types.action_type_id and
4798: /*
4799: Only action types for list-creation and exception rules have two action-type usages;

Line 4796: ame_action_types.action_type_id = ame_action_type_config.action_type_id and

4792: ame_action_types,
4793: ame_action_type_usages
4794: where
4795: ame_action_type_config.application_id = engAmeApplicationId and
4796: ame_action_types.action_type_id = ame_action_type_config.action_type_id and
4797: ame_action_type_usages.action_type_id = ame_action_types.action_type_id and
4798: /*
4799: Only action types for list-creation and exception rules have two action-type usages;
4800: all other action types have exactly one (current) action-type usage each.

Line 4804: ame_action_type_config.start_date and

4800: all other action types have exactly one (current) action-type usage each.
4801: */
4802: ame_action_type_usages.rule_type <> ame_util.exceptionRuleType and
4803: engEffectiveRuleDate between
4804: ame_action_type_config.start_date and
4805: nvl(ame_action_type_config.end_date - ame_util.oneSecond, engEffectiveRuleDate) and
4806: engEffectiveRuleDate between
4807: ame_action_types.start_date and
4808: nvl(ame_action_types.end_date - ame_util.oneSecond, engEffectiveRuleDate) and

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

4801: */
4802: ame_action_type_usages.rule_type <> ame_util.exceptionRuleType and
4803: engEffectiveRuleDate between
4804: ame_action_type_config.start_date and
4805: nvl(ame_action_type_config.end_date - ame_util.oneSecond, engEffectiveRuleDate) and
4806: engEffectiveRuleDate between
4807: ame_action_types.start_date and
4808: nvl(ame_action_types.end_date - ame_util.oneSecond, engEffectiveRuleDate) and
4809: engEffectiveRuleDate between