APPS.AME_APPROVER_TYPE_PKG dependencies on HR_ORGANIZATION_UNITS

Line 2128: hr_organization_units,

2124: getWfRolesName(ame_util.posOrigSystem, per_positions.position_id) approver_name,
2125: getApproverDescription(getWfRolesName(ame_util.posOrigSystem, orig_system_id)) approver_description
2126: from
2127: per_positions,
2128: hr_organization_units,
2129: wf_roles
2130: where
2131: wf_roles.orig_system_id = per_positions.position_id and
2132: wf_roles.orig_system = ame_util.posOrigSystem and

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

2131: wf_roles.orig_system_id = per_positions.position_id and
2132: wf_roles.orig_system = ame_util.posOrigSystem and
2133: wf_roles.status = 'ACTIVE' and
2134: (positionNameIn is null or upper(per_positions.name) like upper(replace(positionNameIn, '''', '''''')) || '%') and
2135: (businessGroupNameIn is null or upper(hr_organization_units.name) like upper(replace(businessGroupNameIn, '''', '''''')) || '%') and
2136: per_positions.business_group_id = hr_organization_units.organization_id and
2137: truncatedSysdateIn between
2138: per_positions.date_effective and
2139: nvl(per_positions.date_end, truncatedSysdateIn) and

Line 2136: per_positions.business_group_id = hr_organization_units.organization_id and

2132: wf_roles.orig_system = ame_util.posOrigSystem and
2133: wf_roles.status = 'ACTIVE' and
2134: (positionNameIn is null or upper(per_positions.name) like upper(replace(positionNameIn, '''', '''''')) || '%') and
2135: (businessGroupNameIn is null or upper(hr_organization_units.name) like upper(replace(businessGroupNameIn, '''', '''''')) || '%') and
2136: per_positions.business_group_id = hr_organization_units.organization_id and
2137: truncatedSysdateIn between
2138: per_positions.date_effective and
2139: nvl(per_positions.date_end, truncatedSysdateIn) and
2140: truncatedSysdateIn between

Line 2141: hr_organization_units.date_from and

2137: truncatedSysdateIn between
2138: per_positions.date_effective and
2139: nvl(per_positions.date_end, truncatedSysdateIn) and
2140: truncatedSysdateIn between
2141: hr_organization_units.date_from and
2142: nvl(hr_organization_units.date_to, truncatedSysdateIn) and
2143: rownum < 52 + rowsToExcludeIn /* This prevents oversized fetches. */
2144: order by per_positions.name;
2145: /* local variables */

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

2138: per_positions.date_effective and
2139: nvl(per_positions.date_end, truncatedSysdateIn) and
2140: truncatedSysdateIn between
2141: hr_organization_units.date_from and
2142: nvl(hr_organization_units.date_to, truncatedSysdateIn) and
2143: rownum < 52 + rowsToExcludeIn /* This prevents oversized fetches. */
2144: order by per_positions.name;
2145: /* local variables */
2146: approverNames ame_util.longStringList;