FND Design Data [Home] [Help]

View: PAY_P46_ASG_INFO_V

Product: PAY - Payroll
Description:
Implementation/DBA Data: ViewAPPS.PAY_P46_ASG_INFO_V
View Text

SELECT AEI.ASSIGNMENT_EXTRA_INFO_ID P46_ASSIGNMENT_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_OBJECT_VERSION_NUM
, AEI.AEI_INFORMATION1 P46_SEND_EDI
, AEI.AEI_INFORMATION2 P46_STATEMENT
, AEI.AEI_INFORMATION3 P46_SEND_EDI_FLAG
, AEI.AEI_INFORMATION4 P46_STATEMENT_SL
, AEI.AEI_INFORMATION5 P46_DEFAULT_SEND_EDI
, AEI.AEI_INFORMATION6 P46_DEFAULT_SEND_EDI_FLAG
FROM PER_ASSIGNMENT_EXTRA_INFO AEI
WHERE AEI. INFORMATION_TYPE = 'GB_P46'

Columns

Name
P46_ASSIGNMENT_EXTRA_INFO_ID
ASSIGNMENT_ID
INFORMATION_TYPE
AEI_INFORMATION_CATEGORY
P46_OBJECT_VERSION_NUM
P46_SEND_EDI
P46_STATEMENT
P46_SEND_EDI_FLAG
P46_STATEMENT_SL
P46_DEFAULT_SEND_EDI
P46_DEFAULT_SEND_EDI_FLAG