DBA Data[Home] [Help]

APPS.AME_API dependencies on AME_ACTION_TYPE_USAGES

Line 89: ame_action_type_usages axu

85: cursor chkActionTypeNonUniqueOrder(applicationIdIn in number) is
86: select 'Y'
87: from (select distinct (count(order_number) - count(distinct order_number)) uniq
88: from ame_action_type_config acf,
89: ame_action_type_usages axu
90: where acf.application_id = applicationIdIn
91: and acf.action_type_id = axu.action_type_id
92: and sysdate between acf.start_date and
93: nvl(acf.end_Date - ame_util.oneSecond, sysdate)