eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: PAY_APAC_EMPLOYEE_ACTION_V

Product:	PAY - Payroll
Description:
Implementation/DBA Data:	APPS.PAY_APAC_EMPLOYEE_ACTION_V

View Text

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_US_EMPLOYEE_PAYSLIP_WEB.FORMAT_TO_DATE( PAI.ACTION_INFORMATION11) EMPLOYEE_DATE_START
, PAY_US_EMPLOYEE_PAYSLIP_WEB.FORMAT_TO_DATE(PAI.ACTION_INFORMATION12) ORIGINAL_HIRE_DATE
, PAY_US_EMPLOYEE_PAYSLIP_WEB.FORMAT_TO_DATE( PAI.ACTION_INFORMATION13) ADJUSTED_SERVICE_DATE
, PAI.ACTION_INFORMATION14 ASSIGNMENT_NUMBER
, PAI.ACTION_INFORMATION15 ORGANIZATION_NAME
, PAI_OADDR.ACTION_INFORMATION5 EMPLOYER_ADDRESS1
, PAI_OADDR.ACTION_INFORMATION6 EMPLOYER_ADDRESS2
, PAI_OADDR.ACTION_INFORMATION7 EMPLOYER_ADDRESS3
, PAI_OADDR.ACTION_INFORMATION8 EMPLOYER_CITY
, DECODE( PAI_OADDR.ACTION_INFORMATION13
, 'CA'
, PAI_OADDR.ACTION_INFORMATION9
, PAI_OADDR.ACTION_INFORMATION10) EMPLOYER_STATE
, PAI_OADDR.ACTION_INFORMATION12 EMPLOYER_ZIP_CODE
, PAI_OADDR.ACTION_INFORMATION13 EMPLOYER_COUNTRY
, PAY.PAYROLL_NAME PAYROLL_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
, PAI_EADDR.ACTION_INFORMATION5 EMPLOYEE_ADDRESS1
, PAI_EADDR.ACTION_INFORMATION6 EMPLOYEE_ADDRESS2
, PAI_EADDR.ACTION_INFORMATION7 EMPLOYEE_ADDRESS3
, PAI_EADDR.ACTION_INFORMATION8 EMPLOYEE_CITY
, DECODE( PAI_EADDR.ACTION_INFORMATION13
, 'CA'
, PAI_EADDR.ACTION_INFORMATION9
, PAI_EADDR.ACTION_INFORMATION10) EMPLOYEE_STATE
, PAI_EADDR.ACTION_INFORMATION12 EMPLOYEE_ZIP_CODE
, PAI_EADDR.ACTION_INFORMATION13 EMPLOYEE_COUNTRY
, NVL(FND_NUMBER.CANONICAL_TO_NUMBER(PAI.ACTION_INFORMATION28)
, 0) PAY_RATE
, (NVL(FND_NUMBER.CANONICAL_TO_NUMBER(PAI.ACTION_INFORMATION28)
, 0) * NVL(FND_NUMBER.CANONICAL_TO_NUMBER(PAI.ACTION_INFORMATION29)
, 0)) ANNUAL_SALARY
, PTPV.DISPLAY_PERIOD_TYPE PERIOD_TYPE
, PTP.PERIOD_NUM PERIOD_NUM
, PTP.START_DATE BEGINNING_DATE
, PTP.END_DATE ENDING_DATE
, PAI_AD.ACTION_INFORMATION22 PAYMENT_DATE
, PTP.REGULAR_PAYMENT_DATE REGULAR_PAYMENT_DATE
FROM PAY_ACTION_INFORMATION PAI
, PAY_ACTION_INFORMATION PAI_AD
, PAY_ASSIGNMENT_ACTIONS PAA
, PAY_ACTION_INFORMATION PAI_EADDR
, (SELECT DISTINCT ACTION_CONTEXT_ID
, ACTION_INFORMATION1
, ACTION_INFORMATION5
, ACTION_INFORMATION6
, ACTION_INFORMATION7
, ACTION_INFORMATION8
, ACTION_INFORMATION9
, ACTION_INFORMATION10
, ACTION_INFORMATION12
, ACTION_INFORMATION13
FROM PAY_ACTION_INFORMATION
WHERE ACTION_CONTEXT_TYPE = 'PA'
AND ACTION_INFORMATION_CATEGORY = 'ADDRESS DETAILS'
AND ACTION_INFORMATION14 = 'EMPLOYER ADDRESS') PAI_OADDR
, PER_TIME_PERIODS PTP
, PAY_ALL_PAYROLLS_F PAY
, PER_TIME_PERIOD_TYPES_VL PTPV
WHERE PAI.ACTION_CONTEXT_TYPE = 'AAP'
AND PAI_AD.ACTION_CONTEXT_TYPE='AAP'
AND PAI_AD.ACTION_INFORMATION_CATEGORY='AU EMPLOYEE DETAILS'
AND PAI.ACTION_INFORMATION_CATEGORY = 'EMPLOYEE DETAILS'
AND PAA.ASSIGNMENT_ACTION_ID = PAI_AD.ACTION_CONTEXT_ID
AND PAA.ASSIGNMENT_ACTION_ID = PAI.ACTION_CONTEXT_ID
AND PTP.TIME_PERIOD_ID = PAI.ACTION_INFORMATION16
AND PAY.PAYROLL_ID = PTP.PAYROLL_ID
AND PAI.EFFECTIVE_DATE BETWEEN PAY.EFFECTIVE_START_DATE
AND PAY.EFFECTIVE_END_DATE
AND PAI.ACTION_CONTEXT_ID = PAI_EADDR.ACTION_CONTEXT_ID
AND PAI_EADDR.ACTION_CONTEXT_TYPE = 'AAP'
AND PAI_EADDR.ACTION_INFORMATION_CATEGORY = 'ADDRESS DETAILS'
AND PAI_EADDR.ACTION_INFORMATION14 = 'EMPLOYEE ADDRESS'
AND PAI_OADDR.ACTION_CONTEXT_ID = PAA.PAYROLL_ACTION_ID
AND PAI_OADDR.ACTION_INFORMATION1 = PAY_PAYSLIP_UTIL.GET_ID_FOR_EMPLOYER_ADDRESS ( PAY.BUSINESS_GROUP_ID
, PAI.TAX_UNIT_ID
, PAI.ACTION_INFORMATION2 )
AND NVL(PAI_EADDR.ASSIGNMENT_ID
, -1) = NVL(PAI.ASSIGNMENT_ID
, -1)
AND PTP.PERIOD_TYPE = PTPV.PERIOD_TYPE
AND PAI_AD.ACTION_CONTEXT_ID=PAI.ACTION_CONTEXT_ID

