Product: | PAY - Payroll |
---|---|
Description: | |
Implementation/DBA Data: | APPS.PAY_P46_PENNOT_ASG_INFO_V |
SELECT ASSIGNMENT_EXTRA_INFO_ID P46_PEN_ASG_EXTRA_INFO_ID
, ASSIGNMENT_ID ASSIGNMENT_ID
, INFORMATION_TYPE INFORMATION_TYPE
, AEI_INFORMATION_CATEGORY AEI_INFORMATION_CATEGORY
, OBJECT_VERSION_NUMBER P46_PEN_OBJECT_VERSION_NUM
, AEI_INFORMATION1 P46_PEN_SEND_EDI
, AEI_INFORMATION2 ANNUAL_PENSION
, AEI_INFORMATION3 DATE_PENSION_STARTED
, AEI_INFORMATION4 P46_PENNOT_SEND_EDI_FLAG
, AEI_INFORMATION5 PREVIOUS_TAX_DISTRICT
, AEI_INFORMATION6 DATE_LEFT_PREV_EMP
, AEI_INFORMATION7 PREVIOUS_TAX_CODE
, AEI_INFORMATION8 PREVIOUS_TAX_BASIS
, AEI_INFORMATION9 PREV_EMP_LAST_PAY_PERIOD_TYPE
, AEI_INFORMATION10 PREV_EMP_LAST_PAYMENT_PERIOD
, AEI_INFORMATION11 RECENTLY_BEREAVED
FROM PER_ASSIGNMENT_EXTRA_INFO AEI
WHERE AEI.INFORMATION_TYPE = 'GB_P46PENNOT'