VIEW: APPS.HR_EMPLOYEES

Source

View Text - Preformatted

SELECT p.person_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, p.expense_check_send_to_address, p.email_address, p.attribute1, p.attribute2, p.attribute3, p.attribute4, p.attribute5, p.attribute_category, pbg.name FROM PER_PEOPLE_F P, PER_BUSINESS_GROUPS_PERF PBG WHERE ( P.EMPLOYEE_NUMBER IS NOT NULL OR P.NPW_NUMBER IS NOT NULL ) AND TRUNC(SYSDATE) BETWEEN P.EFFECTIVE_START_DATE AND P.EFFECTIVE_END_DATE AND P.BUSINESS_GROUP_ID = PBG.BUSINESS_GROUP_ID AND exists ( Select 'Asssinment Exisits' From PER_ASSIGNMENTS_F A, PER_ASSIGNMENT_STATUS_TYPES PAST WHERE A.PERSON_ID = P.PERSON_ID AND A.PRIMARY_FLAG = 'Y' AND A.ASSIGNMENT_STATUS_TYPE_ID = PAST.ASSIGNMENT_STATUS_TYPE_ID AND PAST.PER_SYSTEM_STATUS IN ('ACTIVE_ASSIGN','ACTIVE_CWK', 'SUSP_ASSIGN','SUSP_CWK_ASG') 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.PERSON_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
, P.EXPENSE_CHECK_SEND_TO_ADDRESS
, P.EMAIL_ADDRESS
, P.ATTRIBUTE1
, P.ATTRIBUTE2
, P.ATTRIBUTE3
, P.ATTRIBUTE4
, P.ATTRIBUTE5
, P.ATTRIBUTE_CATEGORY
, PBG.NAME
FROM PER_PEOPLE_F P
, PER_BUSINESS_GROUPS_PERF PBG
WHERE ( P.EMPLOYEE_NUMBER IS NOT NULL OR P.NPW_NUMBER IS NOT NULL )
AND TRUNC(SYSDATE) BETWEEN P.EFFECTIVE_START_DATE
AND P.EFFECTIVE_END_DATE
AND P.BUSINESS_GROUP_ID = PBG.BUSINESS_GROUP_ID
AND EXISTS ( SELECT 'ASSSINMENT EXISITS'
FROM PER_ASSIGNMENTS_F A
, PER_ASSIGNMENT_STATUS_TYPES PAST
WHERE A.PERSON_ID = P.PERSON_ID
AND A.PRIMARY_FLAG = 'Y'
AND A.ASSIGNMENT_STATUS_TYPE_ID = PAST.ASSIGNMENT_STATUS_TYPE_ID
AND PAST.PER_SYSTEM_STATUS IN ('ACTIVE_ASSIGN'
, 'ACTIVE_CWK'
, 'SUSP_ASSIGN'
, 'SUSP_CWK_ASG')
AND A.ASSIGNMENT_TYPE IN ('E'
, DECODE( NVL(FND_PROFILE.VALUE('HR_TREAT_CWK_AS_EMP')
, 'N')
, 'Y'
, 'C'
, 'E')) )