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_KR_FW_TAX_BREAK_V

Product:	PAY - Payroll
Description:	This view returns EIT value of 'KR_YEA_FW_TAX_BREAK_INFO' based on assignment_id.
Implementation/DBA Data:	APPS.PAY_KR_FW_TAX_BREAK_V

View Text

SELECT AEI.ROWID ROW_ID
, AEI.ASSIGNMENT_EXTRA_INFO_ID
, AEI.ASSIGNMENT_ID
, AEI.INFORMATION_TYPE
, AEI.AEI_INFORMATION_CATEGORY
, AEI.OBJECT_VERSION_NUMBER
, AEI.AEI_INFORMATION1 IMMIGRATION_PURPOSE
, FND_DATE.CANONICAL_TO_DATE(AEI.AEI_INFORMATION2) CONTRACT_DATE
, FND_DATE.CANONICAL_TO_DATE(AEI.AEI_INFORMATION3) EXPIRY_DATE
, AEI.AEI_INFORMATION4 STAX_APPLICABLE_FLAG
, FND_DATE.CANONICAL_TO_DATE(AEI.AEI_INFORMATION5) APPLICATION_DATE
, FND_DATE.CANONICAL_TO_DATE(AEI.AEI_INFORMATION6) SUBMISSION_DATE
FROM PER_ASSIGNMENT_EXTRA_INFO AEI
WHERE AEI.INFORMATION_TYPE = 'KR_YEA_FW_TAX_BREAK_INFO'

Columns

Name
ROW_ID
ASSIGNMENT_EXTRA_INFO_ID
ASSIGNMENT_ID
INFORMATION_TYPE
AEI_INFORMATION_CATEGORY
OBJECT_VERSION_NUMBER
IMMIGRATION_PURPOSE
CONTRACT_DATE
EXPIRY_DATE
STAX_APPLICABLE_FLAG
APPLICATION_DATE
SUBMISSION_DATE