VIEW: APPS.HXC_RESOURCE_INFORMATION_V

Source

View Text - Preformatted

SELECT pap.person_id Resource_ID, pap.full_name Resource_Display_Name, pap.employee_number Resource_Number, pap.national_identifier National_Identifier, decode(pap.current_employee_flag,'Y',pps.date_start,NULL) Hire_Date, pj.name Job_Title, hou.name Organization_Name, pap2.full_name Supervisor_Name, pap2.employee_number Supervisor_Number, pap.per_information_category Per_Information_Category, pap.per_information1 Per_Information1, pap.per_information2 Per_Information2, pap.per_information3 Per_Information3, pap.per_information4 Per_Information4, pap.per_information5 Per_Information5, pap.per_information6 Per_Information6, pap.per_information7 Per_Information7, pap.per_information8 Per_Information8, pap.per_information9 Per_Information9, pap.per_information10 Per_Information10, pap.per_information11 Per_Information11, pap.per_information12 Per_Information12, pap.per_information13 Per_Information13, pap.per_information14 Per_Information14, pap.per_information15 Per_Information15, pap.per_information16 Per_Information16, pap.per_information17 Per_Information17, pap.per_information18 Per_Information18, pap.per_information19 Per_Information19, pap.per_information20 Per_Information20, pap.per_information21 Per_Information21, pap.per_information22 Per_Information22, pap.per_information23 Per_Information23, pap.per_information24 Per_Information24, pap.per_information25 Per_Information25, pap.per_information26 Per_Information26, pap.per_information27 Per_Information27, pap.per_information28 Per_Information28, pap.per_information29 Per_Information29, pap.per_information30 Per_Information30, pap.office_number Office_Number, pap.internal_location Internal_Location, pap.mailstop Mailstop, hl1.meaning Availability_Schedule, pap.fte_capacity Fulltime_Availabilty, pap.attribute_category Attribute_Category, pap.attribute1 Attribute1, pap.attribute2 Attribute2, pap.attribute3 Attribute3, pap.attribute4 Attribute4, pap.attribute5 Attribute5, pap.attribute6 Attribute6, pap.attribute7 Attribute7, pap.attribute8 Attribute8, pap.attribute9 Attribute9, pap.attribute10 Attribute10, pap.attribute11 Attribute11, pap.attribute12 Attribute12, pap.attribute13 Attribute13, pap.attribute14 Attribute14, pap.attribute15 Attribute15, pap.attribute16 Attribute16, pap.attribute17 Attribute17, pap.attribute18 Attribute18, pap.attribute19 Attribute19, pap.attribute20 Attribute20, pap.attribute21 Attribute21, pap.attribute22 Attribute22, pap.attribute23 Attribute23, pap.attribute24 Attribute24, pap.attribute25 Attribute25, pap.attribute26 Attribute26, pap.attribute27 Attribute27, pap.attribute28 Attribute28, pap.attribute29 Attribute29, pap.attribute30 Attribute30, pgr.name Grade_Name, hrl.location_code Assignment_Location, ppg.group_name Assignment_People_Group, pp.name Assignment_Position, ppay.payroll_name Assignment_Payroll, past.user_status Assignment_Status, paa.assignment_number Assignment_Number, paa.employment_category Assignment_Category, paa.normal_hours Normal_Hours, hl2.meaning Normal_Hours_Frequency, paa.time_normal_start Normal_Start_Time, paa.time_normal_finish Normal_Finish_Time, hsck.segment1 Soft_Coded_Keyflex1, hsck.segment2 Soft_Coded_Keyflex2, hsck.segment3 Soft_Coded_Keyflex3, hsck.segment4 Soft_Coded_Keyflex4, hsck.segment5 Soft_Coded_Keyflex5, hsck.segment6 Soft_Coded_Keyflex6, hsck.segment7 Soft_Coded_Keyflex7, hsck.segment8 Soft_Coded_Keyflex8, hsck.segment9 Soft_Coded_Keyflex9, hsck.segment10 Soft_Coded_Keyflex10, hsck.segment11 Soft_Coded_Keyflex11, hsck.segment12 Soft_Coded_Keyflex12, hsck.segment13 Soft_Coded_Keyflex13, hsck.segment14 Soft_Coded_Keyflex14, hsck.segment15 Soft_Coded_Keyflex15, hsck.segment16 Soft_Coded_Keyflex16, hsck.segment17 Soft_Coded_Keyflex17, hsck.segment18 Soft_Coded_Keyflex18, hsck.segment19 Soft_Coded_Keyflex19, hsck.segment20 Soft_Coded_Keyflex20, hsck.segment21 Soft_Coded_Keyflex21, hsck.segment22 Soft_Coded_Keyflex22, hsck.segment23 Soft_Coded_Keyflex23, hsck.segment24 Soft_Coded_Keyflex24, hsck.segment25 Soft_Coded_Keyflex25, hsck.segment26 Soft_Coded_Keyflex26, hsck.segment27 Soft_Coded_Keyflex27, hsck.segment28 Soft_Coded_Keyflex28, hsck.segment29 Soft_Coded_Keyflex29, hsck.segment30 Soft_Coded_Keyflex30, paa.bargaining_unit_code Bargining_Unit_Code, ppb.name Salary_Basis, pca.name Collective_Agreement, cgd.segment1 Agreement_Grade1, cgd.segment2 Agreement_Grade2, cgd.segment3 Agreement_Grade3, cgd.segment4 Agreement_Grade4, cgd.segment5 Agreement_Grade5, cgd.segment6 Agreement_Grade6, cgd.segment7 Agreement_Grade7, cgd.segment8 Agreement_Grade8, cgd.segment9 Agreement_Grade9, cgd.segment10 Agreement_Grade10, cgd.segment11 Agreement_Grade11, cgd.segment12 Agreement_Grade12, cgd.segment13 Agreement_Grade13, cgd.segment14 Agreement_Grade14, cgd.segment15 Agreement_Grade15, cgd.segment16 Agreement_Grade16, cgd.segment17 Agreement_Grade17, cgd.segment18 Agreement_Grade18, cgd.segment19 Agreement_Grade19, cgd.segment20 Agreement_Grade20, cost.segment1 Cost_Allocation1, cost.segment2 Cost_Allocation2, cost.segment3 Cost_Allocation3, cost.segment4 Cost_Allocation4, cost.segment5 Cost_Allocation5, cost.segment6 Cost_Allocation6, cost.segment7 Cost_Allocation7, cost.segment8 Cost_Allocation8, cost.segment9 Cost_Allocation9, cost.segment10 Cost_Allocation10, cost.segment11 Cost_Allocation11, cost.segment12 Cost_Allocation12, cost.segment13 Cost_Allocation13, cost.segment14 Cost_Allocation14, cost.segment15 Cost_Allocation15, cost.segment16 Cost_Allocation16, cost.segment17 Cost_Allocation17, cost.segment18 Cost_Allocation18, cost.segment19 Cost_Allocation19, cost.segment20 Cost_Allocation20, cost.segment21 Cost_Allocation21, cost.segment22 Cost_Allocation22, cost.segment23 Cost_Allocation23, cost.segment24 Cost_Allocation24, cost.segment25 Cost_Allocation25, cost.segment26 Cost_Allocation26, cost.segment27 Cost_Allocation27, cost.segment28 Cost_Allocation28, cost.segment29 Cost_Allocation29, cost.segment30 Cost_Allocation30, pj.attribute1 Job_Dff_Attribute1, pj.attribute2 Job_Dff_Attribute2, pj.attribute3 Job_Dff_Attribute3, pj.attribute4 Job_Dff_Attribute4, pj.attribute5 Job_Dff_Attribute5, pj.attribute6 Job_Dff_Attribute6, pj.attribute7 Job_Dff_Attribute7, pj.attribute8 Job_Dff_Attribute8, pj.attribute9 Job_Dff_Attribute9, pj.attribute10 Job_Dff_Attribute10, pj.attribute11 Job_Dff_Attribute11, pj.attribute12 Job_Dff_Attribute12, pj.attribute13 Job_Dff_Attribute13, pj.attribute14 Job_Dff_Attribute14, pj.attribute15 Job_Dff_Attribute15, pj.attribute16 Job_Dff_Attribute16, pj.attribute17 Job_Dff_Attribute17, pj.attribute18 Job_Dff_Attribute18, pj.attribute19 Job_Dff_Attribute19, pj.attribute20 Job_Dff_Attribute20, pp.attribute1 Position_Dff_Attribute1, pp.attribute2 Position_Dff_Attribute2, pp.attribute3 Position_Dff_Attribute3, pp.attribute4 Position_Dff_Attribute4, pp.attribute5 Position_Dff_Attribute5, pp.attribute6 Position_Dff_Attribute6, pp.attribute7 Position_Dff_Attribute7, pp.attribute8 Position_Dff_Attribute8, pp.attribute9 Position_Dff_Attribute9, pp.attribute10 Position_Dff_Attribute10, pp.attribute11 Position_Dff_Attribute11, pp.attribute12 Position_Dff_Attribute12, pp.attribute13 Position_Dff_Attribute13, pp.attribute14 Position_Dff_Attribute14, pp.attribute15 Position_Dff_Attribute15, pp.attribute16 Position_Dff_Attribute16, pp.attribute17 Position_Dff_Attribute17, pp.attribute18 Position_Dff_Attribute18, pp.attribute19 Position_Dff_Attribute19, pp.attribute20 Position_Dff_Attribute20, paa.ass_attribute1 Assignment_Attribute1, paa.ass_attribute2 Assignment_Attribute2, paa.ass_attribute3 Assignment_Attribute3, paa.ass_attribute4 Assignment_Attribute4, paa.ass_attribute5 Assignment_Attribute5, paa.ass_attribute6 Assignment_Attribute6, paa.ass_attribute7 Assignment_Attribute7, paa.ass_attribute8 Assignment_Attribute8, paa.ass_attribute9 Assignment_Attribute9, paa.ass_attribute10 Assignment_Attribute10, paa.ass_attribute11 Assignment_Attribute11, paa.ass_attribute12 Assignment_Attribute12, paa.ass_attribute13 Assignment_Attribute13, paa.ass_attribute14 Assignment_Attribute14, paa.ass_attribute15 Assignment_Attribute15, paa.ass_attribute16 Assignment_Attribute16, paa.ass_attribute17 Assignment_Attribute17, paa.ass_attribute18 Assignment_Attribute18, paa.ass_attribute19 Assignment_Attribute19, paa.ass_attribute20 Assignment_Attribute20, paa.ass_attribute21 Assignment_Attribute21, paa.ass_attribute22 Assignment_Attribute22, paa.ass_attribute23 Assignment_Attribute23, paa.ass_attribute24 Assignment_Attribute24, paa.ass_attribute25 Assignment_Attribute25, paa.ass_attribute26 Assignment_Attribute26, paa.ass_attribute27 Assignment_Attribute27, paa.ass_attribute28 Assignment_Attribute28, paa.ass_attribute29 Assignment_Attribute29, paa.ass_attribute30 Assignment_Attribute30, ptp.start_date Payroll_Period_Start_Date, ptp.end_date Payroll_Period_End_Date from hr_lookups hl1, hr_lookups hl2, per_grades pgr, pay_people_groups ppg, per_collective_agreements pca, per_cagr_grades_def cgd, per_time_periods ptp, per_positions pp, pay_payrolls ppay, per_pay_bases ppb, pay_cost_allocations_f pcst, pay_cost_allocation_keyflex cost, per_assignment_status_types_v past, hr_locations hrl, hr_soft_coding_keyflex hsck, per_jobs pj, hr_organization_units hou, per_periods_of_service pps, per_people_f pap2, per_people_f pap, per_assignments_f paa WHERE pap.person_id = paa.person_id and pap.business_group_id = paa.business_group_id and sysdate between pap.effective_start_date and pap.effective_end_date and sysdate between paa.effective_start_date and paa.effective_end_date and paa.organization_id = hou.organization_id and paa.supervisor_id = pap2.person_id (+) and pap2.business_group_id (+) = paa.business_group_id and pps.person_id = pap.person_id and paa.job_id = pj.job_id (+) and hl1.lookup_type(+) = 'WORK_SCHEDULE' and hl1.lookup_code(+) = pap.work_schedule and hl2.lookup_type(+) = 'FREQUENCY' and hl2.lookup_code(+) = paa.frequency and pgr.grade_id(+) = paa.grade_id and hrl.location_id (+) = paa.location_id and ppg.people_group_id (+) = paa.people_group_id and pp.position_id (+) = paa.position_id and ppay.payroll_id (+) = paa.payroll_id and past.assignment_status_type_id = paa.assignment_status_type_id and hsck.soft_coding_keyflex_id (+) = paa.soft_coding_keyflex_id and ppb.pay_basis_id (+) = paa.pay_basis_id and pca.collective_agreement_id (+) = paa.collective_agreement_id and cgd.cagr_grade_def_id (+)= paa.cagr_grade_def_id and pcst.assignment_id (+) = paa.assignment_id and pcst.cost_allocation_keyflex_id = cost.cost_allocation_keyflex_id (+) and pcst.effective_start_date (+) between paa.effective_start_date and paa.effective_end_date and ptp.payroll_id (+) = paa.payroll_id and sysdate between ptp.start_date and ptp.end_date

