VIEW: APPS.PER_PEOPLE_ASSIGNMENTS_VIEW

Source

View Text - Preformatted

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 (+)

View Text - HTML Formatted

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 (+)