VIEW: APPS.PO_EMPLOYEES_CURRENT_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 , NVL(P.EMPLOYEE_NUMBER,P.NPW_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.WORK_TELEPHONE , NULL , P.ATTRIBUTE1 , P.ATTRIBUTE2 , P.ATTRIBUTE3 , P.ATTRIBUTE4 , P.ATTRIBUTE5 , P.ATTRIBUTE_CATEGORY , PBG.NAME FROM PER_ALL_PEOPLE_F P, PER_ALL_ASSIGNMENTS_F A , PER_BUSINESS_GROUPS_PERF PBG WHERE P.BUSINESS_GROUP_ID IN (SELECT FSP.BUSINESS_GROUP_ID FROM FINANCIALS_SYSTEM_PARAMETERS FSP) AND P.BUSINESS_GROUP_ID = PBG.BUSINESS_GROUP_ID AND 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 (NVL(CURRENT_EMPLOYEE_FLAG,'N') = 'Y' OR NVL(CURRENT_NPW_FLAG,'N') = 'Y') 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
, NVL(P.EMPLOYEE_NUMBER
, P.NPW_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.WORK_TELEPHONE
, NULL
, P.ATTRIBUTE1
, P.ATTRIBUTE2
, P.ATTRIBUTE3
, P.ATTRIBUTE4
, P.ATTRIBUTE5
, P.ATTRIBUTE_CATEGORY
, PBG.NAME
FROM PER_ALL_PEOPLE_F P
, PER_ALL_ASSIGNMENTS_F A
, PER_BUSINESS_GROUPS_PERF PBG
WHERE P.BUSINESS_GROUP_ID IN (SELECT FSP.BUSINESS_GROUP_ID
FROM FINANCIALS_SYSTEM_PARAMETERS FSP)
AND P.BUSINESS_GROUP_ID = PBG.BUSINESS_GROUP_ID
AND 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 (NVL(CURRENT_EMPLOYEE_FLAG
, 'N') = 'Y' OR NVL(CURRENT_NPW_FLAG
, 'N') = 'Y')
AND A.ASSIGNMENT_TYPE IN ('E'
, DECODE( NVL(FND_PROFILE.VALUE('HR_TREAT_CWK_AS_EMP')
, 'N')
, 'Y'
, 'C'
, 'E'))