VIEW: APPS.HR_CURRENT_EMP

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 ,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 WHERE A.PERSON_ID = P.PERSON_ID AND A.PRIMARY_FLAG = 'Y' AND TRUNC (SYSDATE) BETWEEN P.EFFECTIVE_START_DATE AND P.EFFECTIVE_END_DATE AND TRUNC (SYSDATE) BETWEEN A.EFFECTIVE_START_DATE AND A.EFFECTIVE_END_DATE AND A.ASSIGNMENT_TYPE IN('E',DECODE(NVL(FND_PROFILE.VALUE('HR_TREAT_CWK_AS_EMP'),'N'),'Y','C','E'))

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
, 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
WHERE A.PERSON_ID = P.PERSON_ID
AND A.PRIMARY_FLAG = 'Y'
AND TRUNC (SYSDATE) BETWEEN P.EFFECTIVE_START_DATE
AND P.EFFECTIVE_END_DATE
AND TRUNC (SYSDATE) BETWEEN A.EFFECTIVE_START_DATE
AND A.EFFECTIVE_END_DATE
AND A.ASSIGNMENT_TYPE IN('E'
, DECODE(NVL(FND_PROFILE.VALUE('HR_TREAT_CWK_AS_EMP')
, 'N')
, 'Y'
, 'C'
, 'E'))