DBA Data[Home] [Help]

APPS.AME_API2 dependencies on AME_APPROVER_TYPE_USAGES

Line 1564: from ame_approver_type_usages apu

1560: actionTypeName ame_action_types_tl.user_action_type_name%type;
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