Product: | PER - Human Resources |
---|---|
Description: | Contains data related to Oracle HR to Oracle Payroll Interface (H2PI) for cost allocations |
Implementation/DBA Data: | APPS.HR_H2PI_COST_ALLOCATIONS_V |
SELECT COA.LAST_UPDATE_DATE
, COA.BUSINESS_GROUP_ID
, COA.COST_ALLOCATION_ID
, ASG.PERSON_ID
, COA.EFFECTIVE_START_DATE
, COA.EFFECTIVE_END_DATE
, COA.ASSIGNMENT_ID
, COA.PROPORTION
, 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_COST_ALLOCATIONS_F COA
, PAY_COST_ALLOCATION_KEYFLEX CAK
, HR_H2PI_ASSIGNMENTS_V ASG
WHERE COA.COST_ALLOCATION_KEYFLEX_ID = CAK.COST_ALLOCATION_KEYFLEX_ID
AND ASG.ASSIGNMENT_ID = COA.ASSIGNMENT_ID
AND COA.EFFECTIVE_START_DATE BETWEEN ASG.EFFECTIVE_START_DATE
AND ASG.EFFECTIVE_END_DATE