Product: | PER - Human Resources |
---|---|
Description: | Hungary Absence Report View |
Implementation/DBA Data: | APPS.PER_HU_ABSENCE_REPORT_V |
SELECT PPA.PAYROLL_ACTION_ID PAYROLL_ACTION_ID
, PPA.REQUEST_ID GENERATOR_REQUEST_ID
, PAA.ASSIGNMENT_ACTION_ID ASSIGNMENT_ACTION_ID
, PAI.ACTION_INFORMATION4 COMPANY_NAME
, PAI.ACTION_INFORMATION5 FULL_NAME
, PAI.ACTION_INFORMATION6 ORGANIZATION
, PAI.ACTION_INFORMATION7 LOCATION
, PAI.ACTION_INFORMATION8 EMPLOYEE_NUMBER
, PAI.ACTION_INFORMATION9 BIRTH_DATE
, PAI.ACTION_INFORMATION10 JOB
, PAI.ACTION_INFORMATION11 HIRE_DATE
, PAI.ACTION_INFORMATION12 SUSPENDED_END_DATE
, PAI.ACTION_INFORMATION13 REPORTING_YEAR
, PAI.ACTION_INFORMATION14 BASE_HOLIDAY
, PAI.ACTION_INFORMATION15 ADDITIONAL_HOLIDAY_CHILD_CARE
, PAI.ACTION_INFORMATION16 OTHER_ADDITIONAL_HOLIDAY
, PAI.ACTION_INFORMATION17 PAID_HOLIDAY_CARRY_OVER
, PAI.ACTION_INFORMATION18 SICKNESS_HOLIDAY
, PAI.ACTION_INFORMATION19 TOTAL_NORMAL_PAID_HOLIDAY
, PAI.ACTION_INFORMATION20 ISSUE_DATE
, PAI.ACTION_INFORMATION21 PEOPLE_GROUP
FROM PAY_ACTION_INFORMATION PAI
, PAY_ASSIGNMENT_ACTIONS PAA
, PAY_PAYROLL_ACTIONS PPA
WHERE PPA.PAYROLL_ACTION_ID = PAA.PAYROLL_ACTION_ID
AND PAA.ASSIGNMENT_ACTION_ID = PAI.ACTION_CONTEXT_ID
AND PAI.ACTION_INFORMATION_CATEGORY = 'HU_ABSENCE_REPORT'
AND PAI.ACTION_CONTEXT_TYPE = 'AAP'