VIEW: APPS.HR_H2PI_ASSIGNMENTS_V

Source

View Text - Preformatted

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, ppg.segment1, ppg.segment2, ppg.segment3, ppg.segment4 , ppg.segment5, ppg.segment6, ppg.segment7, ppg.segment8, ppg.segment9, ppg.segment10, ppg.segment11, ppg.segment12, ppg.segment13, ppg.segment14, ppg.segment15, ppg.segment16, ppg.segment17, ppg.segment18, ppg.segment19, ppg.segment20, ppg.segment21, ppg.segment22, ppg.segment23, ppg.segment24, ppg.segment25, ppg.segment26, ppg.segment27, ppg.segment28, ppg.segment29, ppg.segment30 from per_all_assignments_f asg , hr_soft_coding_keyflex sck , pay_people_groups ppg, per_assignment_status_types ast WHERE asg.assignment_type = 'E' and ast.assignment_status_type_id = asg.assignment_status_type_id and ast.per_system_status = 'ACTIVE_ASSIGN' and sck.soft_coding_keyflex_id (+) = asg.soft_coding_keyflex_id and ppg.people_group_id (+) = asg.people_group_id

View Text - HTML Formatted

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
, PPG.SEGMENT1
, PPG.SEGMENT2
, PPG.SEGMENT3
, PPG.SEGMENT4
, PPG.SEGMENT5
, PPG.SEGMENT6
, PPG.SEGMENT7
, PPG.SEGMENT8
, PPG.SEGMENT9
, PPG.SEGMENT10
, PPG.SEGMENT11
, PPG.SEGMENT12
, PPG.SEGMENT13
, PPG.SEGMENT14
, PPG.SEGMENT15
, PPG.SEGMENT16
, PPG.SEGMENT17
, PPG.SEGMENT18
, PPG.SEGMENT19
, PPG.SEGMENT20
, PPG.SEGMENT21
, PPG.SEGMENT22
, PPG.SEGMENT23
, PPG.SEGMENT24
, PPG.SEGMENT25
, PPG.SEGMENT26
, PPG.SEGMENT27
, PPG.SEGMENT28
, PPG.SEGMENT29
, PPG.SEGMENT30
FROM PER_ALL_ASSIGNMENTS_F ASG
, HR_SOFT_CODING_KEYFLEX SCK
, PAY_PEOPLE_GROUPS PPG
, PER_ASSIGNMENT_STATUS_TYPES AST
WHERE ASG.ASSIGNMENT_TYPE = 'E'
AND AST.ASSIGNMENT_STATUS_TYPE_ID = ASG.ASSIGNMENT_STATUS_TYPE_ID
AND AST.PER_SYSTEM_STATUS = 'ACTIVE_ASSIGN'
AND SCK.SOFT_CODING_KEYFLEX_ID (+) = ASG.SOFT_CODING_KEYFLEX_ID
AND PPG.PEOPLE_GROUP_ID (+) = ASG.PEOPLE_GROUP_ID