View: HRI_CL_ASGSTYP_BX_V

Product:	HRI - Human Resources Intelligence (Obsolete)
Description:
Implementation/DBA Data:	APPS.HRI_CL_ASGSTYP_BX_V

View Text

SELECT AST.ASSIGNMENT_STATUS_TYPE_ID ID
, NVL(AST_TL.USER_STATUS
, ASA_TL.USER_STATUS) VALUE
, HR_GENERAL.START_OF_TIME DATE_FROM
, HR_GENERAL.END_OF_TIME DATE_TO
, NVL(AST.BUSINESS_GROUP_ID
, ASA.BUSINESS_GROUP_ID) BUSINESS_GROUP_ID
, AST.PAY_SYSTEM_STATUS PAY_SYSTEM_STATUS
, AST.PER_SYSTEM_STATUS PER_SYSTEM_STATUS
, AST.PRIMARY_FLAG PRIMARY_FLAG
, AST.DEFAULT_FLAG DEFAULT_FLAG
, NVL(AST.ACTIVE_FLAG
, ASA.ACTIVE_FLAG) VALID_CODE
FROM PER_ASSIGNMENT_STATUS_TYPES AST
, PER_ASSIGNMENT_STATUS_TYPES_TL AST_TL
, PER_ASS_STATUS_TYPE_AMENDS ASA
, PER_ASS_STATUS_TYPE_AMENDS_TL ASA_TL
WHERE NVL(ASA.ACTIVE_FLAG
, AST.ACTIVE_FLAG) = 'Y'
AND AST.ASSIGNMENT_STATUS_TYPE_ID = ASA.ASSIGNMENT_STATUS_TYPE_ID (+)
AND AST.ASSIGNMENT_STATUS_TYPE_ID = AST_TL.ASSIGNMENT_STATUS_TYPE_ID
AND ASA.ASS_STATUS_TYPE_AMEND_ID = ASA_TL.ASS_STATUS_TYPE_AMEND_ID (+)
AND AST_TL.LANGUAGE = USERENV('LANG')
AND DECODE (ASA_TL.ASS_STATUS_TYPE_AMEND_ID
, NULL
, '1'
, ASA_TL.LANGUAGE) = DECODE (ASA_TL.ASS_STATUS_TYPE_AMEND_ID
, NULL
, '1'
, USERENV('LANG'))
AND NVL(AST.BUSINESS_GROUP_ID
, ASA.BUSINESS_GROUP_ID) = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, NVL(AST.BUSINESS_GROUP_ID
, ASA.BUSINESS_GROUP_ID)) WITH READ ONLY

Columns