View: PAYBV_ELEMENT_TYPE

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

View Text

SELECT PETT.ELEMENT_NAME
, PET.EFFECTIVE_START_DATE
, PET.EFFECTIVE_END_DATE
, PET.LEGISLATION_CODE
, PET.INPUT_CURRENCY_CODE
, PET.OUTPUT_CURRENCY_CODE
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PET.ADDITIONAL_ENTRY_ALLOWED_FLAG) ADDITIONAL_ENTRY_ALLOWED_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PET.ADJUSTMENT_ONLY_FLAG) ADJUSTMENT_ONLY_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PET.CLOSED_FOR_ENTRY_FLAG) CLOSED_FOR_ENTRY_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PET.INDIRECT_ONLY_FLAG) INDIRECT_ONLY_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PET.MULTIPLE_ENTRIES_ALLOWED_FLAG) MULTIPLE_ENTRIES_ALLOWED_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PET.MULTIPLY_VALUE_FLAG) MULTIPLY_VALUE_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('TERMINATION_RULE'
, PET.POST_TERMINATION_RULE) POST_TERMINATION_RULE
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PET.PROCESS_IN_RUN_FLAG) PROCESS_IN_RUN_FLAG
, PET.PROCESSING_PRIORITY
, HR_BIS.BIS_DECODE_LOOKUP('PROCESSING_TYPE'
, PET.PROCESSING_TYPE) PROCESSING_TYPE
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PET.STANDARD_LINK_FLAG) STANDARD_LINK_FLAG
, PET.DESCRIPTION
, PET.LEGISLATION_SUBGROUP
, PET.QUALIFYING_AGE
, PET.QUALIFYING_LENGTH_OF_SERVICE
, HR_BIS.BIS_DECODE_LOOKUP('QUALIFYING_UNITS'
, PET.QUALIFYING_UNITS) QUALIFYING_UNITS
, PETT.REPORTING_NAME
, '_DF:PAY:PAY_ELEMENT_TYPES:PET'
, 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.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
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PET.THIRD_PARTY_PAY_ONLY_FLAG) THIRD_PARTY_PAY_ONLY_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PET.ITERATIVE_FLAG) ITERATIVE_FLAG
, PET.ITERATIVE_PRIORITY
, HR_BIS.BIS_DECODE_LOOKUP('CREATOR_TYPE'
, PET.CREATOR_TYPE) CREATOR_TYPE
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PET.GROSSUP_FLAG) GROSSUP_FLAG
, PET.PROCESS_MODE
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PET.ADVANCE_INDICATOR) ADVANCE_INDICATOR
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PET.ADVANCE_PAYABLE) ADVANCE_PAYABLE
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PET.ADVANCE_DEDUCTION) ADVANCE_DEDUCTION
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PET.PROCESS_ADVANCE_ENTRY) PROCESS_ADVANCE_ENTRY
, PET.ADDITIONAL_ENTRY_ALLOWED_FLAG ADD_ENTRY_ALLOWED_FLAG_CODE
, PET.ADJUSTMENT_ONLY_FLAG ADJUSTMENT_ONLY_FLAG_CODE
, PET.CLOSED_FOR_ENTRY_FLAG CLOSED_FOR_ENTRY_FLAG_CODE
, PET.INDIRECT_ONLY_FLAG INDIRECT_ONLY_FLAG_CODE
, PET.MULTIPLE_ENTRIES_ALLOWED_FLAG MULTIPLE_ENTRIES_ALLOWED_CODE
, PET.MULTIPLY_VALUE_FLAG MULTIPLY_VALUE_FLAG_CODE
, PET.POST_TERMINATION_RULE POST_TERMINATION_RULE_CODE
, PET.PROCESS_IN_RUN_FLAG PROCESS_IN_RUN_FLAG_CODE
, PET.PROCESSING_TYPE PROCESSING_TYPE_CODE
, PET.STANDARD_LINK_FLAG STANDARD_LINK_FLAG_CODE
, PET.QUALIFYING_UNITS QUALIFYING_UNITS_CODE
, PET.THIRD_PARTY_PAY_ONLY_FLAG THIRD_PARTY_PAY_ONLY_CODE
, PET.ITERATIVE_FLAG ITERATIVE_FLAG_CODE
, PET.CREATOR_TYPE CREATOR_TYPE_CODE
, PET.GROSSUP_FLAG GROSSUP_FLAG_CODE
, PET.ADVANCE_INDICATOR ADVANCE_INDICATOR_CODE
, PET.ADVANCE_PAYABLE ADVANCE_PAYABLE_CODE
, PET.ADVANCE_DEDUCTION ADVANCE_DEDUCTION_CODE
, PET.PROCESS_ADVANCE_ENTRY PROCESS_ADVANCE_ENTRY_CODE
, PET.ELEMENT_TYPE_ID
, PET.BUSINESS_GROUP_ID
, PET.FORMULA_ID
, PET.CLASSIFICATION_ID
, PET.BENEFIT_CLASSIFICATION_ID
, PET.COMMENT_ID
, PET.ITERATIVE_FORMULA_ID
, PET.RETRO_SUMM_ELE_ID
, PET.PRORATION_GROUP_ID
, PET.PRORATION_FORMULA_ID
, PET.RECALC_EVENT_GROUP_ID
, PET.OBJECT_VERSION_NUMBER
, PET.LAST_UPDATE_DATE
, PET.LAST_UPDATED_BY
, PET.LAST_UPDATE_LOGIN
, PET.CREATED_BY
, PET.CREATION_DATE
, CASE WHEN ((PET.BUSINESS_GROUP_ID IS NULL
AND PET.LEGISLATION_CODE IS NULL) OR (PET.BUSINESS_GROUP_ID IS NULL
AND PET.LEGISLATION_CODE = NVL(HR_BIS.GET_LEGISLATION_CODE
, PET.LEGISLATION_CODE)) OR (PET.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, PET.BUSINESS_GROUP_ID))) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE
FROM PAY_ELEMENT_TYPES_F PET
, PAY_ELEMENT_TYPES_F_TL PETT
WHERE PET.ELEMENT_TYPE_ID = PETT.ELEMENT_TYPE_ID
AND PETT.LANGUAGE = USERENV('LANG') WITH READ ONLY

Columns