APPS.AME_ACTION_USAGES_API dependencies on AME_APPROVAL_GROUPS
Line 75: from AME_APPROVAL_GROUPS
71: (
72: X_APPROVAL_GROUP_NAME in VARCHAR2
73: ) is
74: select APPROVAL_GROUP_ID 75: from AME_APPROVAL_GROUPS 76: where NAME = X_APPROVAL_GROUP_NAME
77: and sysdate between START_DATE
78: and nvl(end_date - (1/86400), sysdate);
79: cursor CSR_GET_CURRENT_ACTION_USAGE2