VIEW: APPS.HRBV_ASS_STATUS_TYPE_AMENDS_V

Source

View Text - Preformatted

SELECT STAT.USER_STATUS, STA.PAY_SYSTEM_STATUS, HR_BIS.BIS_DECODE_LOOKUP('PAY_ASS_SYS_STATUS',STA.PAY_SYSTEM_STATUS), STA.PER_SYSTEM_STATUS, HR_BIS.BIS_DECODE_LOOKUP('PER_ASS_SYS_STATUS',STA.PER_SYSTEM_STATUS), STA.ACTIVE_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',STA.ACTIVE_FLAG), STA.DEFAULT_FLAG, HR_BIS.BIS_DECODE_LOOKUP('YES_NO',STA.DEFAULT_FLAG), STA.ASS_STATUS_TYPE_AMEND_ID, STA.ASSIGNMENT_STATUS_TYPE_ID, STA.BUSINESS_GROUP_ID, STA.LAST_UPDATE_DATE, STA.LAST_UPDATED_BY, STA.CREATED_BY, STA.CREATION_DATE, CASE WHEN STA.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID, STA.BUSINESS_GROUP_ID) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE FROM PER_ASS_STATUS_TYPE_AMENDS STA, PER_ASS_STATUS_TYPE_AMENDS_TL STAT WHERE STA.ASS_STATUS_TYPE_AMEND_ID = STAT.ASS_STATUS_TYPE_AMEND_ID AND STAT.LANGUAGE = USERENV('LANG') WITH READ ONLY

View Text - HTML Formatted

SELECT STAT.USER_STATUS
, STA.PAY_SYSTEM_STATUS
, HR_BIS.BIS_DECODE_LOOKUP('PAY_ASS_SYS_STATUS'
, STA.PAY_SYSTEM_STATUS)
, STA.PER_SYSTEM_STATUS
, HR_BIS.BIS_DECODE_LOOKUP('PER_ASS_SYS_STATUS'
, STA.PER_SYSTEM_STATUS)
, STA.ACTIVE_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, STA.ACTIVE_FLAG)
, STA.DEFAULT_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, STA.DEFAULT_FLAG)
, STA.ASS_STATUS_TYPE_AMEND_ID
, STA.ASSIGNMENT_STATUS_TYPE_ID
, STA.BUSINESS_GROUP_ID
, STA.LAST_UPDATE_DATE
, STA.LAST_UPDATED_BY
, STA.CREATED_BY
, STA.CREATION_DATE
, CASE WHEN STA.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, STA.BUSINESS_GROUP_ID) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE
FROM PER_ASS_STATUS_TYPE_AMENDS STA
, PER_ASS_STATUS_TYPE_AMENDS_TL STAT
WHERE STA.ASS_STATUS_TYPE_AMEND_ID = STAT.ASS_STATUS_TYPE_AMEND_ID
AND STAT.LANGUAGE = USERENV('LANG') WITH READ ONLY