VIEW: APPS.HRI_CL_ORG_HR_HX_V

Source

View Text - Preformatted

SELECT org.organization_id ID , org.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 FROM hr_organization_units org , hr_organization_information inf WHERE org.organization_id = inf.organization_id AND inf.org_information1 = 'HR_ORG' AND trunc(sysdate) BETWEEN org.date_from AND nvl(org.date_to,hr_general.end_of_time) AND (org.business_group_id IS NULL OR org.business_group_id = NVL(hr_bis.get_sec_profile_bg_id, org.business_group_id)) UNION ALL SELECT -1 ID , '' VALUE , hr_general.start_of_time start_date , hr_general.end_of_time end_date , fnd_global.resp_id responsibility_id , -1 business_group_id FROM dual WITH READ ONLY

View Text - HTML Formatted

SELECT ORG.ORGANIZATION_ID ID
, ORG.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
FROM HR_ORGANIZATION_UNITS ORG
, HR_ORGANIZATION_INFORMATION INF
WHERE ORG.ORGANIZATION_ID = INF.ORGANIZATION_ID
AND INF.ORG_INFORMATION1 = 'HR_ORG'
AND TRUNC(SYSDATE) BETWEEN ORG.DATE_FROM
AND NVL(ORG.DATE_TO
, HR_GENERAL.END_OF_TIME)
AND (ORG.BUSINESS_GROUP_ID IS NULL OR ORG.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, ORG.BUSINESS_GROUP_ID)) UNION ALL SELECT -1 ID
, '' VALUE
, HR_GENERAL.START_OF_TIME START_DATE
, HR_GENERAL.END_OF_TIME END_DATE
, FND_GLOBAL.RESP_ID RESPONSIBILITY_ID
, -1 BUSINESS_GROUP_ID
FROM DUAL WITH READ ONLY