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)