VIEW: APPS.HR_H2PI_ELEMENT_ENTRIES_V

Source

View Text - Preformatted

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, ee.personal_payment_method_id 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')

View Text - HTML Formatted

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
, EE.PERSONAL_PAYMENT_METHOD_ID
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')