VIEW: APPS.PAY_ELEMENT_TYPES

Source

View Text - Preformatted

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, petf.ADVANCE_ELEMENT_TYPE_ID, petf.DEDUCTION_ELEMENT_TYPE_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'))

View Text - HTML Formatted

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
, PETF.ADVANCE_ELEMENT_TYPE_ID
, PETF.DEDUCTION_ELEMENT_TYPE_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'))