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;