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_APPROVER_TYPE_PKG dependencies on HR_ORGANIZATION_UNITS

Line 2079: hr_organization_units,

2075: getWfRolesName(ame_util.posOrigSystem, per_positions.position_id) approver_name,
2076: getApproverDescription(getWfRolesName(ame_util.posOrigSystem, orig_system_id)) approver_description
2077: from
2078: per_positions,
2079: hr_organization_units,
2080: wf_roles
2081: where
2082: wf_roles.orig_system_id = per_positions.position_id and
2083: wf_roles.orig_system = ame_util.posOrigSystem and

Line 2086: (businessGroupNameIn is null or upper(hr_organization_units.name) like upper(replace(businessGroupNameIn, '''', '''''')) || '%') and

2082: wf_roles.orig_system_id = per_positions.position_id and
2083: wf_roles.orig_system = ame_util.posOrigSystem and
2084: wf_roles.status = 'ACTIVE' and
2085: (positionNameIn is null or upper(per_positions.name) like upper(replace(positionNameIn, '''', '''''')) || '%') and
2086: (businessGroupNameIn is null or upper(hr_organization_units.name) like upper(replace(businessGroupNameIn, '''', '''''')) || '%') and
2087: per_positions.business_group_id = hr_organization_units.organization_id and
2088: truncatedSysdateIn between
2089: per_positions.date_effective and
2090: nvl(per_positions.date_end, truncatedSysdateIn) and

Line 2087: per_positions.business_group_id = hr_organization_units.organization_id and

2083: wf_roles.orig_system = ame_util.posOrigSystem and
2084: wf_roles.status = 'ACTIVE' and
2085: (positionNameIn is null or upper(per_positions.name) like upper(replace(positionNameIn, '''', '''''')) || '%') and
2086: (businessGroupNameIn is null or upper(hr_organization_units.name) like upper(replace(businessGroupNameIn, '''', '''''')) || '%') and
2087: per_positions.business_group_id = hr_organization_units.organization_id and
2088: truncatedSysdateIn between
2089: per_positions.date_effective and
2090: nvl(per_positions.date_end, truncatedSysdateIn) and
2091: truncatedSysdateIn between

Line 2092: hr_organization_units.date_from and

2088: truncatedSysdateIn between
2089: per_positions.date_effective and
2090: nvl(per_positions.date_end, truncatedSysdateIn) and
2091: truncatedSysdateIn between
2092: hr_organization_units.date_from and
2093: nvl(hr_organization_units.date_to, truncatedSysdateIn) and
2094: rownum < 52 + rowsToExcludeIn /* This prevents oversized fetches. */
2095: order by per_positions.name;
2096: /* local variables */

Line 2093: nvl(hr_organization_units.date_to, truncatedSysdateIn) and

2089: per_positions.date_effective and
2090: nvl(per_positions.date_end, truncatedSysdateIn) and
2091: truncatedSysdateIn between
2092: hr_organization_units.date_from and
2093: nvl(hr_organization_units.date_to, truncatedSysdateIn) and
2094: rownum < 52 + rowsToExcludeIn /* This prevents oversized fetches. */
2095: order by per_positions.name;
2096: /* local variables */
2097: approverNames ame_util.longStringList;