View: HRI_LOC_LOV_V

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

View Text

SELECT /* $HEADER: HRIVIEW.LDT 115.3 2001/09/18 10:51:35 PKM SHIP $ */ LOC.LOCATION_ID
, LOC.LOCATION_CODE
FROM HR_LOCATIONS_ALL LOC
, HR_LOCATIONS_ALL_TL LOT
WHERE NVL(LOC.INACTIVE_DATE
, TRUNC(SYSDATE)+1) > TRUNC(SYSDATE)
AND LOC.LOCATION_ID = LOT.LOCATION_ID
AND LOT.LANGUAGE = USERENV('LANG')
AND NVL (LOC.BUSINESS_GROUP_ID
, NVL(HR_GENERAL.GET_BUSINESS_GROUP_ID
, -99) ) = NVL (HR_GENERAL.GET_BUSINESS_GROUP_ID
, -99) WITH READ ONLY

Columns