View: PER_ASSIGNMENT_STATUS_LOV

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

View Text

SELECT T.ASSIGNMENT_STATUS_TYPE_ID
, NVL(ATL.USER_STATUS
, TTL.USER_STATUS)
, L.MEANING
, T.BUSINESS_GROUP_ID + 0
, A.BUSINESS_GROUP_ID + 0
, T.LEGISLATION_CODE
FROM PER_ASSIGNMENT_STATUS_TYPES T
, PER_ASSIGNMENT_STATUS_TYPES_TL TTL
, PER_ASS_STATUS_TYPE_AMENDS A
, PER_ASS_STATUS_TYPE_AMENDS_TL ATL
, HR_LOOKUPS L
WHERE A.ASSIGNMENT_STATUS_TYPE_ID (+) = T.ASSIGNMENT_STATUS_TYPE_ID
AND TTL.ASSIGNMENT_STATUS_TYPE_ID = T.ASSIGNMENT_STATUS_TYPE_ID
AND ATL.ASS_STATUS_TYPE_AMEND_ID (+) = A.ASS_STATUS_TYPE_AMEND_ID
AND T.PER_SYSTEM_STATUS IN ('ACTIVE_APL'
, 'OFFER'
, 'ACCEPTED'
, 'TERM_APL'
, 'INTERVIEW1'
, 'INTERVIEW2')
AND L.LOOKUP_TYPE = 'PER_ASS_SYS_STATUS'
AND L.LOOKUP_CODE = T.PER_SYSTEM_STATUS
AND NVL(A.ACTIVE_FLAG
, T.ACTIVE_FLAG) = 'Y'
AND TTL.LANGUAGE = USERENV('LANG')
AND DECODE (ATL.ASS_STATUS_TYPE_AMEND_ID
, NULL
, '1'
, ATL.LANGUAGE) = DECODE (ATL.ASS_STATUS_TYPE_AMEND_ID
, NULL
, '1'
, USERENV('LANG'))

Columns