VIEW: APPS.PAY_ELEMENT_TYPES_X

Source

View Text - Preformatted

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, PET.ADVANCE_ELEMENT_TYPE_ID, PET.DEDUCTION_ELEMENT_TYPE_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

View Text - HTML Formatted

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
, PET.ADVANCE_ELEMENT_TYPE_ID
, PET.DEDUCTION_ELEMENT_TYPE_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