View: PAY_ALL_EARNINGS_TYPES_V

Product:	PAY - Payroll
Description:	Used to support user interface
Implementation/DBA Data:	APPS.PAY_ALL_EARNINGS_TYPES_V

View Text

SELECT ET.ELEMENT_TYPE_ID
, ET.EFFECTIVE_START_DATE
, ET.EFFECTIVE_END_DATE
, ET.BUSINESS_GROUP_ID + 0 BUSINESS_GROUP_ID
, ET.LEGISLATION_CODE
, ETTL.ELEMENT_NAME
, ETTL.REPORTING_NAME
, ETTL.DESCRIPTION
, ECTL.CLASSIFICATION_NAME
, HR_GENERAL.DECODE_LOOKUP(DECODE(UPPER(EC.CLASSIFICATION_NAME)
, 'EARNINGS'
, 'US_EARNINGS'
, 'SUPPLEMENTAL EARNINGS'
, 'US_SUPPLEMENTAL_EARNINGS'
, 'IMPUTED EARNINGS'
, 'US_IMPUTED_EARNINGS'
, 'NON-PAYROLL PAYMENTS'
, 'US_PAYMENT'
, 'ALIEN/EXPAT EARNINGS'
, 'PER_US_INCOME_TYPES'
, NULL)
, ET.ELEMENT_INFORMATION1) CATEGORY
, HR_GENERAL.DECODE_LOOKUP('US_SUPPLEMENTAL_EARNINGS'
, ET.ELEMENT_INFORMATION14) ALIEN_EXPAT_SUPPL_CATEGORY
, NVL(ET.ELEMENT_INFORMATION8
, 'N') INCLUDE_IN_OT_BASE
, NVL(ET.ELEMENT_INFORMATION11
, 'N') FLSA_HOURS
, ET.ELEMENT_INFORMATION9 MIX_CATEGORY
, ET.PROCESSING_TYPE
, ET.PROCESSING_PRIORITY
, ET.STANDARD_LINK_FLAG
, ET.ELEMENT_INFORMATION10 PRIMARY_BALTYPE_ID
, ET.ELEMENT_INFORMATION12 HOURS_BALTYPE_ID
, ET.ELEMENT_INFORMATION13 REDUCE_REGULAR
, ET.LAST_UPDATE_DATE
, ET.LAST_UPDATED_BY
, ET.LAST_UPDATE_LOGIN
, ET.CREATED_BY
, ET.CREATION_DATE
FROM PAY_ELEMENT_TYPES_F_TL ETTL
, PAY_ELEMENT_TYPES_F ET
, PAY_ELEMENT_CLASSIFICATIONS_TL ECTL
, PAY_ELEMENT_CLASSIFICATIONS EC
WHERE ET.ELEMENT_TYPE_ID = ETTL.ELEMENT_TYPE_ID
AND ETTL.LANGUAGE = USERENV('LANG')
AND EC.CLASSIFICATION_ID = ECTL.CLASSIFICATION_ID
AND ECTL.LANGUAGE = USERENV('LANG')
AND EC.CLASSIFICATION_NAME IN ( 'EARNINGS'
, 'SUPPLEMENTAL EARNINGS'
, 'IMPUTED EARNINGS'
, 'NON-PAYROLL PAYMENTS'
, 'ALIEN/EXPAT EARNINGS')
AND EC.CLASSIFICATION_ID = ET.CLASSIFICATION_ID
AND ET.EFFECTIVE_START_DATE <= (SELECT S.EFFECTIVE_DATE
FROM FND_SESSIONS S
WHERE S.SESSION_ID = USERENV('SESSIONID'))
AND ET.EFFECTIVE_END_DATE >= (SELECT S.EFFECTIVE_DATE
FROM FND_SESSIONS S
WHERE S.SESSION_ID = USERENV('SESSIONID'))
AND EC.LEGISLATION_CODE = 'US'

Columns