VIEW: APPS.PER_EMPLOYEES_X

Source

View Text - Preformatted

SELECT P.BUSINESS_GROUP_ID , A.ORGANIZATION_ID , P.PERSON_ID , A.ASSIGNMENT_ID , P.LAST_UPDATE_DATE , P.LAST_UPDATED_BY , P.LAST_UPDATE_LOGIN , P.CREATION_DATE , P.CREATED_BY , P.EMPLOYEE_NUMBER , P.FULL_NAME , P.FIRST_NAME , P.MIDDLE_NAMES , P.LAST_NAME , P.TITLE , A.LOCATION_ID , A.SUPERVISOR_ID , A.SET_OF_BOOKS_ID , A.DEFAULT_CODE_COMB_ID , P.EXPENSE_CHECK_SEND_TO_ADDRESS , B.ACTUAL_TERMINATION_DATE , P.EMAIL_ADDRESS , P.ATTRIBUTE1 , P.ATTRIBUTE2 , P.ATTRIBUTE3 , P.ATTRIBUTE4 , P.ATTRIBUTE5 , P.ATTRIBUTE6 , P.ATTRIBUTE7 , P.ATTRIBUTE8 , P.ATTRIBUTE9 , P.ATTRIBUTE10 , P.ATTRIBUTE11 , P.ATTRIBUTE12 , P.ATTRIBUTE13 , P.ATTRIBUTE14 , P.ATTRIBUTE15 , P.ATTRIBUTE16 , P.ATTRIBUTE17 , P.ATTRIBUTE18 , P.ATTRIBUTE19 , P.ATTRIBUTE20 , P.ATTRIBUTE21 , P.ATTRIBUTE22 , P.ATTRIBUTE23 , P.ATTRIBUTE24 , P.ATTRIBUTE25 , P.ATTRIBUTE26 , P.ATTRIBUTE27 , P.ATTRIBUTE28 , P.ATTRIBUTE29 , P.ATTRIBUTE30 , P.ATTRIBUTE_CATEGORY , P.PARTY_ID ,P.GLOBAL_NAME ,P.LOCAL_NAME ,P.LIST_NAME FROM PER_PEOPLE_F P, PER_ALL_ASSIGNMENTS_F A, PER_PERIODS_OF_SERVICE B WHERE A.PERSON_ID = P.PERSON_ID AND A.PRIMARY_FLAG = 'Y' AND A.ASSIGNMENT_TYPE = 'E' AND A.PERIOD_OF_SERVICE_ID = B.PERIOD_OF_SERVICE_ID AND TRUNC(SYSDATE) BETWEEN P.EFFECTIVE_START_DATE AND P.EFFECTIVE_END_DATE AND (SELECT MAX(NVL(B2.ACTUAL_TERMINATION_DATE,TRUNC(SYSDATE))) FROM PER_PERIODS_OF_SERVICE B2 WHERE B2.PERSON_ID = A.PERSON_ID AND B2.DATE_START <= TRUNC(SYSDATE)) BETWEEN A.EFFECTIVE_START_DATE AND A.EFFECTIVE_END_DATE /* AND A.EFFECTIVE_START_DATE <= (SELECT MAX(NVL(B2.ACTUAL_TERMINATION_DATE,TRUNC(SYSDATE))) FROM PER_PERIODS_OF_SERVICE B2 WHERE B2.PERSON_ID = A.PERSON_ID AND B2.DATE_START <= TRUNC(SYSDATE)) AND A.EFFECTIVE_END_DATE >= (SELECT MAX(NVL(B2.ACTUAL_TERMINATION_DATE,TRUNC(SYSDATE))) FROM PER_PERIODS_OF_SERVICE B2 WHERE B2.PERSON_ID = A.PERSON_ID AND B2.DATE_START <= TRUNC(SYSDATE)) */ AND P.EMPLOYEE_NUMBER IS NOT NULL

View Text - HTML Formatted

