VIEW: APPS.HR_HIER_SUPER_PEOPLE_V

Source

View Text - Preformatted

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'))

View Text - HTML Formatted

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'))