View: PAYFV_ELEMENT_TYPES

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

View Text

SELECT PETT.ELEMENT_NAME ELEMENT_NAME
, BGRT.NAME BUSINESS_GROUP_NAME
, PET.LEGISLATION_CODE
, DECODE(PET.FORMULA_ID
, NULL
, NULL
, PER_FORMULA_FUNCTIONS.GET_FORMULA (PET.FORMULA_ID
, PET.EFFECTIVE_START_DATE)) FORMULA_NAME
, PET.INPUT_CURRENCY_CODE
, PET.OUTPUT_CURRENCY_CODE
, PECT.CLASSIFICATION_NAME
, BBC.BENEFIT_CLASSIFICATION_NAME
, 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.QUALIFYING_AGE
, PET.QUALIFYING_LENGTH_OF_SERVICE
, HR_BIS.BIS_DECODE_LOOKUP('UNITS'
, PET.QUALIFYING_UNITS) QUALIFYING_UNITS
, PET.REPORTING_NAME
, 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
, DECODE(PET.ITERATIVE_FORMULA_ID
, NULL
, NULL
, PER_FORMULA_FUNCTIONS.GET_FORMULA (PET.ITERATIVE_FORMULA_ID
, PET.EFFECTIVE_START_DATE)) ITERATIVE_FORMULA_NAME
, PET.ITERATIVE_PRIORITY
, PETT2.ELEMENT_NAME RETRO_SUMM_ELEMENT
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PET.GROSSUP_FLAG) GROSSUP_FLAG
, DECODE(PET.PROCESS_MODE
, 'S'
, 'Y'
, 'N') SEPARATE_PAYMENT
, DECODE(PET.PROCESS_MODE
, 'P'
, 'Y'
, 'S'
, 'Y'
, 'N') PROCESS_SEPARATE_FLAG
, DECODE(PET.PRORATION_GROUP_ID
, NULL
, NULL
, PAY_PAYFV_ELEMENT_TYPES_PKG.GET_EVENT_GROUP_NAME(PET.PRORATION_GROUP_ID)) PRORATION_GROUP_NAME
, DECODE(PET.PRORATION_FORMULA_ID
, NULL
, NULL
, PER_FORMULA_FUNCTIONS.GET_FORMULA (PET.PRORATION_FORMULA_ID
, PET.EFFECTIVE_START_DATE)) PRORATION_FORMULA_NAME
, DECODE(PET.RECALC_EVENT_GROUP_ID
, NULL
, NULL
, PAY_PAYFV_ELEMENT_TYPES_PKG.GET_EVENT_GROUP_NAME(PET.RECALC_EVENT_GROUP_ID)) RECALC_EVENT_GROUP_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.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.ELEMENT_TYPE_ID
, PET.BUSINESS_GROUP_ID
, PET.FORMULA_ID
, PET.CLASSIFICATION_ID
, PET.BENEFIT_CLASSIFICATION_ID
, 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.PROCESS_IN_RUN_FLAG PROCESS_IN_RUN_FLAG_CODE
, PET.STANDARD_LINK_FLAG STANDARD_LINK_FLAG_CODE
, PET.THIRD_PARTY_PAY_ONLY_FLAG THIRD_PARTY_PAY_ONLY_FLAG_CODE
, PET.ITERATIVE_FLAG ITERATIVE_FLAG_CODE
, PET.GROSSUP_FLAG GROSSUP_FLAG_CODE
, PET.CREATION_DATE
, DECODE(PET.CREATED_BY
, NULL
, NULL
, PAY_PAYFV_ELEMENT_TYPES_PKG.GET_APPLSYS_USER(PET.CREATED_BY)) CREATED_BY
, PET.LAST_UPDATE_DATE
, DECODE(PET.LAST_UPDATED_BY
, NULL
, NULL
, PAY_PAYFV_ELEMENT_TYPES_PKG.GET_APPLSYS_USER(PET.LAST_UPDATED_BY)) LAST_UPDATED_BY
FROM PAY_ELEMENT_TYPES_F PET
, HR_ALL_ORGANIZATION_UNITS_TL BGRT
, PAY_ELEMENT_TYPES_F_TL PETT
, PAY_ELEMENT_TYPES_F_TL PETT2
, PAY_ELEMENT_CLASSIFICATIONS_TL PECT
, BEN_BENEFIT_CLASSIFICATIONS BBC
WHERE PET.ELEMENT_TYPE_ID = PETT.ELEMENT_TYPE_ID
AND PETT.LANGUAGE = USERENV('LANG')
AND PET.RETRO_SUMM_ELE_ID = PETT2.ELEMENT_TYPE_ID (+)
AND PETT2.LANGUAGE (+) = USERENV('LANG')
AND PET.BUSINESS_GROUP_ID+0 = BGRT.ORGANIZATION_ID (+)
AND BGRT.LANGUAGE (+) = USERENV('LANG')
AND PECT.LANGUAGE = USERENV('LANG')
AND PECT.CLASSIFICATION_ID = PET.CLASSIFICATION_ID
AND PET.BENEFIT_CLASSIFICATION_ID = BBC.BENEFIT_CLASSIFICATION_ID(+)
AND TRUNC(SYSDATE) BETWEEN PET.EFFECTIVE_START_DATE
AND PET.EFFECTIVE_END_DATE
AND ((HR_GENERAL.GET_BUSINESS_GROUP_ID IS NOT NULL
AND (PET.BUSINESS_GROUP_ID +0 = HR_GENERAL.GET_BUSINESS_GROUP_ID OR PET.LEGISLATION_CODE = HR_API.RETURN_LEGISLATION_CODE(HR_GENERAL.GET_BUSINESS_GROUP_ID) )) OR (HR_GENERAL.GET_BUSINESS_GROUP_ID IS NULL) ) WITH READ ONLY

Columns