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_P46_EXPAT_ASG_INFO_V

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

View Text

SELECT AEI.ASSIGNMENT_EXTRA_INFO_ID P46_EXPAT_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 P46_EXPAT_OBJECT_VERSION_NUM
, AEI.AEI_INFORMATION1 P46_EXPAT_SEND_EDI
, AEI.AEI_INFORMATION2 P46_EXPAT_STATEMENT
, AEI.AEI_INFORMATION3 P46_EXPAT_SEND_EDI_FLAG
, AEI.AEI_INFORMATION4 P46_EXPAT_STUDENT_LOAN
, AEI.AEI_INFORMATION5 P46_EXPAT_EEA_CITIZEN
, AEI.AEI_INFORMATION6 P46_EXPAT_EMP6_SCHEME
, AEI.AEI_INFORMATION7 P46_EXPAT_START_UK_EMPL_DATE
FROM PER_ASSIGNMENT_EXTRA_INFO AEI
WHERE AEI.INFORMATION_TYPE = 'GB_P46EXP'

Columns

Name
P46_EXPAT_ASG_EXTRA_INFO_ID
ASSIGNMENT_ID
INFORMATION_TYPE
AEI_INFORMATION_CATEGORY
P46_EXPAT_OBJECT_VERSION_NUM
P46_EXPAT_SEND_EDI
P46_EXPAT_STATEMENT
P46_EXPAT_SEND_EDI_FLAG
P46_EXPAT_STUDENT_LOAN
P46_EXPAT_EEA_CITIZEN
P46_EXPAT_EMP6_SCHEME
P46_EXPAT_START_UK_EMPL_DATE