VIEW: APPS.HRI_CL_GEO_LOC_HR_V

Source

View Text - Preformatted

SELECT loc.location_id ID , locT.location_code VALUE , hr_general.start_of_time date_from , NVL(loc.inactive_date, hr_general.end_of_time) date_to , loc.business_group_id business_group_id , CASE WHEN ( NVL(loc.business_group_id, -1) = NVL(NVL(hr_bis.get_sec_profile_bg_id, loc.business_group_id),-1) or loc.business_group_id is null) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE FROM hr_locations_all loc ,hr_locations_all_tl locT WHERE loc.location_id = locT.location_id AND sysdate < nvl(loc.inactive_date, hr_general.end_of_time) AND locT.language = userenv('LANG') UNION ALL SELECT -1 ID , '' VALUE , hr_general.start_of_time date_from , hr_general.end_of_time date_to , -1 business_group_id , 'Y' BG_SECURITY_FLAG_CODE FROM dual WITH READ ONLY

View Text - HTML Formatted

SELECT LOC.LOCATION_ID ID
, LOCT.LOCATION_CODE VALUE
, HR_GENERAL.START_OF_TIME DATE_FROM
, NVL(LOC.INACTIVE_DATE
, HR_GENERAL.END_OF_TIME) DATE_TO
, LOC.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, CASE WHEN ( NVL(LOC.BUSINESS_GROUP_ID
, -1) = NVL(NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, LOC.BUSINESS_GROUP_ID)
, -1) OR LOC.BUSINESS_GROUP_ID IS NULL) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE
FROM HR_LOCATIONS_ALL LOC
, HR_LOCATIONS_ALL_TL LOCT
WHERE LOC.LOCATION_ID = LOCT.LOCATION_ID
AND SYSDATE < NVL(LOC.INACTIVE_DATE
, HR_GENERAL.END_OF_TIME)
AND LOCT.LANGUAGE = USERENV('LANG') UNION ALL SELECT -1 ID
, '' VALUE
, HR_GENERAL.START_OF_TIME DATE_FROM
, HR_GENERAL.END_OF_TIME DATE_TO
, -1 BUSINESS_GROUP_ID
, 'Y' BG_SECURITY_FLAG_CODE
FROM DUAL WITH READ ONLY