View: HRI_CL_ORG_BGR_BX_V

Product:	HRI - Human Resources Intelligence (Obsolete)
Description:
Implementation/DBA Data:	APPS.HRI_CL_ORG_BGR_BX_V

View Text

SELECT ORGT.ORGANIZATION_ID ID
, ORGT.NAME VALUE
, ORG.DATE_FROM DATE_FROM
, NVL(ORG.DATE_TO
, HR_GENERAL.END_OF_TIME) DATE_TO
, FND_GLOBAL.RESP_ID RESPONSIBILITY_ID
FROM HR_ALL_ORGANIZATION_UNITS ORG
, HR_ALL_ORGANIZATION_UNITS_TL ORGT
, HR_ORGANIZATION_INFORMATION OINF
WHERE TRUNC(SYSDATE) BETWEEN ORG.DATE_FROM
AND NVL(ORG.DATE_TO
, HR_GENERAL.END_OF_TIME)
AND ORG.ORGANIZATION_ID = ORGT.ORGANIZATION_ID
AND ORGT.LANGUAGE = USERENV('LANG')
AND ORG.ORGANIZATION_ID = OINF.ORGANIZATION_ID
AND OINF.ORG_INFORMATION_CONTEXT = 'CLASS'
AND OINF.ORG_INFORMATION1 = 'HR_BG'
AND ORG.ORGANIZATION_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, ORG.ORGANIZATION_ID) WITH READ ONLY

Columns