View: PAY_US_EARNINGS_TYPES_V

Product:	PAY - Payroll
Description:	This view retrieves a list of earnings elements: such as Supplemental Earnings, Imputed Earnings, Non-payroll Payments.
Implementation/DBA Data:	APPS.PAY_US_EARNINGS_TYPES_V

View Text

SELECT DISTINCT PETTL.ELEMENT_NAME
, PET.ELEMENT_TYPE_ID
, PET.EFFECTIVE_START_DATE
, PET.EFFECTIVE_END_DATE
, PECTL.CLASSIFICATION_NAME
, PEC.CLASSIFICATION_ID
FROM PAY_ELEMENT_CLASSIFICATIONS PEC
, PAY_ELEMENT_CLASSIFICATIONS_TL PECTL
, PAY_ELEMENT_TYPES_F PET
, PAY_ELEMENT_TYPES_F_TL PETTL
WHERE PET.ELEMENT_TYPE_ID = PETTL.ELEMENT_TYPE_ID
AND PETTL.LANGUAGE = USERENV ('LANG')
AND PEC.CLASSIFICATION_ID = PECTL.CLASSIFICATION_ID
AND PECTL.LANGUAGE = USERENV ('LANG')
AND PEC.CLASSIFICATION_NAME IN ('EARNINGS'
, 'SUPPLEMENTAL EARNINGS'
, 'IMPUTED EARNINGS'
, 'NON-PAYROLL PAYMENTS'
, 'ALIEN/EXPAT EARNINGS')
AND PEC.CLASSIFICATION_ID = PET.CLASSIFICATION_ID
AND PET.ELEMENT_NAME NOT LIKE '%SPECIAL FEATURES'
AND PET.ELEMENT_NAME NOT LIKE '%SPECIAL INPUTS'

Columns