Product: | PAY - Payroll |
---|---|
Description: | Date-effective view. |
Implementation/DBA Data: | APPS.PAY_ELEMENT_ENTRIES_X |
SELECT ELEMENT_ENTRY_ID
, EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE
, COST_ALLOCATION_KEYFLEX_ID
, ASSIGNMENT_ID
, UPDATING_ACTION_ID
, ELEMENT_LINK_ID
, ORIGINAL_ENTRY_ID
, CREATOR_TYPE
, ENTRY_TYPE
, COMMENT_ID
, CREATOR_ID
, REASON
, TARGET_ENTRY_ID
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE16
, ATTRIBUTE17
, ATTRIBUTE18
, ATTRIBUTE19
, ATTRIBUTE20
, ENTRY_INFORMATION_CATEGORY
, ENTRY_INFORMATION1
, ENTRY_INFORMATION2
, ENTRY_INFORMATION3
, ENTRY_INFORMATION4
, ENTRY_INFORMATION5
, ENTRY_INFORMATION6
, ENTRY_INFORMATION7
, ENTRY_INFORMATION8
, ENTRY_INFORMATION9
, ENTRY_INFORMATION10
, ENTRY_INFORMATION11
, ENTRY_INFORMATION12
, ENTRY_INFORMATION13
, ENTRY_INFORMATION14
, ENTRY_INFORMATION15
, ENTRY_INFORMATION16
, ENTRY_INFORMATION17
, ENTRY_INFORMATION18
, ENTRY_INFORMATION19
, ENTRY_INFORMATION20
, ENTRY_INFORMATION21
, ENTRY_INFORMATION22
, ENTRY_INFORMATION23
, ENTRY_INFORMATION24
, ENTRY_INFORMATION25
, ENTRY_INFORMATION26
, ENTRY_INFORMATION27
, ENTRY_INFORMATION28
, ENTRY_INFORMATION29
, ENTRY_INFORMATION30
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, SUBPRIORITY
, PERSONAL_PAYMENT_METHOD_ID
, DATE_EARNED
, BALANCE_ADJ_COST_FLAG
, SOURCE_ASG_ACTION_ID
, SOURCE_LINK_ID
, SOURCE_PERIOD
, SOURCE_RUN_TYPE
, SOURCE_START_DATE
, SOURCE_END_DATE
, ELEMENT_TYPE_ID
FROM PAY_ELEMENT_ENTRIES_F
WHERE TRUNC(SYSDATE) BETWEEN EFFECTIVE_START_DATE
AND EFFECTIVE_END_DATE