View: PER_PEOPLE_ASSIGNMENTS_VIEW

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

View Text

SELECT P.PERSON_ID
, P.BUSINESS_GROUP_ID
, P.FULL_NAME
, P.EMPLOYEE_NUMBER
, P.APPLICANT_NUMBER
, P.CURRENT_EMPLOYEE_FLAG
, P.CURRENT_APPLICANT_FLAG
, A.ASSIGNMENT_NUMBER
, A.ASSIGNMENT_TYPE
, A.ORGANIZATION_ID
, A.PAYROLL_ID
, A.ASSIGNMENT_ID
, A.EFFECTIVE_START_DATE
, A.EFFECTIVE_END_DATE
, A.ASSIGNMENT_STATUS_TYPE_ID
, PG.SEGMENT1
, PG.SEGMENT2
, PG.SEGMENT3
, PG.SEGMENT4
, PG.SEGMENT5
, PG.SEGMENT6
, PG.SEGMENT7
, PG.SEGMENT8
, PG.SEGMENT9
, PG.SEGMENT10
, PG.SEGMENT11
, PG.SEGMENT12
, PG.SEGMENT13
, PG.SEGMENT14
, PG.SEGMENT15
, PG.SEGMENT16
, PG.SEGMENT17
, PG.SEGMENT18
, PG.SEGMENT19
, PG.SEGMENT20
, PG.SEGMENT21
, PG.SEGMENT22
, PG.SEGMENT23
, PG.SEGMENT24
, PG.SEGMENT25
, PG.SEGMENT26
, PG.SEGMENT27
, PG.SEGMENT28
, PG.SEGMENT29
, PG.SEGMENT30
, G.GRADE_ID
, J.JOB_ID
, A.POSITION_ID
, A.PRIMARY_FLAG
, A.ASSIGNMENT_SEQUENCE
, P.OBJECT_VERSION_NUMBER
FROM PER_GRADES G
, PER_JOBS J
, PAY_PEOPLE_GROUPS PG
, PER_PEOPLE_F P
, PER_ASSIGNMENTS_F A
WHERE P.PERSON_ID = A.PERSON_ID
AND P.EFFECTIVE_START_DATE <= (SELECT S.EFFECTIVE_DATE
FROM FND_SESSIONS S
WHERE S.SESSION_ID = USERENV('SESSIONID'))
AND P.EFFECTIVE_END_DATE >= (SELECT S.EFFECTIVE_DATE
FROM FND_SESSIONS S
WHERE S.SESSION_ID = USERENV('SESSIONID'))
AND A.PEOPLE_GROUP_ID = PG.PEOPLE_GROUP_ID (+)
AND A.JOB_ID = J.JOB_ID (+)
AND A.GRADE_ID = G.GRADE_ID (+)

Columns