DBA Data[Home] [Help]

APPS.AME_API2 dependencies on AME_ACTION_TYPE_USAGES

Line 1530: from ame_action_type_usages

1526: and sysdate between apr.start_date
1527: and nvl(apr.end_date - ame_util.oneSecond,sysdate);
1528: cursor getActionTypeCount(actionTypeIdIn in number) is
1529: select distinct count(*) into actionTypeCount
1530: from ame_action_type_usages
1531: where action_type_id = approverIn.action_type_id
1532: and rule_type = ame_util.authorityRuleType
1533: and sysdate between start_date
1534: and nvl(end_date - ame_util.oneSecond,sysdate);