Product: | PER - Human Resources |
---|---|
Description: | Contains data related to Oracle HR to Oracle Payroll Interface (H2PI) for element entries |
Implementation/DBA Data: | APPS.HR_H2PI_ELEMENT_ENTRIES_V |
SELECT EE.LAST_UPDATE_DATE
, ASG.BUSINESS_GROUP_ID
, EE.ELEMENT_ENTRY_ID
, ASG.PERSON_ID
, EE.EFFECTIVE_START_DATE
, EE.EFFECTIVE_END_DATE
, EE.ASSIGNMENT_ID
, EE.ELEMENT_LINK_ID
, EE.CREATOR_TYPE
, EE.ENTRY_TYPE
, EE.DATE_EARNED
, EE.ATTRIBUTE_CATEGORY
, EE.ATTRIBUTE1
, EE.ATTRIBUTE2
, EE.ATTRIBUTE3
, EE.ATTRIBUTE4
, EE.ATTRIBUTE5
, EE.ATTRIBUTE6
, EE.ATTRIBUTE7
, EE.ATTRIBUTE8
, EE.ATTRIBUTE9
, EE.ATTRIBUTE10
, EE.ATTRIBUTE11
, EE.ATTRIBUTE12
, EE.ATTRIBUTE13
, EE.ATTRIBUTE14
, EE.ATTRIBUTE15
, EE.ATTRIBUTE16
, EE.ATTRIBUTE17
, EE.ATTRIBUTE18
, EE.ATTRIBUTE19
, EE.ATTRIBUTE20
, CAK.CONCATENATED_SEGMENTS
, CAK.ID_FLEX_NUM
, CAK.SUMMARY_FLAG
, CAK.ENABLED_FLAG
, CAK.START_DATE_ACTIVE
, CAK.END_DATE_ACTIVE
, CAK.SEGMENT1
, CAK.SEGMENT2
, CAK.SEGMENT3
, CAK.SEGMENT4
, CAK.SEGMENT5
, CAK.SEGMENT6
, CAK.SEGMENT7
, CAK.SEGMENT8
, CAK.SEGMENT9
, CAK.SEGMENT10
, CAK.SEGMENT11
, CAK.SEGMENT12
, CAK.SEGMENT13
, CAK.SEGMENT14
, CAK.SEGMENT15
, CAK.SEGMENT16
, CAK.SEGMENT17
, CAK.SEGMENT18
, CAK.SEGMENT19
, CAK.SEGMENT20
, CAK.SEGMENT21
, CAK.SEGMENT22
, CAK.SEGMENT23
, CAK.SEGMENT24
, CAK.SEGMENT25
, CAK.SEGMENT26
, CAK.SEGMENT27
, CAK.SEGMENT28
, CAK.SEGMENT29
, CAK.SEGMENT30
FROM PAY_ELEMENT_ENTRIES_F EE
, PAY_COST_ALLOCATION_KEYFLEX CAK
, HR_H2PI_ASSIGNMENTS_V ASG
WHERE EE.ASSIGNMENT_ID = ASG.ASSIGNMENT_ID
AND EE.EFFECTIVE_START_DATE BETWEEN ASG.EFFECTIVE_START_DATE
AND ASG.EFFECTIVE_END_DATE
AND EE.COST_ALLOCATION_KEYFLEX_ID = CAK.COST_ALLOCATION_KEYFLEX_ID(+)
AND EE.CREATOR_TYPE IN ( 'A'
, 'B'
, 'F'
, 'H'
, 'UT')