VIEW: APPS.HRI_CL_ORG_BGR_N_V

Source

View Text - Preformatted

SELECT orgT.organization_id id , orgT.name value , org.date_from start_date , NVL(org.date_to, hr_general.end_of_time) end_date , orgT.name order_by , fnd_global.resp_id responsibility_id , CASE WHEN org.organization_id = NVL(hr_bis.get_sec_profile_bg_id,org.organization_id) THEN 'Y' ELSE 'N' END bg_security_flag_code FROM hr_all_organization_units org , hr_all_organization_units_tl orgT , hr_organization_information oinf WHERE 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' WITH READ ONLY

View Text - HTML Formatted

SELECT ORGT.ORGANIZATION_ID ID
, ORGT.NAME VALUE
, ORG.DATE_FROM START_DATE
, NVL(ORG.DATE_TO
, HR_GENERAL.END_OF_TIME) END_DATE
, ORGT.NAME ORDER_BY
, FND_GLOBAL.RESP_ID RESPONSIBILITY_ID
, CASE WHEN ORG.ORGANIZATION_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, ORG.ORGANIZATION_ID) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE
FROM HR_ALL_ORGANIZATION_UNITS ORG
, HR_ALL_ORGANIZATION_UNITS_TL ORGT
, HR_ORGANIZATION_INFORMATION OINF
WHERE 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' WITH READ ONLY