View: PAY_ELEMENT_TYPES_F_VL

Product:	PAY - Payroll
Description:
Implementation/DBA Data:	APPS.PAY_ELEMENT_TYPES_F_VL

View Text

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

Columns