View: HRI_CL_ORG_HRCYVRSN_BX_V

Product:	HRI - Human Resources Intelligence
Description:
Implementation/DBA Data:	APPS.HRI_CL_ORG_HRCYVRSN_BX_V

View Text

SELECT OSV.ORG_STRUCTURE_VERSION_ID ID
, OST.NAME||' : '||TO_CHAR(OSV.VERSION_NUMBER) VALUE
, OSV.DATE_FROM START_DATE
, NVL(OSV.DATE_TO
, HR_GENERAL.END_OF_TIME) END_DATE
, FND_GLOBAL.RESP_ID RESPONSIBILITY_ID
, OSV.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, OST.PRIMARY_STRUCTURE_FLAG PRIMARY_STRUCTURE_FLAG
FROM PER_ORG_STRUCTURE_VERSIONS OSV
, PER_ORGANIZATION_STRUCTURES OST
WHERE OSV.ORGANIZATION_STRUCTURE_ID = OST.ORGANIZATION_STRUCTURE_ID
AND OSV.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, OSV.BUSINESS_GROUP_ID) WITH READ ONLY

Columns