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_CA_SOE_EMPINFO_V

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

View Text

SELECT DISTINCT PPF.FULL_NAME
, PPF.NATIONAL_IDENTIFIER
, PPF.EMPLOYEE_NUMBER
, PPF.PERSON_ID
, PAY_CA_EMP_TAX_INF.GET_ADDRESS(PPF.PERSON_ID
, DECODE(PPA.ACTION_TYPE
, 'R'
, PPA.DATE_EARNED
, 'Q'
, PPA.DATE_EARNED
, 'I'
, PPA.DATE_EARNED
, 'B'
, PPA.DATE_EARNED
, 'V'
, PPA.EFFECTIVE_DATE
, 'C'
, PPA.EFFECTIVE_DATE
, 'P'
, PPA.EFFECTIVE_DATE
, 'U'
, PPA.EFFECTIVE_DATE)
, 1) EMP_ADD_LN1
, PAY_CA_EMP_TAX_INF.GET_ADDRESS(PPF.PERSON_ID
, DECODE(PPA.ACTION_TYPE
, 'R'
, PPA.DATE_EARNED
, 'Q'
, PPA.DATE_EARNED
, 'I'
, PPA.DATE_EARNED
, 'B'
, PPA.DATE_EARNED
, 'V'
, PPA.EFFECTIVE_DATE
, 'C'
, PPA.EFFECTIVE_DATE
, 'P'
, PPA.EFFECTIVE_DATE
, 'U'
, PPA.EFFECTIVE_DATE)
, 2) EMP_ADD_LN2
, PAY_CA_EMP_TAX_INF.GET_ADDRESS(PPF.PERSON_ID
, DECODE(PPA.ACTION_TYPE
, 'R'
, PPA.DATE_EARNED
, 'Q'
, PPA.DATE_EARNED
, 'I'
, PPA.DATE_EARNED
, 'B'
, PPA.DATE_EARNED
, 'V'
, PPA.EFFECTIVE_DATE
, 'C'
, PPA.EFFECTIVE_DATE
, 'P'
, PPA.EFFECTIVE_DATE
, 'U'
, PPA.EFFECTIVE_DATE)
, 3) EMP_ADD_LN3
, PAY_CA_EMP_TAX_INF.GET_ADDRESS(PPF.PERSON_ID
, DECODE(PPA.ACTION_TYPE
, 'R'
, PPA.DATE_EARNED
, 'Q'
, PPA.DATE_EARNED
, 'I'
, PPA.DATE_EARNED
, 'B'
, PPA.DATE_EARNED
, 'V'
, PPA.EFFECTIVE_DATE
, 'C'
, PPA.EFFECTIVE_DATE
, 'P'
, PPA.EFFECTIVE_DATE
, 'U'
, PPA.EFFECTIVE_DATE)
, 4) EMP_ADD_LN4
, LOC.ADDRESS_LINE_1
, LOC.ADDRESS_LINE_2
, LOC.ADDRESS_LINE_3
, LOC.TOWN_OR_CITY
, LOC.REGION_1
, LOC.POSTAL_CODE
, PAF.PAYROLL_ID
, PAF.ASSIGNMENT_NUMBER
, PAF.NORMAL_HOURS
, PAF.FREQUENCY
, PPA.ACTION_TYPE
, PPA.EFFECTIVE_DATE
, PPA.DATE_EARNED
, PAA.ASSIGNMENT_ID
, PAA.PAYROLL_ACTION_ID
, PAA.ASSIGNMENT_ACTION_ID
, PPP.PRE_PAYMENT_ID
, PAA.ACTION_STATUS
, PAA.ACTION_SEQUENCE
, PAA.CHUNK_NUMBER
, PAA.SERIAL_NUMBER
, PAA.OBJECT_VERSION_NUMBER
, PAA.TAX_UNIT_ID
, HOU.NAME
, HOU.ORGANIZATION_ID
, LOC.LOCATION_ID
, LOC.LOCATION_CODE
, SCL.SEGMENT4 WORK_SCHEDULE_ID
, PTP.START_DATE
, PTP.END_DATE
, PAY_CA_EMP_TAX_INF.GET_BASE_SALARY(PAF.ASSIGNMENT_ID
, DECODE(PPA.ACTION_TYPE
, 'R'
, PPA.DATE_EARNED
, 'Q'
, PPA.DATE_EARNED
, 'I'
, PPA.DATE_EARNED
, 'B'
, PPA.DATE_EARNED
, 'P'
, PPA.EFFECTIVE_DATE
, 'V'
, PPA.EFFECTIVE_DATE
, 'U'
, PPA.EFFECTIVE_DATE)
, PAF.PAY_BASIS_ID) BASE_SALARY
, PAY_CA_EMP_TAX_INF.GET_SALARY_BASIS(PAF.PAY_BASIS_ID) PAY_BASIS
, PPA.ASSIGNMENT_SET_ID
, PPA.CONSOLIDATION_SET_ID
, PAF.EFFECTIVE_START_DATE
, PAF.EFFECTIVE_END_DATE
, PPA.LEGISLATIVE_PARAMETERS
, PPF.EFFECTIVE_START_DATE PERSON_EFFECTIVE_START_DATE
, PPF.EFFECTIVE_END_DATE PERSON_EFFECTIVE_END_DATE
, PPF.CORRESPONDENCE_LANGUAGE PERSON_LANGUAGE
FROM HR_ORGANIZATION_UNITS HOU
, PER_TIME_PERIODS PTP
, PER_PEOPLE_F PPF
, HR_SOFT_CODING_KEYFLEX SCL
, PER_ASSIGNMENTS_F PAF
, HR_LOCATIONS LOC
, PAY_PAYROLL_ACTIONS PPA
, PAY_ASSIGNMENT_ACTIONS PAA
, PAY_PRE_PAYMENTS PPP
WHERE HOU.ORGANIZATION_ID = PAF.ORGANIZATION_ID
AND NVL( DECODE(PPA.ACTION_TYPE
, 'R'
, PPA.DATE_EARNED
, 'Q'
, PPA.DATE_EARNED
, 'I'
, PPA.DATE_EARNED
, 'B'
, PPA.DATE_EARNED
, 'V'
, PPA.DATE_EARNED
, 'C'
, PPA.EFFECTIVE_DATE
, 'P'
, PPA.DATE_EARNED
, 'U'
, PPA.DATE_EARNED)
, PPA.EFFECTIVE_DATE) BETWEEN PTP.START_DATE
AND PTP.REGULAR_PAYMENT_DATE
AND PTP.PAYROLL_ID = PPA.PAYROLL_ID
AND NVL(DECODE(PPA.ACTION_TYPE
, 'R'
, PPA.DATE_EARNED
, 'Q'
, PPA.DATE_EARNED
, 'I'
, PPA.DATE_EARNED
, 'B'
, PPA.DATE_EARNED
, 'V'
, PPA.EFFECTIVE_DATE
, 'C'
, PPA.EFFECTIVE_DATE
, 'P'
, PPA.DATE_EARNED
, 'U'
, PPA.DATE_EARNED)
, PPA.EFFECTIVE_DATE) BETWEEN PPF.EFFECTIVE_START_DATE
AND PPF.EFFECTIVE_END_DATE
AND PPF.PERSON_ID = PAF.PERSON_ID
AND LOC.LOCATION_ID = PAF.LOCATION_ID
AND NVL(DECODE(PPA.ACTION_TYPE
, 'R'
, PPA.DATE_EARNED
, 'Q'
, PPA.DATE_EARNED
, 'I'
, PPA.DATE_EARNED
, 'B'
, PPA.DATE_EARNED
, 'V'
, PPA.EFFECTIVE_DATE
, 'C'
, PPA.EFFECTIVE_DATE
, 'P'
, PPA.DATE_EARNED
, 'U'
, PPA.DATE_EARNED)
, PPA.EFFECTIVE_DATE) BETWEEN PAF.EFFECTIVE_START_DATE
AND PAF.EFFECTIVE_END_DATE
AND SCL.SOFT_CODING_KEYFLEX_ID = PAF.SOFT_CODING_KEYFLEX_ID
AND PAF.ASSIGNMENT_ID = PAA.ASSIGNMENT_ID
AND PPA.PAYROLL_ACTION_ID = PAA.PAYROLL_ACTION_ID
AND PAA.ASSIGNMENT_ACTION_ID = PPP.ASSIGNMENT_ACTION_ID(+)

