VIEW: APPS.PER_ASSIGNMENT_STATUS_LOV

Source

View Text - Preformatted

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'))

View Text - HTML Formatted

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'))