VIEW: APPS.PAYBV_ELEMENT_TYPE

Source

View Text - Preformatted

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

View Text - HTML Formatted

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