View: HR_CURRENT_PEOPLE_LOV_V

Product:	PER - Human Resources
Description:	Used to support user interface.
Implementation/DBA Data:	APPS.HR_CURRENT_PEOPLE_LOV_V

View Text

SELECT PPF.FULL_NAME FULL_NAME
, PPF.PERSON_ID PERSON_ID
, PPF.BUSINESS_GROUP_ID
, PPF.PERSON_TYPE_ID
, PPF.EFFECTIVE_START_DATE
, PPF.EFFECTIVE_END_DATE
, HO.NAME ORGANIZATION
, HL.LOCATION_CODE LOCATION
, HPT.NAME POSITION
, PPF.EMPLOYEE_NUMBER EMPLOYEE_NUMBER
, HO2.NAME BUSINESS_GROUP_NAME
, PJT.NAME JOB_TITLE
, PPF.EMAIL_ADDRESS EMAIL_ADDRESS
, PPF.OFFICE_NUMBER OFFICE_NUMBER
, PPF.CURRENT_EMPLOYEE_FLAG
FROM PER_ALL_PEOPLE_F PPF
, HR_LOCATIONS_ALL_TL HL
, HR_ALL_ORGANIZATION_UNITS_TL HO
, PER_ALL_ASSIGNMENTS_F PAF
, HR_ALL_POSITIONS_F_TL HPT
, HR_ALL_POSITIONS_F HP
, HR_ALL_ORGANIZATION_UNITS_TL HO2
, PER_JOBS_TL PJT
, PER_PERIODS_OF_SERVICE PPOS
WHERE PAF.PERSON_ID = PPF.PERSON_ID
AND PAF.ASSIGNMENT_TYPE = 'E'
AND PAF.LOCATION_ID = HL.LOCATION_ID (+)
AND PAF.ORGANIZATION_ID = HO.ORGANIZATION_ID
AND PAF.POSITION_ID = HP.POSITION_ID (+)
AND PAF.PRIMARY_FLAG = 'Y'
AND TRUNC(SYSDATE) BETWEEN PAF.EFFECTIVE_START_DATE
AND PAF.EFFECTIVE_END_DATE
AND TRUNC(SYSDATE) BETWEEN PPF.EFFECTIVE_START_DATE
AND PPF.EFFECTIVE_END_DATE
AND TRUNC(SYSDATE) BETWEEN NVL(HP.EFFECTIVE_START_DATE
, TRUNC(SYSDATE) )
AND NVL(HP.EFFECTIVE_END_DATE
, TRUNC(SYSDATE))
AND HPT.POSITION_ID(+) = HP.POSITION_ID
AND HPT.LANGUAGE(+) = USERENV('LANG')
AND HO.LANGUAGE=USERENV('LANG')
AND NVL(HL.LANGUAGE
, USERENV('LANG'))= USERENV('LANG')
AND PAF.BUSINESS_GROUP_ID = HO2.ORGANIZATION_ID
AND HO2.LANGUAGE = USERENV('LANG')
AND PAF.JOB_ID = PJT.JOB_ID (+)
AND PJT.LANGUAGE(+) = USERENV('LANG')
AND PPF.PERSON_ID = PPOS.PERSON_ID
AND TRUNC(SYSDATE) BETWEEN PPOS.DATE_START
AND NVL(PPOS.ACTUAL_TERMINATION_DATE
, TRUNC(SYSDATE) )

Columns