View: PAY_P45_3_ASG_INFO_V

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

View Text

SELECT AEI.ASSIGNMENT_EXTRA_INFO_ID P45_3_ASG_EXTRA_INFO_ID
, AEI.ASSIGNMENT_ID ASSIGNMENT_ID
, AEI.INFORMATION_TYPE INFORMATION_TYPE
, AEI.AEI_INFORMATION_CATEGORY AEI_INFORMATION_CATEGORY
, AEI.OBJECT_VERSION_NUMBER P45_3_OBJECT_VERSION_NUM
, AEI.AEI_INFORMATION1 P45_3_SEND_EDI
, AEI.AEI_INFORMATION2 PREVIOUS_TAX_DISTRICT
, AEI.AEI_INFORMATION3 DATE_LEFT_PREV_EMP
, AEI.AEI_INFORMATION4 PREVIOUS_TAX_CODE
, AEI.AEI_INFORMATION5 PREVIOUS_TAX_BASIS
, SUBSTR(HR_GENERAL.DECODE_LOOKUP('GB_TAX_BASIS'
, AEI.AEI_INFORMATION5)
, 1
, 80) DISPLAY_PREV_TAX_BASIS
, AEI.AEI_INFORMATION6 PREV_EMP_LAST_PAY_PERIOD_TYPE
, SUBSTR(HR_GENERAL.DECODE_LOOKUP('GB_PREV_PAYMENT_TYPE'
, AEI.AEI_INFORMATION6)
, 1
, 80) D_PRV_EMP_LAST_PAY_PERIOD_TYPE
, AEI.AEI_INFORMATION7 PREV_EMP_LAST_PAYMENT_PERIOD
, AEI.AEI_INFORMATION8 P45_3_SEND_EDI_FLAG
, AEI.AEI_INFORMATION9 P45_3_PREV_TAX_PAID_NOTIFIED
, AEI.AEI_INFORMATION10 P45_3_NOT_PAID_BET_START_N5APR
, AEI.AEI_INFORMATION11 P45_3_CONTINUE_SL_DEDUCTIONS
, AEI.AEI_INFORMATION12 P45_3_PREV_TAX_PAY_NOTIFIED
FROM PER_ASSIGNMENT_EXTRA_INFO AEI
WHERE AEI. INFORMATION_TYPE = 'GB_P45_3'

Columns