DBA Data[Home] [Help]

APPS.AME_API2 dependencies on AME_APPROVER_TYPES

Line 1521: ,ame_approver_types apr

1517: actionTypeName ame_action_types_tl.user_action_type_name%type;
1518: cursor getOrigSystem(actionTypeIdIn in number) is
1519: select apr.orig_system
1520: from ame_approver_type_usages apu
1521: ,ame_approver_types apr
1522: where apu.action_type_id=actionTypeIdIn
1523: and apr.approver_type_id = apu.approver_type_id
1524: and sysdate between apu.start_date
1525: and nvl(apu.end_date - ame_util.oneSecond,sysdate)