View: PER_HIERARCHY_LOV

Product:	PER - Human Resources
Description:	Used to support user interface
Implementation/DBA Data:	APPS.PER_HIERARCHY_LOV

View Text

SELECT VER.ROWID
, VER.VERSION_NUMBER
, VER.ORG_STRUCTURE_VERSION_ID
, PS.ORGANIZATION_STRUCTURE_ID
, PS.NAME
, VER.BUSINESS_GROUP_ID + 0
, FL.MEANING
FROM PER_ORGANIZATION_STRUCTURES PS
, PER_ORG_STRUCTURE_VERSIONS VER
, FND_SESSIONS FND
, FND_LOOKUPS FL
WHERE PS.ORGANIZATION_STRUCTURE_ID = VER.ORGANIZATION_STRUCTURE_ID
AND PS.PRIMARY_STRUCTURE_FLAG = FL.LOOKUP_CODE
AND FL.LOOKUP_TYPE = 'YES_NO'
AND FND.EFFECTIVE_DATE BETWEEN VER.DATE_FROM
AND NVL (VER.DATE_TO
, FND.EFFECTIVE_DATE)
AND FND.SESSION_ID = USERENV('SESSIONID')

Columns