Product: | PER - Human Resources |
---|---|
Description: | Used to support user interface |
Implementation/DBA Data: | APPS.PER_SECONDARY_ASS_STATUSES_V |
SELECT S.ROWID
, S.SECONDARY_ASS_STATUS_ID
, S.BUSINESS_GROUP_ID + 0
, S.ASSIGNMENT_ID
, S.ASSIGNMENT_STATUS_TYPE_ID
, NVL(AMDTL.USER_STATUS
, TYPTL.USER_STATUS)
, S.START_DATE
, S.COMMENTS
, S.END_DATE
, S.REASON
, EMP.MEANING
, APL.MEANING
, S.REQUEST_ID
, S.PROGRAM_APPLICATION_ID
, S.PROGRAM_ID
, S.PROGRAM_UPDATE_DATE
, S.ATTRIBUTE_CATEGORY
, S.ATTRIBUTE1
, S.ATTRIBUTE2
, S.ATTRIBUTE3
, S.ATTRIBUTE4
, S.ATTRIBUTE5
, S.ATTRIBUTE6
, S.ATTRIBUTE7
, S.ATTRIBUTE8
, S.ATTRIBUTE9
, S.ATTRIBUTE10
, S.ATTRIBUTE11
, S.ATTRIBUTE12
, S.ATTRIBUTE13
, S.ATTRIBUTE14
, S.ATTRIBUTE15
, S.ATTRIBUTE16
, S.ATTRIBUTE17
, S.ATTRIBUTE18
, S.ATTRIBUTE19
, S.ATTRIBUTE20
, S.LAST_UPDATE_DATE
, S.LAST_UPDATED_BY
, S.LAST_UPDATE_LOGIN
, S.CREATED_BY
, S.CREATION_DATE
FROM PER_SECONDARY_ASS_STATUSES S
, PER_ASSIGNMENT_STATUS_TYPES TYP
, PER_ASSIGNMENT_STATUS_TYPES_TL TYPTL
, PER_ASS_STATUS_TYPE_AMENDS AMD
, PER_ASS_STATUS_TYPE_AMENDS_TL AMDTL
, HR_LOOKUPS EMP
, HR_LOOKUPS APL
WHERE S.ASSIGNMENT_STATUS_TYPE_ID = TYP.ASSIGNMENT_STATUS_TYPE_ID
AND S.ASSIGNMENT_STATUS_TYPE_ID = AMD.ASSIGNMENT_STATUS_TYPE_ID(+)
AND S.BUSINESS_GROUP_ID + 0 = AMD.BUSINESS_GROUP_ID(+) + 0
AND TYP.PRIMARY_FLAG = 'S'
AND S.REASON = EMP.LOOKUP_CODE(+)
AND EMP.LOOKUP_TYPE(+) = 'EMP_SEC_ASSIGN_REASON'
AND S.REASON = APL.LOOKUP_CODE(+)
AND APL.LOOKUP_TYPE(+) = 'APL_SEC_ASSIGN_REASON'
AND TYP.ASSIGNMENT_STATUS_TYPE_ID = TYPTL.ASSIGNMENT_STATUS_TYPE_ID
AND TYPTL.LANGUAGE = USERENV('LANG')
AND AMD.ASS_STATUS_TYPE_AMEND_ID = AMDTL.ASS_STATUS_TYPE_AMEND_ID (+)
AND DECODE (AMDTL.ASS_STATUS_TYPE_AMEND_ID
, NULL
, '1'
, AMDTL.LANGUAGE) = DECODE (AMDTL.ASS_STATUS_TYPE_AMEND_ID
, NULL
, '1'
, USERENV('LANG'))