View: OKE_EMPLOYEES_V

Product:	OKE - Project Contracts
Description:	Employee View
Implementation/DBA Data:	APPS.OKE_EMPLOYEES_V

View Text

SELECT P.PERSON_ID
, P.FULL_NAME
, P.EMPLOYEE_NUMBER
, P.LAST_NAME
, P.FIRST_NAME
, P.MIDDLE_NAMES
, P.EFFECTIVE_START_DATE
, P.EFFECTIVE_END_DATE
, P.EXPENSE_CHECK_SEND_TO_ADDRESS
, P.BUSINESS_GROUP_ID
, H.NAME
, P.VENDOR_ID
, P.CURRENT_EMPLOYEE_FLAG
FROM PER_PEOPLE_F P
, HR_ALL_ORGANIZATION_UNITS_TL H
WHERE TRUNC( SYSDATE ) BETWEEN TRUNC( P.EFFECTIVE_START_DATE )
AND TRUNC( P.EFFECTIVE_END_DATE )
AND P.EMPLOYEE_NUMBER IS NOT NULL
AND H.ORGANIZATION_ID = P.BUSINESS_GROUP_ID
AND H.LANGUAGE = USERENV('LANG')

Columns