[Home] [Help]
View: PAY_US_EMP_W4DTL_ACTION_INFO_V
View Text
SELECT PAI.ACTION_CONTEXT_ID
, PAI.TAX_UNIT_ID
, PAI.EFFECTIVE_DATE
, ASG.PERSON_ID PERSON_ID
, PAI.ASSIGNMENT_ID ASSIGNMENT_ID
, ASG.PRIMARY_FLAG PRIMARY_FLAG
, PAI.ACTION_INFORMATION4 TAX_JURISDICTION
, PAI.ACTION_INFORMATION5 STATUS
, PAI.ACTION_INFORMATION6 EXEMPTIONS
, FND_NUMBER.CANONICAL_TO_NUMBER(PAI.ACTION_INFORMATION7) ADDITIONAL_TAX_AMOUNT
, FND_NUMBER.CANONICAL_TO_NUMBER(PAI.ACTION_INFORMATION8) OVERRIDE_TAX_AMOUNT
, PAI.ACTION_INFORMATION9 OVERRIDE_TAX_PERCENTAGE
FROM PAY_ACTION_INFORMATION PAI
, PER_ALL_ASSIGNMENTS_F ASG
WHERE PAI.ACTION_CONTEXT_TYPE = 'AAP'
AND PAI.ACTION_INFORMATION_CATEGORY = 'US WITHHOLDINGS'
AND PAI.ASSIGNMENT_ID = ASG.ASSIGNMENT_ID
AND PAI.EFFECTIVE_DATE BETWEEN ASG.EFFECTIVE_START_DATE
AND ASG.EFFECTIVE_END_DATE
Columns
Name |
ACTION_CONTEXT_ID |
TAX_UNIT_ID |
EFFECTIVE_DATE |
PERSON_ID |
ASSIGNMENT_ID |
PRIMARY_FLAG |
TAX_JURISDICTION |
STATUS |
EXEMPTIONS |
ADDITIONAL_TAX_AMOUNT |
OVERRIDE_TAX_AMOUNT |
OVERRIDE_TAX_PERCENTAGE |