VIEW: APPS.HRI_CL_ORG_HR_N_V

Source

View Text - Preformatted

SELECT org.organization_id ID , orgtl.name VALUE , org.date_from start_date , nvl(org.date_to,hr_general.end_of_time) end_date , fnd_global.resp_id responsibility_id , org.business_group_id business_group_id , CASE WHEN ( hr_security.view_all = 'Y' OR hr_security.show_record('HR_ALL_ORGANIZATION_UNITS' , org.organization_id) = 'TRUE' ) AND ( hr_general.get_xbg_profile = 'Y' OR hr_bis.get_sec_profile_bg_id = org.business_group_id ) THEN 'Y' ELSE 'N' END hr_security_flag_code , CASE WHEN ( org.business_group_id IS NULL OR org.business_group_id = NVL(hr_bis.get_sec_profile_bg_id, org.business_group_id) ) THEN 'Y' ELSE 'N' END bg_security_flag_code FROM hr_all_organization_units org , hr_all_organization_units_tl orgtl , hr_organization_information inf WHERE org.organization_id = inf.organization_id AND org.organization_id = orgtl.organization_id AND inf.org_information1 = 'HR_ORG' AND orgtl.language = USERENV('LANG') WITH READ ONLY

View Text - HTML Formatted

SELECT ORG.ORGANIZATION_ID ID
, ORGTL.NAME VALUE
, ORG.DATE_FROM START_DATE
, NVL(ORG.DATE_TO
, HR_GENERAL.END_OF_TIME) END_DATE
, FND_GLOBAL.RESP_ID RESPONSIBILITY_ID
, ORG.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, CASE WHEN ( HR_SECURITY.VIEW_ALL = 'Y' OR HR_SECURITY.SHOW_RECORD('HR_ALL_ORGANIZATION_UNITS'
, ORG.ORGANIZATION_ID) = 'TRUE' )
AND ( HR_GENERAL.GET_XBG_PROFILE = 'Y' OR HR_BIS.GET_SEC_PROFILE_BG_ID = ORG.BUSINESS_GROUP_ID ) THEN 'Y' ELSE 'N' END HR_SECURITY_FLAG_CODE
, CASE WHEN ( ORG.BUSINESS_GROUP_ID IS NULL OR ORG.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, ORG.BUSINESS_GROUP_ID) ) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE
FROM HR_ALL_ORGANIZATION_UNITS ORG
, HR_ALL_ORGANIZATION_UNITS_TL ORGTL
, HR_ORGANIZATION_INFORMATION INF
WHERE ORG.ORGANIZATION_ID = INF.ORGANIZATION_ID
AND ORG.ORGANIZATION_ID = ORGTL.ORGANIZATION_ID
AND INF.ORG_INFORMATION1 = 'HR_ORG'
AND ORGTL.LANGUAGE = USERENV('LANG') WITH READ ONLY