View: PER_ASSIGNMENTS_V10

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

View Text

SELECT ASG.PERSON_ID
, ASG.ASSIGNMENT_ID
, ASG.PRIMARY_FLAG
, ASG.CONTRACT_ID
, ASG.ASSIGNMENT_STATUS_TYPE_ID
, ASG.LOCATION_ID
, ASG.ORGANIZATION_ID
, ASG.ASSIGNMENT_NUMBER
, ASG.PAYROLL_ID
, ASG.EMPLOYMENT_CATEGORY
, JBT.NAME
, JOB.JOB_ID
, JOB.JOB_DEFINITION_ID
, PFT.NAME
, POS.POSITION_ID
, POS.POSITION_DEFINITION_ID
, GDT.NAME
, GRA.GRADE_ID
, GRA.GRADE_DEFINITION_ID
, PPG.GROUP_NAME
, PPG.PEOPLE_GROUP_ID
, ASG.BUSINESS_GROUP_ID
FROM PER_ASSIGNMENTS_F ASG
, FND_SESSIONS SES
, PER_JOBS JOB
, PER_POSITIONS POS
, PER_GRADES GRA
, PER_JOBS_TL JBT
, HR_ALL_POSITIONS_F_TL PFT
, PER_GRADES_TL GDT
, PAY_PEOPLE_GROUPS PPG
WHERE ASG.JOB_ID = JOB.JOB_ID (+)
AND ASG.JOB_ID = JBT.JOB_ID (+)
AND JBT.LANGUAGE (+) = USERENV('LANG')
AND ASG.POSITION_ID = POS.POSITION_ID (+)
AND ASG.POSITION_ID = PFT.POSITION_ID (+)
AND PFT.LANGUAGE (+) = USERENV('LANG')
AND ASG.GRADE_ID = GRA.GRADE_ID (+)
AND ASG.GRADE_ID = GDT.GRADE_ID (+)
AND GDT.LANGUAGE (+) = USERENV('LANG')
AND ASG.PEOPLE_GROUP_ID = PPG.PEOPLE_GROUP_ID (+)
AND SES.SESSION_ID = USERENV('SESSIONID')
AND SES.EFFECTIVE_DATE BETWEEN ASG.EFFECTIVE_START_DATE
AND ASG.EFFECTIVE_END_DATE
AND ASG.ASSIGNMENT_TYPE IN ('A'
, 'E')

Columns