DBA Data[Home] [Help]

APPS.AME_API2 dependencies on AME_APPROVER_TYPES

Line 1565: ,ame_approver_types apr

1561: l_error_code number;
1562: cursor getOrigSystem(actionTypeIdIn in number) is
1563: select apr.orig_system
1564: from ame_approver_type_usages apu
1565: ,ame_approver_types apr
1566: where apu.action_type_id=actionTypeIdIn
1567: and apr.approver_type_id = apu.approver_type_id
1568: and sysdate between apu.start_date
1569: and nvl(apu.end_date - ame_util.oneSecond,sysdate)