Columns

Name
FULL_NAME
NATIONAL_IDENTIFIER
EMPLOYEE_NUMBER
PERSON_ID
EMP_ADD_LN1
EMP_ADD_LN2
EMP_ADD_LN3
EMP_ADD_LN4
ORG_ADD_LN1
ORG_ADD_LN2
ORG_ADD_LN3
CITY
PROVINCE
ZIP
PAYROLL_ID
ASSIGNMENT_NUMBER
NORMAL_HOURS
FREQUENCY
ACTION_TYPE
EFFECTIVE_DATE
DATE_EARNED
ASSIGNMENT_ID
PAYROLL_ACTION_ID
ASSIGNMENT_ACTION_ID
PRE_PAYMENT_ID
ACTION_STATUS
ACTION_SEQUENCE
CHUNK_NUMBER
SERIAL_NUMBER
OBJECT_VERSION_NUMBER
TAX_UNIT_ID
NAME
ORGANIZATION_ID
LOCATION_ID
LOCATION_CODE
WORK_SCHEDULE_ID
PERIOD_START_DATE
PERIOD_END_DATE
BASE_SALARY
PAY_BASIS
ASSIGNMENT_SET_ID
CONSOLIDATION_SET_ID
EFFECTIVE_START_DATE
EFFECTIVE_END_DATE
LEGISLATIVE_PARAMETERS
PERSON_EFFECTIVE_START_DATE
PERSON_EFFECTIVE_END_DATE
PERSON_LANGUAGE