View: HR_EMPLOYEE_ASSIGNMENTS_V

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

View Text

SELECT PAF.ASSIGNMENT_NUMBER
, HAOU.NAME ORGANIZATION_NAME
, PJ.NAME JOB_NAME
, PAPF.FULL_NAME SUPERVISOR_NAME
, PAP.PAYROLL_NAME
, PG.NAME GRADE_NAME
, POS.NAME POSITION_NAME
, HL.DESCRIPTION LOCATION_NAME
, PAF.PERSON_ID
, PAF.ASSIGNMENT_ID
, PAF.EFFECTIVE_START_DATE
, PAF.EFFECTIVE_END_DATE
, PAF.BUSINESS_GROUP_ID
, PAF.ORGANIZATION_ID
, PAF.SUPERVISOR_ID
, PAF.LOCATION_ID
, PAF.JOB_ID
, PAF.PAYROLL_ID
FROM HR_LOCATIONS HL
, PER_GRADES PG
, PER_ALL_POSITIONS POS
, PAY_ALL_PAYROLLS_F PAP
, PER_ALL_PEOPLE_F PAPF
, PER_JOBS PJ
, HR_ALL_ORGANIZATION_UNITS HAOU
, PER_ASSIGNMENTS_F PAF
, FND_SESSIONS FS
WHERE HAOU.ORGANIZATION_ID = PAF.ORGANIZATION_ID
AND FS.SESSION_ID = USERENV('SESSIONID')
AND FS.EFFECTIVE_DATE BETWEEN PAF.EFFECTIVE_START_DATE
AND PAF.EFFECTIVE_END_DATE
AND PJ.JOB_ID(+) = PAF.JOB_ID
AND PAF.SUPERVISOR_ID = PAPF.PERSON_ID(+)
AND FS.EFFECTIVE_DATE BETWEEN NVL(PAPF.EFFECTIVE_START_DATE
, FS.EFFECTIVE_DATE)
AND NVL(PAPF.EFFECTIVE_END_DATE
, FS.EFFECTIVE_DATE)
AND PAP.PAYROLL_ID = PAF.PAYROLL_ID
AND FS.EFFECTIVE_DATE BETWEEN NVL(PAP.EFFECTIVE_START_DATE
, FS.EFFECTIVE_DATE)
AND NVL(PAP.EFFECTIVE_END_DATE
, FS.EFFECTIVE_DATE)
AND PG.GRADE_ID(+) = PAF.GRADE_ID
AND POS.POSITION_ID(+) = PAF.POSITION_ID
AND HL.LOCATION_ID = PAF.LOCATION_ID

Columns