View Text - HTML Formatted

SELECT PAP.PERSON_ID RESOURCE_ID
, PAP.FULL_NAME RESOURCE_DISPLAY_NAME
, PAP.EMPLOYEE_NUMBER RESOURCE_NUMBER
, PAP.NATIONAL_IDENTIFIER NATIONAL_IDENTIFIER
, DECODE(PAP.CURRENT_EMPLOYEE_FLAG
, 'Y'
, PPS.DATE_START
, NULL) HIRE_DATE
, PJ.NAME JOB_TITLE
, HOU.NAME ORGANIZATION_NAME
, PAP2.FULL_NAME SUPERVISOR_NAME
, PAP2.EMPLOYEE_NUMBER SUPERVISOR_NUMBER
, PAP.PER_INFORMATION_CATEGORY PER_INFORMATION_CATEGORY
, PAP.PER_INFORMATION1 PER_INFORMATION1
, PAP.PER_INFORMATION2 PER_INFORMATION2
, PAP.PER_INFORMATION3 PER_INFORMATION3
, PAP.PER_INFORMATION4 PER_INFORMATION4
, PAP.PER_INFORMATION5 PER_INFORMATION5
, PAP.PER_INFORMATION6 PER_INFORMATION6
, PAP.PER_INFORMATION7 PER_INFORMATION7
, PAP.PER_INFORMATION8 PER_INFORMATION8
, PAP.PER_INFORMATION9 PER_INFORMATION9
, PAP.PER_INFORMATION10 PER_INFORMATION10
, PAP.PER_INFORMATION11 PER_INFORMATION11
, PAP.PER_INFORMATION12 PER_INFORMATION12
, PAP.PER_INFORMATION13 PER_INFORMATION13
, PAP.PER_INFORMATION14 PER_INFORMATION14
, PAP.PER_INFORMATION15 PER_INFORMATION15
, PAP.PER_INFORMATION16 PER_INFORMATION16
, PAP.PER_INFORMATION17 PER_INFORMATION17
, PAP.PER_INFORMATION18 PER_INFORMATION18
, PAP.PER_INFORMATION19 PER_INFORMATION19
, PAP.PER_INFORMATION20 PER_INFORMATION20
, PAP.PER_INFORMATION21 PER_INFORMATION21
, PAP.PER_INFORMATION22 PER_INFORMATION22
, PAP.PER_INFORMATION23 PER_INFORMATION23
, PAP.PER_INFORMATION24 PER_INFORMATION24
, PAP.PER_INFORMATION25 PER_INFORMATION25
, PAP.PER_INFORMATION26 PER_INFORMATION26
, PAP.PER_INFORMATION27 PER_INFORMATION27
, PAP.PER_INFORMATION28 PER_INFORMATION28
, PAP.PER_INFORMATION29 PER_INFORMATION29
, PAP.PER_INFORMATION30 PER_INFORMATION30
, PAP.OFFICE_NUMBER OFFICE_NUMBER
, PAP.INTERNAL_LOCATION INTERNAL_LOCATION
, PAP.MAILSTOP MAILSTOP
, HL1.MEANING AVAILABILITY_SCHEDULE
, PAP.FTE_CAPACITY FULLTIME_AVAILABILTY
, PAP.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, PAP.ATTRIBUTE1 ATTRIBUTE1
, PAP.ATTRIBUTE2 ATTRIBUTE2
, PAP.ATTRIBUTE3 ATTRIBUTE3
, PAP.ATTRIBUTE4 ATTRIBUTE4
, PAP.ATTRIBUTE5 ATTRIBUTE5
, PAP.ATTRIBUTE6 ATTRIBUTE6
, PAP.ATTRIBUTE7 ATTRIBUTE7
, PAP.ATTRIBUTE8 ATTRIBUTE8
, PAP.ATTRIBUTE9 ATTRIBUTE9
, PAP.ATTRIBUTE10 ATTRIBUTE10
, PAP.ATTRIBUTE11 ATTRIBUTE11
, PAP.ATTRIBUTE12 ATTRIBUTE12
, PAP.ATTRIBUTE13 ATTRIBUTE13
, PAP.ATTRIBUTE14 ATTRIBUTE14
, PAP.ATTRIBUTE15 ATTRIBUTE15
, PAP.ATTRIBUTE16 ATTRIBUTE16
, PAP.ATTRIBUTE17 ATTRIBUTE17
, PAP.ATTRIBUTE18 ATTRIBUTE18
, PAP.ATTRIBUTE19 ATTRIBUTE19
, PAP.ATTRIBUTE20 ATTRIBUTE20
, PAP.ATTRIBUTE21 ATTRIBUTE21
, PAP.ATTRIBUTE22 ATTRIBUTE22
, PAP.ATTRIBUTE23 ATTRIBUTE23
, PAP.ATTRIBUTE24 ATTRIBUTE24
, PAP.ATTRIBUTE25 ATTRIBUTE25
, PAP.ATTRIBUTE26 ATTRIBUTE26
, PAP.ATTRIBUTE27 ATTRIBUTE27
, PAP.ATTRIBUTE28 ATTRIBUTE28
, PAP.ATTRIBUTE29 ATTRIBUTE29
, PAP.ATTRIBUTE30 ATTRIBUTE30
, PGR.NAME GRADE_NAME
, HRL.LOCATION_CODE ASSIGNMENT_LOCATION
, PPG.GROUP_NAME ASSIGNMENT_PEOPLE_GROUP
, PP.NAME ASSIGNMENT_POSITION
, PPAY.PAYROLL_NAME ASSIGNMENT_PAYROLL
, PAST.USER_STATUS ASSIGNMENT_STATUS
, PAA.ASSIGNMENT_NUMBER ASSIGNMENT_NUMBER
, PAA.EMPLOYMENT_CATEGORY ASSIGNMENT_CATEGORY
, PAA.NORMAL_HOURS NORMAL_HOURS
, HL2.MEANING NORMAL_HOURS_FREQUENCY
, PAA.TIME_NORMAL_START NORMAL_START_TIME
, PAA.TIME_NORMAL_FINISH NORMAL_FINISH_TIME
, HSCK.SEGMENT1 SOFT_CODED_KEYFLEX1
, HSCK.SEGMENT2 SOFT_CODED_KEYFLEX2
, HSCK.SEGMENT3 SOFT_CODED_KEYFLEX3
, HSCK.SEGMENT4 SOFT_CODED_KEYFLEX4
, HSCK.SEGMENT5 SOFT_CODED_KEYFLEX5
, HSCK.SEGMENT6 SOFT_CODED_KEYFLEX6
, HSCK.SEGMENT7 SOFT_CODED_KEYFLEX7
, HSCK.SEGMENT8 SOFT_CODED_KEYFLEX8
, HSCK.SEGMENT9 SOFT_CODED_KEYFLEX9
, HSCK.SEGMENT10 SOFT_CODED_KEYFLEX10
, HSCK.SEGMENT11 SOFT_CODED_KEYFLEX11
, HSCK.SEGMENT12 SOFT_CODED_KEYFLEX12
, HSCK.SEGMENT13 SOFT_CODED_KEYFLEX13
, HSCK.SEGMENT14 SOFT_CODED_KEYFLEX14
, HSCK.SEGMENT15 SOFT_CODED_KEYFLEX15
, HSCK.SEGMENT16 SOFT_CODED_KEYFLEX16
, HSCK.SEGMENT17 SOFT_CODED_KEYFLEX17
, HSCK.SEGMENT18 SOFT_CODED_KEYFLEX18
, HSCK.SEGMENT19 SOFT_CODED_KEYFLEX19
, HSCK.SEGMENT20 SOFT_CODED_KEYFLEX20
, HSCK.SEGMENT21 SOFT_CODED_KEYFLEX21
, HSCK.SEGMENT22 SOFT_CODED_KEYFLEX22
, HSCK.SEGMENT23 SOFT_CODED_KEYFLEX23
, HSCK.SEGMENT24 SOFT_CODED_KEYFLEX24
, HSCK.SEGMENT25 SOFT_CODED_KEYFLEX25
, HSCK.SEGMENT26 SOFT_CODED_KEYFLEX26
, HSCK.SEGMENT27 SOFT_CODED_KEYFLEX27
, HSCK.SEGMENT28 SOFT_CODED_KEYFLEX28
, HSCK.SEGMENT29 SOFT_CODED_KEYFLEX29
, HSCK.SEGMENT30 SOFT_CODED_KEYFLEX30
, PAA.BARGAINING_UNIT_CODE BARGINING_UNIT_CODE
, PPB.NAME SALARY_BASIS
, PCA.NAME COLLECTIVE_AGREEMENT
, CGD.SEGMENT1 AGREEMENT_GRADE1
, CGD.SEGMENT2 AGREEMENT_GRADE2
, CGD.SEGMENT3 AGREEMENT_GRADE3
, CGD.SEGMENT4 AGREEMENT_GRADE4
, CGD.SEGMENT5 AGREEMENT_GRADE5
, CGD.SEGMENT6 AGREEMENT_GRADE6
, CGD.SEGMENT7 AGREEMENT_GRADE7
, CGD.SEGMENT8 AGREEMENT_GRADE8
, CGD.SEGMENT9 AGREEMENT_GRADE9
, CGD.SEGMENT10 AGREEMENT_GRADE10
, CGD.SEGMENT11 AGREEMENT_GRADE11
, CGD.SEGMENT12 AGREEMENT_GRADE12
, CGD.SEGMENT13 AGREEMENT_GRADE13
, CGD.SEGMENT14 AGREEMENT_GRADE14
, CGD.SEGMENT15 AGREEMENT_GRADE15
, CGD.SEGMENT16 AGREEMENT_GRADE16
, CGD.SEGMENT17 AGREEMENT_GRADE17
, CGD.SEGMENT18 AGREEMENT_GRADE18
, CGD.SEGMENT19 AGREEMENT_GRADE19
, CGD.SEGMENT20 AGREEMENT_GRADE20
, COST.SEGMENT1 COST_ALLOCATION1
, COST.SEGMENT2 COST_ALLOCATION2
, COST.SEGMENT3 COST_ALLOCATION3
, COST.SEGMENT4 COST_ALLOCATION4
, COST.SEGMENT5 COST_ALLOCATION5
, COST.SEGMENT6 COST_ALLOCATION6
, COST.SEGMENT7 COST_ALLOCATION7
, COST.SEGMENT8 COST_ALLOCATION8
, COST.SEGMENT9 COST_ALLOCATION9
, COST.SEGMENT10 COST_ALLOCATION10
, COST.SEGMENT11 COST_ALLOCATION11
, COST.SEGMENT12 COST_ALLOCATION12
, COST.SEGMENT13 COST_ALLOCATION13
, COST.SEGMENT14 COST_ALLOCATION14
, COST.SEGMENT15 COST_ALLOCATION15
, COST.SEGMENT16 COST_ALLOCATION16
, COST.SEGMENT17 COST_ALLOCATION17
, COST.SEGMENT18 COST_ALLOCATION18
, COST.SEGMENT19 COST_ALLOCATION19
, COST.SEGMENT20 COST_ALLOCATION20
, COST.SEGMENT21 COST_ALLOCATION21
, COST.SEGMENT22 COST_ALLOCATION22
, COST.SEGMENT23 COST_ALLOCATION23
, COST.SEGMENT24 COST_ALLOCATION24
, COST.SEGMENT25 COST_ALLOCATION25
, COST.SEGMENT26 COST_ALLOCATION26
, COST.SEGMENT27 COST_ALLOCATION27
, COST.SEGMENT28 COST_ALLOCATION28
, COST.SEGMENT29 COST_ALLOCATION29
, COST.SEGMENT30 COST_ALLOCATION30
, PJ.ATTRIBUTE1 JOB_DFF_ATTRIBUTE1
, PJ.ATTRIBUTE2 JOB_DFF_ATTRIBUTE2
, PJ.ATTRIBUTE3 JOB_DFF_ATTRIBUTE3
, PJ.ATTRIBUTE4 JOB_DFF_ATTRIBUTE4
, PJ.ATTRIBUTE5 JOB_DFF_ATTRIBUTE5
, PJ.ATTRIBUTE6 JOB_DFF_ATTRIBUTE6
, PJ.ATTRIBUTE7 JOB_DFF_ATTRIBUTE7
, PJ.ATTRIBUTE8 JOB_DFF_ATTRIBUTE8
, PJ.ATTRIBUTE9 JOB_DFF_ATTRIBUTE9
, PJ.ATTRIBUTE10 JOB_DFF_ATTRIBUTE10
, PJ.ATTRIBUTE11 JOB_DFF_ATTRIBUTE11
, PJ.ATTRIBUTE12 JOB_DFF_ATTRIBUTE12
, PJ.ATTRIBUTE13 JOB_DFF_ATTRIBUTE13
, PJ.ATTRIBUTE14 JOB_DFF_ATTRIBUTE14
, PJ.ATTRIBUTE15 JOB_DFF_ATTRIBUTE15
, PJ.ATTRIBUTE16 JOB_DFF_ATTRIBUTE16
, PJ.ATTRIBUTE17 JOB_DFF_ATTRIBUTE17
, PJ.ATTRIBUTE18 JOB_DFF_ATTRIBUTE18
, PJ.ATTRIBUTE19 JOB_DFF_ATTRIBUTE19
, PJ.ATTRIBUTE20 JOB_DFF_ATTRIBUTE20
, PP.ATTRIBUTE1 POSITION_DFF_ATTRIBUTE1
, PP.ATTRIBUTE2 POSITION_DFF_ATTRIBUTE2
, PP.ATTRIBUTE3 POSITION_DFF_ATTRIBUTE3
, PP.ATTRIBUTE4 POSITION_DFF_ATTRIBUTE4
, PP.ATTRIBUTE5 POSITION_DFF_ATTRIBUTE5
, PP.ATTRIBUTE6 POSITION_DFF_ATTRIBUTE6
, PP.ATTRIBUTE7 POSITION_DFF_ATTRIBUTE7
, PP.ATTRIBUTE8 POSITION_DFF_ATTRIBUTE8
, PP.ATTRIBUTE9 POSITION_DFF_ATTRIBUTE9
, PP.ATTRIBUTE10 POSITION_DFF_ATTRIBUTE10
, PP.ATTRIBUTE11 POSITION_DFF_ATTRIBUTE11
, PP.ATTRIBUTE12 POSITION_DFF_ATTRIBUTE12
, PP.ATTRIBUTE13 POSITION_DFF_ATTRIBUTE13
, PP.ATTRIBUTE14 POSITION_DFF_ATTRIBUTE14
, PP.ATTRIBUTE15 POSITION_DFF_ATTRIBUTE15
, PP.ATTRIBUTE16 POSITION_DFF_ATTRIBUTE16
, PP.ATTRIBUTE17 POSITION_DFF_ATTRIBUTE17
, PP.ATTRIBUTE18 POSITION_DFF_ATTRIBUTE18
, PP.ATTRIBUTE19 POSITION_DFF_ATTRIBUTE19
, PP.ATTRIBUTE20 POSITION_DFF_ATTRIBUTE20
, PAA.ASS_ATTRIBUTE1 ASSIGNMENT_ATTRIBUTE1
, PAA.ASS_ATTRIBUTE2 ASSIGNMENT_ATTRIBUTE2
, PAA.ASS_ATTRIBUTE3 ASSIGNMENT_ATTRIBUTE3
, PAA.ASS_ATTRIBUTE4 ASSIGNMENT_ATTRIBUTE4
, PAA.ASS_ATTRIBUTE5 ASSIGNMENT_ATTRIBUTE5
, PAA.ASS_ATTRIBUTE6 ASSIGNMENT_ATTRIBUTE6
, PAA.ASS_ATTRIBUTE7 ASSIGNMENT_ATTRIBUTE7
, PAA.ASS_ATTRIBUTE8 ASSIGNMENT_ATTRIBUTE8
, PAA.ASS_ATTRIBUTE9 ASSIGNMENT_ATTRIBUTE9
, PAA.ASS_ATTRIBUTE10 ASSIGNMENT_ATTRIBUTE10
, PAA.ASS_ATTRIBUTE11 ASSIGNMENT_ATTRIBUTE11
, PAA.ASS_ATTRIBUTE12 ASSIGNMENT_ATTRIBUTE12
, PAA.ASS_ATTRIBUTE13 ASSIGNMENT_ATTRIBUTE13
, PAA.ASS_ATTRIBUTE14 ASSIGNMENT_ATTRIBUTE14
, PAA.ASS_ATTRIBUTE15 ASSIGNMENT_ATTRIBUTE15
, PAA.ASS_ATTRIBUTE16 ASSIGNMENT_ATTRIBUTE16
, PAA.ASS_ATTRIBUTE17 ASSIGNMENT_ATTRIBUTE17
, PAA.ASS_ATTRIBUTE18 ASSIGNMENT_ATTRIBUTE18
, PAA.ASS_ATTRIBUTE19 ASSIGNMENT_ATTRIBUTE19
, PAA.ASS_ATTRIBUTE20 ASSIGNMENT_ATTRIBUTE20
, PAA.ASS_ATTRIBUTE21 ASSIGNMENT_ATTRIBUTE21
, PAA.ASS_ATTRIBUTE22 ASSIGNMENT_ATTRIBUTE22
, PAA.ASS_ATTRIBUTE23 ASSIGNMENT_ATTRIBUTE23
, PAA.ASS_ATTRIBUTE24 ASSIGNMENT_ATTRIBUTE24
, PAA.ASS_ATTRIBUTE25 ASSIGNMENT_ATTRIBUTE25
, PAA.ASS_ATTRIBUTE26 ASSIGNMENT_ATTRIBUTE26
, PAA.ASS_ATTRIBUTE27 ASSIGNMENT_ATTRIBUTE27
, PAA.ASS_ATTRIBUTE28 ASSIGNMENT_ATTRIBUTE28
, PAA.ASS_ATTRIBUTE29 ASSIGNMENT_ATTRIBUTE29
, PAA.ASS_ATTRIBUTE30 ASSIGNMENT_ATTRIBUTE30
, PTP.START_DATE PAYROLL_PERIOD_START_DATE
, PTP.END_DATE PAYROLL_PERIOD_END_DATE
FROM HR_LOOKUPS HL1
, HR_LOOKUPS HL2
, PER_GRADES PGR
, PAY_PEOPLE_GROUPS PPG
, PER_COLLECTIVE_AGREEMENTS PCA
, PER_CAGR_GRADES_DEF CGD
, PER_TIME_PERIODS PTP
, PER_POSITIONS PP
, PAY_PAYROLLS PPAY
, PER_PAY_BASES PPB
, PAY_COST_ALLOCATIONS_F PCST
, PAY_COST_ALLOCATION_KEYFLEX COST
, PER_ASSIGNMENT_STATUS_TYPES_V PAST
, HR_LOCATIONS HRL
, HR_SOFT_CODING_KEYFLEX HSCK
, PER_JOBS PJ
, HR_ORGANIZATION_UNITS HOU
, PER_PERIODS_OF_SERVICE PPS
, PER_PEOPLE_F PAP2
, PER_PEOPLE_F PAP
, PER_ASSIGNMENTS_F PAA
WHERE PAP.PERSON_ID = PAA.PERSON_ID
AND PAP.BUSINESS_GROUP_ID = PAA.BUSINESS_GROUP_ID
AND SYSDATE BETWEEN PAP.EFFECTIVE_START_DATE
AND PAP.EFFECTIVE_END_DATE
AND SYSDATE BETWEEN PAA.EFFECTIVE_START_DATE
AND PAA.EFFECTIVE_END_DATE
AND PAA.ORGANIZATION_ID = HOU.ORGANIZATION_ID
AND PAA.SUPERVISOR_ID = PAP2.PERSON_ID (+)
AND PAP2.BUSINESS_GROUP_ID (+) = PAA.BUSINESS_GROUP_ID
AND PPS.PERSON_ID = PAP.PERSON_ID
AND PAA.JOB_ID = PJ.JOB_ID (+)
AND HL1.LOOKUP_TYPE(+) = 'WORK_SCHEDULE'
AND HL1.LOOKUP_CODE(+) = PAP.WORK_SCHEDULE
AND HL2.LOOKUP_TYPE(+) = 'FREQUENCY'
AND HL2.LOOKUP_CODE(+) = PAA.FREQUENCY
AND PGR.GRADE_ID(+) = PAA.GRADE_ID
AND HRL.LOCATION_ID (+) = PAA.LOCATION_ID
AND PPG.PEOPLE_GROUP_ID (+) = PAA.PEOPLE_GROUP_ID
AND PP.POSITION_ID (+) = PAA.POSITION_ID
AND PPAY.PAYROLL_ID (+) = PAA.PAYROLL_ID
AND PAST.ASSIGNMENT_STATUS_TYPE_ID = PAA.ASSIGNMENT_STATUS_TYPE_ID
AND HSCK.SOFT_CODING_KEYFLEX_ID (+) = PAA.SOFT_CODING_KEYFLEX_ID
AND PPB.PAY_BASIS_ID (+) = PAA.PAY_BASIS_ID
AND PCA.COLLECTIVE_AGREEMENT_ID (+) = PAA.COLLECTIVE_AGREEMENT_ID
AND CGD.CAGR_GRADE_DEF_ID (+)= PAA.CAGR_GRADE_DEF_ID
AND PCST.ASSIGNMENT_ID (+) = PAA.ASSIGNMENT_ID
AND PCST.COST_ALLOCATION_KEYFLEX_ID = COST.COST_ALLOCATION_KEYFLEX_ID (+)
AND PCST.EFFECTIVE_START_DATE (+) BETWEEN PAA.EFFECTIVE_START_DATE
AND PAA.EFFECTIVE_END_DATE
AND PTP.PAYROLL_ID (+) = PAA.PAYROLL_ID
AND SYSDATE BETWEEN PTP.START_DATE
AND PTP.END_DATE