View: HR_HIER_SUPER_PEOPLE_V

Product:	PER - Human Resources
Description:	View of people and assignments
Implementation/DBA Data:	APPS.HR_HIER_SUPER_PEOPLE_V

View Text

SELECT PASG.FULL_NAME
, PASG.EMPLOYEE_NUMBER
, PASG.KNOWN_AS
, PASG.EMAIL_ADDRESS
, PASG.MAILSTOP
, PASG.WORK_PHONE_NUMBER
, JBT.NAME
, GRT.NAME
, HL.LOCATION_CODE
, ORG.NAME
, PASG.BUSINESS_GROUP_NAME
, PASG.PERSON_ID
, PP2.PERSON_ID
, PASG.EXTRACT_DATE
FROM PAY_PEOPLE_GROUPS PPG
, PER_ALL_PEOPLE_F PP2
, HR_ALL_ORGANIZATION_UNITS ORG
, HR_HIER_ASG_PEOPLE_V PASG
, HR_LOCATIONS HL
, PER_JOBS_TL JBT
, PER_GRADES_TL GRT
WHERE PASG.PEOPLE_GROUP_ID = PPG.PEOPLE_GROUP_ID (+)
AND PASG.JOB_ID = JBT.JOB_ID
AND JBT.LANGUAGE = USERENV('LANG')
AND PASG.LOCATION_ID = HL.LOCATION_ID (+)
AND PASG.GRADE_ID = GRT.GRADE_ID (+)
AND GRT.LANGUAGE (+) = USERENV('LANG')
AND PASG.ORGANIZATION_ID = ORG.ORGANIZATION_ID
AND HR_THIRD_PARTY_INTERFACE_PKG.GET_EXTRACT_DATE BETWEEN NVL(PPG.START_DATE_ACTIVE(+)
, TO_DATE('01-01-0001'
, 'DD-MM-YYYY'))
AND NVL(PPG.END_DATE_ACTIVE(+)
, TO_DATE('31-12-4712'
, 'DD-MM-YYYY'))
AND PASG.SUPERVISOR_ID = PP2.PERSON_ID (+)
AND HR_THIRD_PARTY_INTERFACE_PKG.GET_EXTRACT_DATE BETWEEN NVL(PP2.EFFECTIVE_START_DATE(+)
, TO_DATE('01-01-0001'
, 'DD-MM-YYYY'))
AND NVL(PP2.EFFECTIVE_END_DATE(+)
, TO_DATE('31-12-4712'
, 'DD-MM-YYYY'))

Columns