Product: | PER - Human Resources |
---|---|
Description: | Calendar entries |
Implementation/DBA Data: | APPS.PER_CALENDAR_ENTRIES_V |
SELECT ENT.CALENDAR_ENTRY_ID
, ENT.BUSINESS_GROUP_ID
, ENT.NAME
, ENT.TYPE
, ENT.START_DATE
, ENT.START_HOUR
, ENT.START_MIN
, ENT.END_DATE
, ENT.END_HOUR
, ENT.END_MIN
, ENT.DESCRIPTION
, ENT.HIERARCHY_ID
, PGH.NAME
, ENT.VALUE_SET_ID
, FND.FLEX_VALUE_SET_NAME
, ENT.LAST_UPDATE_DATE
, ENT.LAST_UPDATED_BY
, ENT.LAST_UPDATE_LOGIN
, ENT.CREATED_BY
, ENT.CREATION_DATE
, ENT.OBJECT_VERSION_NUMBER
, ENT.LEGISLATION_CODE
, ENT.IDENTIFIER_KEY
, ENT.ORGANIZATION_STRUCTURE_ID
, OS.NAME
, ENT.ORG_STRUCTURE_VERSION_ID
FROM PER_CALENDAR_ENTRIES ENT
, FND_FLEX_VALUE_SETS FND
, PER_GEN_HIERARCHY PGH
, PER_ORGANIZATION_STRUCTURES OS
WHERE ENT.VALUE_SET_ID = FND.FLEX_VALUE_SET_ID(+)
AND ENT.HIERARCHY_ID = PGH.HIERARCHY_ID(+)
AND ENT.ORGANIZATION_STRUCTURE_ID = OS.ORGANIZATION_STRUCTURE_ID(+)