[Home] [Help]
View: PAY_KR_TAX_BREAK_V
Product: | PAY - Payroll |
Description: | This view returns EIT value of 'KR_YEA_TAX_BREAK_INFO' based on assignment_id. |
Implementation/DBA Data: |
APPS.PAY_KR_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
, FND_DATE.CANONICAL_TO_DATE(AEI.AEI_INFORMATION1) EFFECTIVE_DATE
, FND_NUMBER.CANONICAL_TO_NUMBER(AEI.AEI_INFORMATION2) HOUSING_LOAN_INTEREST_REPAY
, FND_NUMBER.CANONICAL_TO_NUMBER(AEI.AEI_INFORMATION3) STOCK_SAVING
, FND_NUMBER.CANONICAL_TO_NUMBER(AEI.AEI_INFORMATION4) LT_STOCK_SAVING
FROM PER_ASSIGNMENT_EXTRA_INFO AEI
, FND_SESSIONS FND
WHERE AEI.INFORMATION_TYPE = 'KR_YEA_TAX_BREAK_INFO'
AND FND.SESSION_ID = USERENV('SESSIONID')
AND SUBSTR(TO_CHAR(FND.EFFECTIVE_DATE
, 'DD-MON-YYYY')
, 8
, 4) = SUBSTR(AEI.AEI_INFORMATION1
, 1
, 4)
Columns
Name |
ROW_ID |
ASSIGNMENT_EXTRA_INFO_ID |
ASSIGNMENT_ID |
INFORMATION_TYPE |
AEI_INFORMATION_CATEGORY |
OBJECT_VERSION_NUMBER |
EFFECTIVE_DATE |
HOUSING_LOAN_INTEREST_REPAY |
STOCK_SAVING |
LT_STOCK_SAVING |