APPS.PAYBV_ELEMENT_ENTRY
[Home] [Help]
| Product: | PAY - Payroll |
|---|---|
| Description: | |
| Implementation/DBA Data: |
APPS.PAYBV_ELEMENT_ENTRY
|
SELECT ELE.EFFECTIVE_START_DATE
, ELE.EFFECTIVE_END_DATE
, HR_BIS.BIS_DECODE_LOOKUP('CREATOR_TYPE'
, ELE.CREATOR_TYPE) CREATOR_TYPE
, HR_BIS.BIS_DECODE_LOOKUP('ENTRY_TYPE'
, ELE.ENTRY_TYPE) ENTRY_TYPE
, HR_BIS.BIS_DECODE_LOOKUP('ELE_ENTRY_REASON'
, ELE.REASON) REASON
, ELE.SUBPRIORITY
, ELE.DATE_EARNED
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, ELE.BALANCE_ADJ_COST_FLAG) BALANCE_ADJ_COST_FLAG
, ELE.SOURCE_TRIGGER_ENTRY
, ELE.SOURCE_PERIOD
, ELE.SOURCE_RUN_TYPE
, HR_BIS.BIS_DECODE_LOOKUP('ACTION_TYPE'
, ELE.UPDATING_ACTION_TYPE) UPDATING_ACTION_TYPE
, ELE.SOURCE_START_DATE
, ELE.SOURCE_END_DATE
, '_DF:PAY:PAY_ELEMENT_ENTRIES:ELE'
, ELE.ATTRIBUTE_CATEGORY
, ELE.ATTRIBUTE1
, ELE.ATTRIBUTE2
, ELE.ATTRIBUTE3
, ELE.ATTRIBUTE4
, ELE.ATTRIBUTE5
, ELE.ATTRIBUTE6
, ELE.ATTRIBUTE7
, ELE.ATTRIBUTE8
, ELE.ATTRIBUTE9
, ELE.ATTRIBUTE10
, ELE.ATTRIBUTE11
, ELE.ATTRIBUTE12
, ELE.ATTRIBUTE13
, ELE.ATTRIBUTE14
, ELE.ATTRIBUTE15
, ELE.ATTRIBUTE16
, ELE.ATTRIBUTE17
, ELE.ATTRIBUTE18
, ELE.ATTRIBUTE19
, ELE.ATTRIBUTE20
, ELE.ENTRY_INFORMATION_CATEGORY
, ELE.ENTRY_INFORMATION1
, ELE.ENTRY_INFORMATION2
, ELE.ENTRY_INFORMATION3
, ELE.ENTRY_INFORMATION4
, ELE.ENTRY_INFORMATION5
, ELE.ENTRY_INFORMATION6
, ELE.ENTRY_INFORMATION7
, ELE.ENTRY_INFORMATION8
, ELE.ENTRY_INFORMATION9
, ELE.ENTRY_INFORMATION10
, ELE.ENTRY_INFORMATION11
, ELE.ENTRY_INFORMATION12
, ELE.ENTRY_INFORMATION13
, ELE.ENTRY_INFORMATION14
, ELE.ENTRY_INFORMATION15
, ELE.ENTRY_INFORMATION16
, ELE.ENTRY_INFORMATION17
, ELE.ENTRY_INFORMATION18
, ELE.ENTRY_INFORMATION19
, ELE.ENTRY_INFORMATION20
, ELE.ENTRY_INFORMATION21
, ELE.ENTRY_INFORMATION22
, ELE.ENTRY_INFORMATION23
, ELE.ENTRY_INFORMATION24
, ELE.ENTRY_INFORMATION25
, ELE.ENTRY_INFORMATION26
, ELE.ENTRY_INFORMATION27
, ELE.ENTRY_INFORMATION28
, ELE.ENTRY_INFORMATION29
, ELE.ENTRY_INFORMATION30
, ELE.OBJECT_VERSION_NUMBER
, ELE.CREATOR_TYPE CREATOR_TYPE_CODE
, ELE.ENTRY_TYPE ENTRY_TYPE_CODE
, ELE.REASON REASON_CODE
, ELE.BALANCE_ADJ_COST_FLAG BALANCE_ADJ_COST_FLAG_CODE
, ELE.UPDATING_ACTION_TYPE UPDATING_ACTION_TYPE_CODE
, ELE.ELEMENT_ENTRY_ID
, ELE.COST_ALLOCATION_KEYFLEX_ID
, ELE.ASSIGNMENT_ID
, ELE.UPDATING_ACTION_ID
, ELE.ELEMENT_LINK_ID
, ELE.ORIGINAL_ENTRY_ID
, ELE.COMMENT_ID
, ELE.CREATOR_ID
, ELE.TARGET_ENTRY_ID
, ELE.PERSONAL_PAYMENT_METHOD_ID
, ELE.SOURCE_ID
, ELE.SOURCE_ASG_ACTION_ID
, ELE.SOURCE_LINK_ID
, ELE.ELEMENT_TYPE_ID
, ELE.LAST_UPDATE_DATE
, ELE.LAST_UPDATED_BY
, ELE.LAST_UPDATE_LOGIN
, ELE.CREATED_BY
, ELE.CREATION_DATE
FROM PAY_ELEMENT_ENTRIES_F ELE WITH READ ONLY