HRMS - Position Hierarchy Setup List: Position Hierarchy - Historic

Description
Categories: Discoverer
Columns: Business Group Name, Child Position Name, Hierarchy Version End Date, Hierarchy Version Start Date, Parent Position Name, Position Hierarchy Level, Position Hierarchy Name, Position Hierarchy Version ...
List position hierarchies for verifying setup.
Owner: SYSADMIN (System Administrator)
Identifier: HRI_PER_IDS_POSHRCHY
SELECT HRFG_POSITION_HIERARCHIES.BUSINESS_GROUP_NAME, HRFG_POSITION_HIERARCHIES.CHILD_POSITION_NAME, HRFG_POSITION_HIERARCHIES.HIERARCHY_VERSION_END_DATE, HRFG_POSITION_HIERARCHIES.HIERARCHY_VERSION_START_DATE, HRFG_POSITION_HIERARCHIES.PARENT_POSITION_NAME, HRFG_POSITION_HIERARCHIES.POSITION_HIERARCHY_LEVEL, HRFG_POSITION_HIERARCHIES.POSITION_HIERARCHY_NAME, HRFG_POSITION_HIERARCHIES.POSITION_HIERARCHY_VERSION
FROM HRFG_POSITION_HIERARCHIES HRFG_POSITION_HIERARCHIES WHERE 1=1 AND  ((((HRFG_POSITION_HIERARCHIES.HIERARCHY_VERSION_START_DATE <= :effective_date OR HRFG_POSITION_HIERARCHIES.HIERARCHY_VERSION_START_DATE IS NULL  )  ) ) AND (((HRFG_POSITION_HIERARCHIES.HIERARCHY_VERSION_END_DATE >= :effective_date OR HRFG_POSITION_HIERARCHIES.HIERARCHY_VERSION_END_DATE IS NULL  )  ) ) ) 
ORDER BY HRFG_POSITION_HIERARCHIES.POSITION_HIERARCHY_NAME ASC, HRFG_POSITION_HIERARCHIES.POSITION_HIERARCHY_VERSION ASC, HRFG_POSITION_HIERARCHIES.HIERARCHY_VERSION_START_DATE ASC, HRFG_POSITION_HIERARCHIES.HIERARCHY_VERSION_END_DATE ASC, HRFG_POSITION_HIERARCHIES.POSITION_HIERARCHY_LEVEL ASC, HRFG_POSITION_HIERARCHIES.PARENT_POSITION_NAME ASC
Parameter Name SQL text Validation
Business Group
 HRFG_POSITION_HIERARCHIES.BUSINESS_GROUP_NAME = :business_group
LOV
Position Hierarchy
 HRFG_POSITION_HIERARCHIES.POSITION_HIERARCHY_NAME = :position_hierarchy
Effective Date
 
Date