VIEW: APPS.PAY_ASS_STATUS_TYPES_PLUS_STD

Source

View Text - Preformatted

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

View Text - HTML Formatted

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