VIEW: APPS.PER_HU_ABSENCE_REPORT_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'