View: PAY_ASS_STATUS_TYPES_PLUS_STD

Product:	PAY - Payroll
Description:	List of assignment status types plus the STANDARD type, used for formula result rules.
Implementation/DBA Data:	APPS.PAY_ASS_STATUS_TYPES_PLUS_STD

View Text

SELECT PASTL.USER_STATUS
, PAS.ASSIGNMENT_STATUS_TYPE_ID
, PAS.BUSINESS_GROUP_ID
, PAS.LEGISLATION_CODE
, TO_CHAR(NULL) LOOKUP_CODE
FROM PER_ASSIGNMENT_STATUS_TYPES_TL PASTL
, PER_ASSIGNMENT_STATUS_TYPES PAS
WHERE PAS.ASSIGNMENT_STATUS_TYPE_ID = PASTL.ASSIGNMENT_STATUS_TYPE_ID
AND PASTL.LANGUAGE = USERENV('LANG') UNION SELECT HRL.MEANING
, FND_NUMBER.CANONICAL_TO_NUMBER(NULL)
, FND_NUMBER.CANONICAL_TO_NUMBER(NULL)
, TO_CHAR(NULL)
, HRL.LOOKUP_CODE
FROM HR_LOOKUPS HRL
WHERE HRL.APPLICATION_ID IN (800
, 801)
AND HRL.LOOKUP_TYPE = 'NAME_TRANSLATIONS'
AND HRL.LOOKUP_CODE IN ( 'STANDARD'
, 'BAL_ADJUST')

Columns