[Home] [Help]
View: HRI_CL_ORG_HRCY_BX_V
View Text
SELECT OST.ORGANIZATION_STRUCTURE_ID ID
, OST.NAME VALUE
, HR_GENERAL.START_OF_TIME DATE_FROM
, HR_GENERAL.END_OF_TIME DATE_TO
, FND_GLOBAL.RESP_ID RESPONSIBILITY_ID
, OST.PRIMARY_STRUCTURE_FLAG PRIMARY_STRUCTURE_FLAG
, OST.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
FROM PER_ORGANIZATION_STRUCTURES OST
WHERE NVL(OST.BUSINESS_GROUP_ID
, -1) = DECODE(OST.BUSINESS_GROUP_ID
, NULL
, -1
, NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, OST.BUSINESS_GROUP_ID) ) WITH READ ONLY
Columns
Name |
ID |
VALUE |
DATE_FROM |
DATE_TO |
RESPONSIBILITY_ID |
PRIMARY_STRUCTURE_FLAG |
BUSINESS_GROUP_ID |