View: PAY_ELEMENT_TYPES_X

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

View Text

SELECT PET.ELEMENT_TYPE_ID
, PET.EFFECTIVE_START_DATE
, PET.EFFECTIVE_END_DATE
, PET.BUSINESS_GROUP_ID
, PET.LEGISLATION_CODE
, PET.FORMULA_ID
, PET.INPUT_CURRENCY_CODE
, PET.OUTPUT_CURRENCY_CODE
, PET.CLASSIFICATION_ID
, PET.BENEFIT_CLASSIFICATION_ID
, PET.ADDITIONAL_ENTRY_ALLOWED_FLAG
, PET.ADJUSTMENT_ONLY_FLAG
, PET.CLOSED_FOR_ENTRY_FLAG
, PETTL.ELEMENT_NAME
, PET.INDIRECT_ONLY_FLAG
, PET.MULTIPLE_ENTRIES_ALLOWED_FLAG
, PET.MULTIPLY_VALUE_FLAG
, PET.POST_TERMINATION_RULE
, PET.PROCESS_IN_RUN_FLAG
, PET.PROCESSING_PRIORITY
, PET.PROCESSING_TYPE
, PET.STANDARD_LINK_FLAG
, PET.COMMENT_ID
, PETTL.DESCRIPTION
, PET.LEGISLATION_SUBGROUP
, PET.QUALIFYING_AGE
, PET.QUALIFYING_LENGTH_OF_SERVICE
, PET.QUALIFYING_UNITS
, PETTL.REPORTING_NAME
, PET.ATTRIBUTE_CATEGORY
, PET.ATTRIBUTE1
, PET.ATTRIBUTE2
, PET.ATTRIBUTE3
, PET.ATTRIBUTE4
, PET.ATTRIBUTE5
, PET.ATTRIBUTE6
, PET.ATTRIBUTE7
, PET.ATTRIBUTE8
, PET.ATTRIBUTE9
, PET.ATTRIBUTE10
, PET.ATTRIBUTE11
, PET.ATTRIBUTE12
, PET.ATTRIBUTE13
, PET.ATTRIBUTE14
, PET.ATTRIBUTE15
, PET.ATTRIBUTE16
, PET.ATTRIBUTE17
, PET.ATTRIBUTE18
, PET.ATTRIBUTE19
, PET.ATTRIBUTE20
, PET.LAST_UPDATE_DATE
, PET.LAST_UPDATED_BY
, PET.LAST_UPDATE_LOGIN
, PET.CREATED_BY
, PET.CREATION_DATE
, PET.ELEMENT_INFORMATION_CATEGORY
, PET.ELEMENT_INFORMATION1
, PET.ELEMENT_INFORMATION2
, PET.ELEMENT_INFORMATION3
, PET.ELEMENT_INFORMATION4
, PET.ELEMENT_INFORMATION5
, PET.ELEMENT_INFORMATION6
, PET.ELEMENT_INFORMATION7
, PET.ELEMENT_INFORMATION8
, PET.ELEMENT_INFORMATION9
, PET.ELEMENT_INFORMATION10
, PET.ELEMENT_INFORMATION11
, PET.ELEMENT_INFORMATION12
, PET.ELEMENT_INFORMATION13
, PET.ELEMENT_INFORMATION14
, PET.ELEMENT_INFORMATION15
, PET.ELEMENT_INFORMATION16
, PET.ELEMENT_INFORMATION17
, PET.ELEMENT_INFORMATION18
, PET.ELEMENT_INFORMATION19
, PET.ELEMENT_INFORMATION20
, PET.THIRD_PARTY_PAY_ONLY_FLAG
, PET.ELEMENT_NAME SYSTEM_ELEMENT_NAME
, PET.OBJECT_VERSION_NUMBER
, PET.ITERATIVE_FLAG
, PET.ITERATIVE_FORMULA_ID
, PET.ITERATIVE_PRIORITY
, PET.CREATOR_TYPE
, PET.RETRO_SUMM_ELE_ID
, PET.GROSSUP_FLAG
, PET.PROCESS_MODE
, PET.ADVANCE_INDICATOR
, PET.ADVANCE_PAYABLE
, PET.ADVANCE_DEDUCTION
, PET.PROCESS_ADVANCE_ENTRY
, PET.PRORATION_GROUP_ID
, PET.PRORATION_FORMULA_ID
, PET.RECALC_EVENT_GROUP_ID
FROM 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 TRUNC(SYSDATE) BETWEEN EFFECTIVE_START_DATE
AND EFFECTIVE_END_DATE

Columns