Product: | PER - Human Resources |
---|---|
Description: | Contains data related to Oracle HR to Oracle Payroll Interface (H2PI) for assignments |
Implementation/DBA Data: | APPS.HR_H2PI_ASSIGNMENTS_V |
SELECT ASG.LAST_UPDATE_DATE
, ASG.BUSINESS_GROUP_ID
, ASG.ASSIGNMENT_ID
, ASG.PERSON_ID
, ASG.EFFECTIVE_START_DATE
, ASG.EFFECTIVE_END_DATE
, ASG.ASSIGNMENT_NUMBER
, ASG.PRIMARY_FLAG
, ASG.FREQUENCY
, ASG.NORMAL_HOURS
, ASG.TITLE
, ASG.PAY_BASIS_ID
, ASG.LOCATION_ID
, ASG.ORGANIZATION_ID
, ASG.PAYROLL_ID
, ASG.HOURLY_SALARIED_CODE
, SCK.SEGMENT1
, SCK.SEGMENT2
, SCK.SEGMENT3
, SCK.SEGMENT4
, SCK.SEGMENT5
, SCK.SEGMENT6
, SCK.SEGMENT7
, SCK.SEGMENT8
, SCK.SEGMENT9
, SCK.SEGMENT10
, SCK.SEGMENT11
, SCK.SEGMENT12
, SCK.SEGMENT13
, SCK.SEGMENT14
, SCK.SEGMENT15
, SCK.SEGMENT16
, SCK.SEGMENT17
, SCK.SEGMENT18
, SCK.SEGMENT19
, SCK.SEGMENT20
, SCK.SEGMENT21
, SCK.SEGMENT22
, SCK.SEGMENT23
, SCK.SEGMENT24
, SCK.SEGMENT25
, SCK.SEGMENT26
, SCK.SEGMENT27
, SCK.SEGMENT28
, SCK.SEGMENT29
, SCK.SEGMENT30
, ASG.TIME_NORMAL_FINISH
, ASG.TIME_NORMAL_START
, ASG.EMPLOYMENT_CATEGORY
, ASG.ASS_ATTRIBUTE_CATEGORY
, ASG.ASS_ATTRIBUTE1
, ASG.ASS_ATTRIBUTE2
, ASG.ASS_ATTRIBUTE3
, ASG.ASS_ATTRIBUTE4
, ASG.ASS_ATTRIBUTE5
, ASG.ASS_ATTRIBUTE6
, ASG.ASS_ATTRIBUTE7
, ASG.ASS_ATTRIBUTE8
, ASG.ASS_ATTRIBUTE9
, ASG.ASS_ATTRIBUTE10
, ASG.ASS_ATTRIBUTE11
, ASG.ASS_ATTRIBUTE12
, ASG.ASS_ATTRIBUTE13
, ASG.ASS_ATTRIBUTE14
, ASG.ASS_ATTRIBUTE15
, ASG.ASS_ATTRIBUTE16
, ASG.ASS_ATTRIBUTE17
, ASG.ASS_ATTRIBUTE18
, ASG.ASS_ATTRIBUTE19
, ASG.ASS_ATTRIBUTE20
, ASG.ASS_ATTRIBUTE21
, ASG.ASS_ATTRIBUTE22
, ASG.ASS_ATTRIBUTE23
, ASG.ASS_ATTRIBUTE24
, ASG.ASS_ATTRIBUTE25
, ASG.ASS_ATTRIBUTE26
, ASG.ASS_ATTRIBUTE27
, ASG.ASS_ATTRIBUTE28
, ASG.ASS_ATTRIBUTE29
, ASG.ASS_ATTRIBUTE30
FROM PER_ALL_ASSIGNMENTS_F ASG
, HR_SOFT_CODING_KEYFLEX SCK
WHERE ASG.ASSIGNMENT_TYPE = 'E'
AND SCK.SOFT_CODING_KEYFLEX_ID (+) = ASG.SOFT_CODING_KEYFLEX_ID