DBA Data[Home] [Help]

APPS.AME_APPROVER_TYPE_USAGES_API dependencies on AME_ACTION_TYPES

Line 39: from AME_ACTION_TYPES

35: (
36: X_ACTION_TYPE_NAME in VARCHAR2
37: ) is
38: select ACTION_TYPE_ID
39: from AME_ACTION_TYPES
40: where NAME = X_ACTION_TYPE_NAME
41: and sysdate between START_DATE
42: and nvl(END_DATE - (1/86400), sysdate);
43: cursor CSR_GET_CURR_APPR_TYPE_USAGE