View: PER_ASSIGNMENT_STATUS_TYPES_V

Product:	PER - Human Resources
Description:	Used to support status types table and translated table
Implementation/DBA Data:	APPS.PER_ASSIGNMENT_STATUS_TYPES_V

View Text

SELECT AST.ROWID
, AST.ASSIGNMENT_STATUS_TYPE_ID
, AST.BUSINESS_GROUP_ID
, AST.LEGISLATION_CODE
, ASTTL.USER_STATUS
, AST.ACTIVE_FLAG
, AST.DEFAULT_FLAG
, AST.PRIMARY_FLAG
, AST.PAY_SYSTEM_STATUS
, AST.PER_SYSTEM_STATUS
, ASTTL.EXTERNAL_STATUS
, AST.LAST_UPDATE_DATE
, AST.LAST_UPDATED_BY
, AST.LAST_UPDATE_LOGIN
, AST.CREATED_BY
, AST.CREATION_DATE
FROM PER_ASSIGNMENT_STATUS_TYPES_TL ASTTL
, PER_ASSIGNMENT_STATUS_TYPES AST
WHERE AST.ASSIGNMENT_STATUS_TYPE_ID = ASTTL.ASSIGNMENT_STATUS_TYPE_ID
AND ASTTL.LANGUAGE = USERENV('LANG')

Columns