eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AME_ACTION_PKG dependencies on AME_APPROVER_TYPES

Line 2748: from ame_approver_types,

2744: cursor getApproverTypesCursor(actionTypeIdIn in integer) is
2745: select
2746: ame_approver_type_usages.approver_type_id,
2747: ame_approver_type_pkg.getOrigSystemDisplayName(orig_system) approver_name
2748: from ame_approver_types,
2749: ame_approver_type_usages
2750: where
2751: ame_approver_types.approver_type_id = ame_approver_type_usages.approver_type_id and
2752: ame_approver_type_usages.action_type_id = actionTypeIdIn and

Line 2751: ame_approver_types.approver_type_id = ame_approver_type_usages.approver_type_id and

2747: ame_approver_type_pkg.getOrigSystemDisplayName(orig_system) approver_name
2748: from ame_approver_types,
2749: ame_approver_type_usages
2750: where
2751: ame_approver_types.approver_type_id = ame_approver_type_usages.approver_type_id and
2752: ame_approver_type_usages.action_type_id = actionTypeIdIn and
2753: sysdate between
2754: ame_approver_types.start_date and
2755: nvl(ame_approver_types.end_date - ame_util.oneSecond, sysdate) and

Line 2754: ame_approver_types.start_date and

2750: where
2751: ame_approver_types.approver_type_id = ame_approver_type_usages.approver_type_id and
2752: ame_approver_type_usages.action_type_id = actionTypeIdIn and
2753: sysdate between
2754: ame_approver_types.start_date and
2755: nvl(ame_approver_types.end_date - ame_util.oneSecond, sysdate) and
2756: sysdate between
2757: ame_approver_type_usages.start_date and
2758: nvl(ame_approver_type_usages.end_date - ame_util.oneSecond, sysdate)

Line 2755: nvl(ame_approver_types.end_date - ame_util.oneSecond, sysdate) and

2751: ame_approver_types.approver_type_id = ame_approver_type_usages.approver_type_id and
2752: ame_approver_type_usages.action_type_id = actionTypeIdIn and
2753: sysdate between
2754: ame_approver_types.start_date and
2755: nvl(ame_approver_types.end_date - ame_util.oneSecond, sysdate) and
2756: sysdate between
2757: ame_approver_type_usages.start_date and
2758: nvl(ame_approver_type_usages.end_date - ame_util.oneSecond, sysdate)
2759: order by approver_name;

Line 2831: from ame_approver_types

2827: where
2828: (approver_type_id = ame_util.anyApproverType or
2829: approver_type_id in
2830: (select approver_type_id
2831: from ame_approver_types
2832: where
2833: orig_system in (ame_util.perOrigSystem, ame_util.fndUserOrigSystem) and
2834: sysdate between start_date and nvl(end_date - ame_util.oneSecond, sysdate))) and
2835: sysdate between start_date and nvl(end_date - ame_util.oneSecond, sysdate))) and

Line 2959: from ame_approver_types

2955: where
2956: (approver_type_id = ame_util.anyApproverType or
2957: approver_type_id in
2958: (select approver_type_id
2959: from ame_approver_types
2960: where
2961: orig_system in (ame_util.perOrigSystem, ame_util.fndUserOrigSystem) and
2962: sysdate between start_date and nvl(end_date - ame_util.oneSecond, sysdate))) and
2963: sysdate between start_date and nvl(end_date - ame_util.oneSecond, sysdate))) and