VIEW: APPS.PAY_ELEMENT_ENTRIES_X

Source

View Text - Preformatted

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

View Text - HTML Formatted

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