DBA Data[Home] [Help]

APPS.AME_API2 dependencies on AME_ACTION_TYPE_USAGES

Line 1574: from ame_action_type_usages

1570: and sysdate between apr.start_date
1571: and nvl(apr.end_date - ame_util.oneSecond,sysdate);
1572: cursor getActionTypeCount(actionTypeIdIn in number) is
1573: select distinct count(*) into actionTypeCount
1574: from ame_action_type_usages
1575: where action_type_id = approverIn.action_type_id
1576: and rule_type = ame_util.authorityRuleType
1577: and sysdate between start_date
1578: and nvl(end_date - ame_util.oneSecond,sysdate);