SELECT P.BUSINESS_GROUP_ID
, A.ORGANIZATION_ID
, P.PERSON_ID
, A.ASSIGNMENT_ID
, P.LAST_UPDATE_DATE
, P.LAST_UPDATED_BY
, P.LAST_UPDATE_LOGIN
, P.CREATION_DATE
, P.CREATED_BY
, P.EMPLOYEE_NUMBER
, P.FULL_NAME
, P.FIRST_NAME
, P.MIDDLE_NAMES
, P.LAST_NAME
, P.TITLE
, A.LOCATION_ID
, A.SUPERVISOR_ID
, A.SET_OF_BOOKS_ID
, A.DEFAULT_CODE_COMB_ID
, P.EXPENSE_CHECK_SEND_TO_ADDRESS
, B.ACTUAL_TERMINATION_DATE
, P.EMAIL_ADDRESS
, P.ATTRIBUTE1
, P.ATTRIBUTE2
, P.ATTRIBUTE3
, P.ATTRIBUTE4
, P.ATTRIBUTE5
, P.ATTRIBUTE6
, P.ATTRIBUTE7
, P.ATTRIBUTE8
, P.ATTRIBUTE9
, P.ATTRIBUTE10
, P.ATTRIBUTE11
, P.ATTRIBUTE12
, P.ATTRIBUTE13
, P.ATTRIBUTE14
, P.ATTRIBUTE15
, P.ATTRIBUTE16
, P.ATTRIBUTE17
, P.ATTRIBUTE18
, P.ATTRIBUTE19
, P.ATTRIBUTE20
, P.ATTRIBUTE21
, P.ATTRIBUTE22
, P.ATTRIBUTE23
, P.ATTRIBUTE24
, P.ATTRIBUTE25
, P.ATTRIBUTE26
, P.ATTRIBUTE27
, P.ATTRIBUTE28
, P.ATTRIBUTE29
, P.ATTRIBUTE30
, P.ATTRIBUTE_CATEGORY
, P.PARTY_ID
, P.GLOBAL_NAME
, P.LOCAL_NAME
, P.LIST_NAME
FROM PER_PEOPLE_F P
, PER_ALL_ASSIGNMENTS_F A
, PER_PERIODS_OF_SERVICE B
WHERE A.PERSON_ID = P.PERSON_ID
AND A.PRIMARY_FLAG = 'Y'
AND A.ASSIGNMENT_TYPE = 'E'
AND A.PERIOD_OF_SERVICE_ID = B.PERIOD_OF_SERVICE_ID
AND TRUNC(SYSDATE) BETWEEN P.EFFECTIVE_START_DATE
AND P.EFFECTIVE_END_DATE
AND (SELECT MAX(NVL(B2.ACTUAL_TERMINATION_DATE
, TRUNC(SYSDATE)))
FROM PER_PERIODS_OF_SERVICE B2
WHERE B2.PERSON_ID = A.PERSON_ID
AND B2.DATE_START <= TRUNC(SYSDATE)) BETWEEN A.EFFECTIVE_START_DATE
AND A.EFFECTIVE_END_DATE /*
AND A.EFFECTIVE_START_DATE <= (SELECT MAX(NVL(B2.ACTUAL_TERMINATION_DATE
, TRUNC(SYSDATE)))
FROM PER_PERIODS_OF_SERVICE B2
WHERE B2.PERSON_ID = A.PERSON_ID
AND B2.DATE_START <= TRUNC(SYSDATE))
AND A.EFFECTIVE_END_DATE >= (SELECT MAX(NVL(B2.ACTUAL_TERMINATION_DATE
, TRUNC(SYSDATE)))
FROM PER_PERIODS_OF_SERVICE B2
WHERE B2.PERSON_ID = A.PERSON_ID
AND B2.DATE_START <= TRUNC(SYSDATE)) */
AND P.EMPLOYEE_NUMBER IS NOT NULL