[Home] [Help]
View: HRILV_ORGHR_HRS_X
Product: | HRI - Human Resources Intelligence |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT /* $HEADER: HRIVIEW.LDT 115.3 2001/09/18 10:51:35 PKM SHIP $ */ ORG.ORGANIZATION_ID ID
, ORG.NAME VALUE
, ORG.DATE_FROM DATE_FROM
, NVL(ORG.DATE_TO
, HR_GENERAL.END_OF_TIME) DATE_TO /*PARENT IDS*/
, ORG.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
FROM HR_ORGANIZATION_UNITS ORG
, HR_ORGANIZATION_INFORMATION INF
WHERE ORG.ORGANIZATION_ID = INF.ORGANIZATION_ID /*RESTRICTIONS*/
AND INF.ORG_INFORMATION1 = 'HR_ORG'
AND TRUNC(SYSDATE) BETWEEN ORG.DATE_FROM
AND NVL(ORG.DATE_TO
, HR_GENERAL.END_OF_TIME) /*SECURITY*/
AND ORG.BUSINESS_GROUP_ID = NVL(HR_GENERAL.GET_BUSINESS_GROUP_ID
, ORG.BUSINESS_GROUP_ID) WITH READ ONLY
Columns
Name |
ID |
VALUE |
DATE_FROM |
DATE_TO |
BUSINESS_GROUP_ID |