VIEW: APPS.PAY_ELEMENT_TYPES_F_VL

Source

View Text - Preformatted

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, B.ADVANCE_ELEMENT_TYPE_ID, B.DEDUCTION_ELEMENT_TYPE_ID 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')

View Text - HTML Formatted

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
, B.ADVANCE_ELEMENT_TYPE_ID
, B.DEDUCTION_ELEMENT_TYPE_ID
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')