DBA Data[Home] [Help]

APPS.AME_APPROVER_TYPE_USAGES_API dependencies on AME_APPROVER_TYPES

Line 30: from AME_APPROVER_TYPES

26: (
27: X_ORIG_SYSTEM in VARCHAR2
28: ) is
29: select APPROVER_TYPE_ID
30: from AME_APPROVER_TYPES
31: where ORIG_SYSTEM = X_ORIG_SYSTEM
32: and sysdate between START_DATE
33: and nvl(END_DATE - (1/86400), sysdate);
34: cursor CSR_GET_ACTION_TYPE_ID

Line 289: ame_util.runtimeException('ame_approver_types_usages_api',

285: end if;
286: end;
287: exception
288: when others then
289: ame_util.runtimeException('ame_approver_types_usages_api',
290: 'load_row',
291: sqlcode,
292: sqlerrm);
293: raise;