DBA Data[Home] [Help]

APPS.AME_RULE_PKG dependencies on AME_MANDATORY_ATTRIBUTES

Line 4146: select ame_mandatory_attributes.attribute_id attribute_id

4142: (sysdate < ame_condition_usages.start_date and
4143: ame_condition_usages.start_date < nvl(ame_condition_usages.end_date,
4144: ame_condition_usages.start_date + ame_util.oneSecond)))
4145: union
4146: select ame_mandatory_attributes.attribute_id attribute_id
4147: from
4148: ame_mandatory_attributes,
4149: ame_action_usages,
4150: ame_actions

Line 4148: ame_mandatory_attributes,

4144: ame_condition_usages.start_date + ame_util.oneSecond)))
4145: union
4146: select ame_mandatory_attributes.attribute_id attribute_id
4147: from
4148: ame_mandatory_attributes,
4149: ame_action_usages,
4150: ame_actions
4151: where
4152: ame_mandatory_attributes.action_type_id = ame_actions.action_type_id and

Line 4152: ame_mandatory_attributes.action_type_id = ame_actions.action_type_id and

4148: ame_mandatory_attributes,
4149: ame_action_usages,
4150: ame_actions
4151: where
4152: ame_mandatory_attributes.action_type_id = ame_actions.action_type_id and
4153: ame_actions.action_id = ame_action_usages.action_id and
4154: ame_action_usages.rule_id = ruleIdIn and
4155: (ame_mandatory_attributes.start_date <= sysdate and
4156: (ame_mandatory_attributes.end_date is null or sysdate < ame_mandatory_attributes.end_date)) and

Line 4155: (ame_mandatory_attributes.start_date <= sysdate and

4151: where
4152: ame_mandatory_attributes.action_type_id = ame_actions.action_type_id and
4153: ame_actions.action_id = ame_action_usages.action_id and
4154: ame_action_usages.rule_id = ruleIdIn and
4155: (ame_mandatory_attributes.start_date <= sysdate and
4156: (ame_mandatory_attributes.end_date is null or sysdate < ame_mandatory_attributes.end_date)) and
4157: ((sysdate between ame_action_usages.start_date and
4158: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate)) or
4159: (sysdate < ame_action_usages.start_date and

Line 4156: (ame_mandatory_attributes.end_date is null or sysdate < ame_mandatory_attributes.end_date)) and

4152: ame_mandatory_attributes.action_type_id = ame_actions.action_type_id and
4153: ame_actions.action_id = ame_action_usages.action_id and
4154: ame_action_usages.rule_id = ruleIdIn and
4155: (ame_mandatory_attributes.start_date <= sysdate and
4156: (ame_mandatory_attributes.end_date is null or sysdate < ame_mandatory_attributes.end_date)) and
4157: ((sysdate between ame_action_usages.start_date and
4158: nvl(ame_action_usages.end_date - ame_util.oneSecond, sysdate)) or
4159: (sysdate < ame_action_usages.start_date and
4160: ame_action_usages.start_date < nvl(ame_action_usages.end_date,