VIEW: APPS.OKE_EMPLOYEES_V

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')