Product: | PAY - Payroll |
---|---|
Description: | |
Implementation/DBA Data: | APPS.PAYBV_EMPLOYEE_ARCHIVE |
SELECT PAI.ACTION_CONTEXT_ID
, PAI.TAX_UNIT_ID
, PAI.EFFECTIVE_DATE
, PAI.ASSIGNMENT_ID
, PAI.ACTION_INFORMATION1 FULL_NAME
, PAI.ACTION_INFORMATION2 ORGANIZATION_ID
, PAI.ACTION_INFORMATION4 NATIONAL_IDENTIFIER
, PAI.ACTION_INFORMATION5 PAY_BASIS
, PAI.ACTION_INFORMATION6 FREQUENCY
, PAI.ACTION_INFORMATION7 GRADE
, PAI.ACTION_INFORMATION8 BARGAINING_UNIT
, PAI.ACTION_INFORMATION9 COLLECTIVE_AGREEMENT
, PAI.ACTION_INFORMATION10 EMPLOYEE_NUMBER
, PAY_AC_UTIL.FORMAT_TO_DATE( PAI.ACTION_INFORMATION11) EMPLOYEE_DATE_START
, PAY_AC_UTIL.FORMAT_TO_DATE(PAI.ACTION_INFORMATION12) ORIGINAL_HIRE_DATE
, PAY_AC_UTIL.FORMAT_TO_DATE( PAI.ACTION_INFORMATION13) ADJUSTED_SERVICE_DATE
, PAI.ACTION_INFORMATION14 ASSIGNMENT_NUMBER
, PAI.ACTION_INFORMATION15 ORGANIZATION_NAME
, PAI.ACTION_INFORMATION17 JOB
, PAI.ACTION_INFORMATION18 GRE_NAME
, PAI.ACTION_INFORMATION19 POSITION
, PAI.ACTION_INFORMATION30 LOCATION_NAME
, PAI.ACTION_INFORMATION20 CONTRACT
, PAI.ACTION_INFORMATION21 WORKING_HOURS_START
, PAI.ACTION_INFORMATION22 WORKING_HOURS_END
, PAI.ACTION_INFORMATION23 PAY_CALCULATION_METHOD
, PAI.ACTION_INFORMATION24 SHIFT
, PAI.ACTION_INFORMATION25 EMPLOYER_PHONE_NUMBER
, PAI.ACTION_INFORMATION26 HOURLY_SALARIED_CODE
, PAI.ACTION_INFORMATION27 AGREEMENT_GRADE
, TO_NUMBER(NVL(PAI.ACTION_INFORMATION28
, 0)) PAY_RATE
, (NVL(PAI.ACTION_INFORMATION28
, 0) * NVL(PAI.ACTION_INFORMATION29
, 0)) ANNUAL_SALARY
, PAI.EFFECTIVE_DATE PAYMENT_DATE
FROM PAY_ACTION_INFORMATION PAI
WHERE PAI.ACTION_CONTEXT_TYPE = 'AAP'
AND PAI.ACTION_INFORMATION_CATEGORY = 'EMPLOYEE DETAILS' WITH READ ONLY