VIEW: APPS.HRI_CL_ORG_BGR_BX_V

Source

View Text - Preformatted

SELECT orgT.organization_id id , orgT.name value , org.date_from date_from , NVL(org.date_to, hr_general.end_of_time) date_to , fnd_global.resp_id responsibility_id FROM hr_all_organization_units org , hr_all_organization_units_tl orgT , hr_organization_information oinf WHERE TRUNC(SYSDATE) BETWEEN org.date_from AND NVL(org.date_to, hr_general.end_of_time) AND 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' AND org.organization_id = NVL(hr_bis.get_sec_profile_bg_id,org.organization_id) UNION ALL SELECT -1 id , '' value , hr_general.start_of_time date_from , hr_general.end_of_time date_to , -1 responsibility_id FROM dual WITH READ ONLY

View Text - HTML Formatted

SELECT ORGT.ORGANIZATION_ID ID
, ORGT.NAME VALUE
, ORG.DATE_FROM DATE_FROM
, NVL(ORG.DATE_TO
, HR_GENERAL.END_OF_TIME) DATE_TO
, FND_GLOBAL.RESP_ID RESPONSIBILITY_ID
FROM HR_ALL_ORGANIZATION_UNITS ORG
, HR_ALL_ORGANIZATION_UNITS_TL ORGT
, HR_ORGANIZATION_INFORMATION OINF
WHERE TRUNC(SYSDATE) BETWEEN ORG.DATE_FROM
AND NVL(ORG.DATE_TO
, HR_GENERAL.END_OF_TIME)
AND 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'
AND ORG.ORGANIZATION_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, ORG.ORGANIZATION_ID) UNION ALL SELECT -1 ID
, '' VALUE
, HR_GENERAL.START_OF_TIME DATE_FROM
, HR_GENERAL.END_OF_TIME DATE_TO
, -1 RESPONSIBILITY_ID
FROM DUAL WITH READ ONLY