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.

VIEW: APPS.PAY_US_EMP_W4DTL_ACTION_INFO_V

Source

View Text - Preformatted


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

View Text - HTML Formatted

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