Columns

Name
ACTION_CONTEXT_ID
TAX_UNIT_ID
EFFECTIVE_DATE
ASSIGNMENT_ID
FULL_NAME
ORGANIZATION_ID
NATIONAL_IDENTIFIER
PAY_BASIS
FREQUENCY
GRADE
BARGAINING_UNIT
COLLECTIVE_AGREEMENT
EMPLOYEE_NUMBER
EMPLOYEE_DATE_START
ORIGINAL_HIRE_DATE
ADJUSTED_SERVICE_DATE
ASSIGNMENT_NUMBER
ORGANIZATION_NAME
EMPLOYER_ADDRESS1
EMPLOYER_ADDRESS2
EMPLOYER_ADDRESS3
EMPLOYER_CITY
EMPLOYER_STATE
EMPLOYER_ZIP_CODE
EMPLOYER_COUNTRY
PAYROLL_NAME
JOB
GRE_NAME
POSITION
LOCATION_NAME
CONTRACT
WORKING_HOURS_START
WORKING_HOURS_END
PAY_CALCULATION_METHOD
SHIFT
EMPLOYER_PHONE_NUMBER
HOURLY_SALARIED_CODE
AGREEMENT_GRADE
EMPLOYEE_ADDRESS1
EMPLOYEE_ADDRESS2
EMPLOYEE_ADDRESS3
EMPLOYEE_CITY
EMPLOYEE_STATE
EMPLOYEE_ZIP_CODE
EMPLOYEE_COUNTRY
PAY_RATE
ANNUAL_SALARY
PERIOD_TYPE
PERIOD_NUM
BEGINNING_DATE
ENDING_DATE
PAYMENT_DATE
REGULAR_PAYMENT_DATE