View: HR_ASSIGN_LOV_V

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

View Text

SELECT DISTINCT PEO.FULL_NAME FULL_NAME
, PEO.PERSON_ID PERSON_ID
, PEO.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, PEO.EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, PEO.EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, PEO.EMPLOYEE_NUMBER EMPLOYEE_NUMBER
, JBT.NAME JOB_NAME
, ORG.NAME ORGANIZATION
, PEO.EMAIL_ADDRESS EMAIL_ADDRESS
, BUS.NAME BUSINESS_GROUP
, PAF.EFFECTIVE_START_DATE ASN_EFFECTIVE_START_DATE
, PAF.EFFECTIVE_END_DATE ASN_EFFECTIVE_END_DATE
FROM PER_ALL_PEOPLE_F PEO
, PER_ALL_ASSIGNMENTS_F PAF
, PER_JOBS_TL JBT
, HR_ALL_ORGANIZATION_UNITS_TL ORG
, HR_ALL_ORGANIZATION_UNITS_TL BUS
WHERE PEO.PERSON_ID IN ( SELECT PERSON_ID
FROM PER_ALL_ASSIGNMENTS_F
WHERE ASSIGNMENT_TYPE ='E'
AND PRIMARY_FLAG = 'Y')
AND PEO.PERSON_TYPE_ID IN ( SELECT PERSON_TYPE_ID
FROM PER_PERSON_TYPES
WHERE SYSTEM_PERSON_TYPE IN('EMP'
, 'EMP_APL'))
AND PEO.PERSON_ID = PAF.PERSON_ID
AND PAF.BUSINESS_GROUP_ID = BUS.ORGANIZATION_ID
AND PAF.PRIMARY_FLAG = 'Y'
AND PAF.ASSIGNMENT_TYPE = 'E'
AND BUS.LANGUAGE = USERENV('LANG')
AND PAF.JOB_ID = JBT.JOB_ID (+)
AND JBT.LANGUAGE(+) = USERENV('LANG')
AND PAF.ORGANIZATION_ID = ORG.ORGANIZATION_ID (+)
AND ORG.LANGUAGE = USERENV('LANG')

Columns