View: HR_CAL_PEOPLE_KEYS_V

Product:	PER - Human Resources
Description:	Used to support user interface
Implementation/DBA Data:	APPS.HR_CAL_PEOPLE_KEYS_V

View Text

SELECT DISTINCT ENTITY.PERSON_ID
, ENTITY.FULL_NAME
, ENTITY.EMPLOYEE_NUMBER
, ENTITY.BUSINESS_GROUP_ID
, 'PERSON'
FROM PER_ALL_PEOPLE_F ENTITY
, FND_SESSIONS
WHERE FND_SESSIONS.SESSION_ID = USERENV('SESSIONID')
AND FND_SESSIONS.EFFECTIVE_DATE BETWEEN ENTITY.EFFECTIVE_START_DATE
AND ENTITY.EFFECTIVE_END_DATE UNION ALL SELECT ENTITY.BUSINESS_GROUP_ID
, ENTITY.NAME
, TO_CHAR(NULL)
, ENTITY.BUSINESS_GROUP_ID
, 'ORGANIZATION'
FROM PER_BUSINESS_GROUPS_PERF ENTITY
WHERE ENTITY.ENABLED_FLAG = 'Y'

Columns