View: PAY_ELEMENT_TYPES

Product:	PAY - Payroll
Description:	Date-effective view.
Implementation/DBA Data:	APPS.PAY_ELEMENT_TYPES

View Text

SELECT PETF. ELEMENT_TYPE_ID
, PETF.EFFECTIVE_START_DATE
, PETF.EFFECTIVE_END_DATE
, PETF.BUSINESS_GROUP_ID
, PETF.LEGISLATION_CODE
, PETF.FORMULA_ID
, PETF.INPUT_CURRENCY_CODE
, PETF.OUTPUT_CURRENCY_CODE
, PETF.CLASSIFICATION_ID
, PETF.BENEFIT_CLASSIFICATION_ID
, PETF.ADDITIONAL_ENTRY_ALLOWED_FLAG
, PETF.ADJUSTMENT_ONLY_FLAG
, PETF.CLOSED_FOR_ENTRY_FLAG
, PETFTL.ELEMENT_NAME
, PETFTL.ELEMENT_NAME SYSTEM_NAME
, PETF.INDIRECT_ONLY_FLAG
, PETF.MULTIPLE_ENTRIES_ALLOWED_FLAG
, PETF.MULTIPLY_VALUE_FLAG
, PETF.POST_TERMINATION_RULE
, PETF.PROCESS_IN_RUN_FLAG
, PETF.PROCESSING_PRIORITY
, PETF.PROCESSING_TYPE
, PETF.STANDARD_LINK_FLAG
, PETF.COMMENT_ID
, PETFTL.DESCRIPTION
, PETF. LEGISLATION_SUBGROUP
, PETF. QUALIFYING_AGE
, PETF.QUALIFYING_LENGTH_OF_SERVICE
, PETF.QUALIFYING_UNITS
, PETFTL. REPORTING_NAME
, PETF. ATTRIBUTE_CATEGORY
, PETF.ATTRIBUTE1
, PETF.ATTRIBUTE2
, PETF.ATTRIBUTE3
, PETF.ATTRIBUTE4
, PETF.ATTRIBUTE5
, PETF.ATTRIBUTE6
, PETF.ATTRIBUTE7
, PETF.ATTRIBUTE8
, PETF.ATTRIBUTE9
, PETF.ATTRIBUTE10
, PETF.ATTRIBUTE11
, PETF.ATTRIBUTE12
, PETF.ATTRIBUTE13
, PETF. ATTRIBUTE14
, PETF.ATTRIBUTE15
, PETF.ATTRIBUTE16
, PETF.ATTRIBUTE17
, PETF.ATTRIBUTE18
, PETF.ATTRIBUTE19
, PETF.ATTRIBUTE20
, PETF. LAST_UPDATE_DATE
, PETF. LAST_UPDATED_BY
, PETF. LAST_UPDATE_LOGIN
, PETF.CREATED_BY
, PETF.CREATION_DATE
, PETF. ELEMENT_INFORMATION_CATEGORY
, PETF. ELEMENT_INFORMATION1
, PETF. ELEMENT_INFORMATION2
, PETF. ELEMENT_INFORMATION3
, PETF. ELEMENT_INFORMATION4
, PETF. ELEMENT_INFORMATION5
, PETF. ELEMENT_INFORMATION6
, PETF. ELEMENT_INFORMATION7
, PETF. ELEMENT_INFORMATION8
, PETF. ELEMENT_INFORMATION9
, PETF.ELEMENT_INFORMATION10
, PETF.ELEMENT_INFORMATION11
, PETF.ELEMENT_INFORMATION12
, PETF.ELEMENT_INFORMATION13
, PETF.ELEMENT_INFORMATION14
, PETF.ELEMENT_INFORMATION15
, PETF.ELEMENT_INFORMATION16
, PETF.ELEMENT_INFORMATION17
, PETF.ELEMENT_INFORMATION18
, PETF.ELEMENT_INFORMATION19
, PETF. ELEMENT_INFORMATION20
, PETF. THIRD_PARTY_PAY_ONLY_FLAG
, PETF.ELEMENT_NAME SYSTEM_ELEMENT_NAME
, PETF.OBJECT_VERSION_NUMBER
, PETF.ITERATIVE_FLAG
, PETF.ITERATIVE_FORMULA_ID
, PETF.ITERATIVE_PRIORITY
, PETF.CREATOR_TYPE
, PETF.RETRO_SUMM_ELE_ID
, PETF.GROSSUP_FLAG
, PETF.PROCESS_MODE
, PETF.ADVANCE_INDICATOR
, PETF.ADVANCE_PAYABLE
, PETF.ADVANCE_DEDUCTION
, PETF.PROCESS_ADVANCE_ENTRY
, PETF.PRORATION_GROUP_ID
, PETF.PRORATION_FORMULA_ID
, PETF.RECALC_EVENT_GROUP_ID
FROM PAY_ELEMENT_TYPES_F PETF
, PAY_ELEMENT_TYPES_F_TL PETFTL
WHERE PETF.ELEMENT_TYPE_ID = PETFTL.ELEMENT_TYPE_ID
AND PETFTL.LANGUAGE = USERENV('LANG')
AND EFFECTIVE_START_DATE <= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))
AND EFFECTIVE_END_DATE >= (SELECT SE.EFFECTIVE_DATE
FROM FND_SESSIONS SE
WHERE SE.SESSION_ID = USERENV('SESSIONID'))

Columns