VIEW: APPS.HRI_CL_LOC_HR_B_V

Source

View Text - Preformatted

SELECT loc.location_id ID , locT.location_code VALUE , hr_general.start_of_time start_date , NVL(loc.inactive_date, hr_general.end_of_time) end_date , loc.business_group_id business_group_id , DECODE(loc.business_group_id ,NULL,'Y' ,'N') global_flag FROM hr_locations_all loc , hr_locations_all_tl locT WHERE loc.location_id = locT.location_id AND locT.language = userenv('LANG') AND (loc.business_group_id IS NULL OR loc.business_group_id = NVL(hr_bis.get_sec_profile_bg_id,loc.business_group_id)) UNION ALL SELECT -1 ID , '' VALUE , hr_general.start_of_time start_date , hr_general.end_of_time end_date , -1 business_group_id , 'NA_EDW' global_flag FROM dual WITH READ ONLY

View Text - HTML Formatted

SELECT LOC.LOCATION_ID ID
, LOCT.LOCATION_CODE VALUE
, HR_GENERAL.START_OF_TIME START_DATE
, NVL(LOC.INACTIVE_DATE
, HR_GENERAL.END_OF_TIME) END_DATE
, LOC.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, DECODE(LOC.BUSINESS_GROUP_ID
, NULL
, 'Y'
, 'N') GLOBAL_FLAG
FROM HR_LOCATIONS_ALL LOC
, HR_LOCATIONS_ALL_TL LOCT
WHERE LOC.LOCATION_ID = LOCT.LOCATION_ID
AND LOCT.LANGUAGE = USERENV('LANG')
AND (LOC.BUSINESS_GROUP_ID IS NULL OR LOC.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, LOC.BUSINESS_GROUP_ID)) UNION ALL SELECT -1 ID
, '' VALUE
, HR_GENERAL.START_OF_TIME START_DATE
, HR_GENERAL.END_OF_TIME END_DATE
, -1 BUSINESS_GROUP_ID
, 'NA_EDW' GLOBAL_FLAG
FROM DUAL WITH READ ONLY