View: HR_HIER_ASG_PEOPLE_V

Product:	PER - Human Resources
Description:
Implementation/DBA Data:	APPS.HR_HIER_ASG_PEOPLE_V

View Text

SELECT PP.FULL_NAME
, PP.EMPLOYEE_NUMBER
, PP.SEX
, PP.DATE_OF_BIRTH
, PP.KNOWN_AS
, PP.NATIONAL_IDENTIFIER
, PP.TITLE
, ASG.ASSIGNMENT_NUMBER
, ASG.PRIMARY_FLAG
, PP.EMAIL_ADDRESS
, PP.MAILSTOP
, PPH.PHONE_NUMBER
, PP.DATE_EMPLOYEE_DATA_VERIFIED
, ASG.TIME_NORMAL_START
, ASG.TIME_NORMAL_FINISH
, LOC.LOCATION_CODE
, ASG.MANAGER_FLAG
, ASG.PEOPLE_GROUP_ID
, ASG.PAYROLL_ID
, ASG.PERSON_ID
, ASG.SUPERVISOR_ID
, ASG.ASSIGNMENT_ID
, ASG.ORGANIZATION_ID
, ASG.POSITION_ID
, ASG.JOB_ID
, ASG.LOCATION_ID
, ASG.GRADE_ID
, ORG.NAME
, ASG.BUSINESS_GROUP_ID
, HR_THIRD_PARTY_INTERFACE_PKG.GET_EXTRACT_DATE
FROM PER_PHONES PPH
, HR_LOCATIONS_ALL LOC
, HR_ALL_ORGANIZATION_UNITS ORG
, PER_ALL_PEOPLE_F PP
, PER_ALL_ASSIGNMENTS_F ASG
WHERE PP.PERSON_ID = ASG.PERSON_ID
AND ASG.PRIMARY_FLAG = 'Y'
AND ORG.ORGANIZATION_ID = ASG.BUSINESS_GROUP_ID
AND PP.PERSON_ID = PPH.PARENT_ID(+)
AND PPH.PARENT_TABLE(+) = 'PER_ALL_PEOPLE_F'
AND PPH.PHONE_TYPE(+) = 'W1'
AND ASG.LOCATION_ID = LOC.LOCATION_ID(+)
AND HR_THIRD_PARTY_INTERFACE_PKG.GET_EXTRACT_DATE BETWEEN PPH.DATE_FROM(+)
AND NVL(PPH.DATE_TO(+)
, TO_DATE('30-12-4712'
, 'DD-MM-YYYY'))
AND HR_THIRD_PARTY_INTERFACE_PKG.GET_EXTRACT_DATE BETWEEN PP.EFFECTIVE_START_DATE
AND PP.EFFECTIVE_END_DATE
AND HR_THIRD_PARTY_INTERFACE_PKG.GET_EXTRACT_DATE BETWEEN ASG.EFFECTIVE_START_DATE
AND ASG.EFFECTIVE_END_DATE

Columns