Results for “assignment_extra_info_id”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
PAY_KR_TAX_BREAK_V is a payroll-related database view owned by the APPS schema in Oracle E-Business Suite (documented for 12.1.1 and 12.2.2). Its purpose is narrow and well defined: it returns the assignment extra information (EIT) record of type KR_YEA_TAX_BREAK_INFO for a given assignment. This EIT belongs to the Korean (KR) localization and stores year-end adjustment (YEA) tax break details — housing loan interest repayment, stock savings, and long-term stock savings — that feed Korean year-end tax settlement processing. The view exposes these canonical values in a report-friendly, typed form so that payroll reports, statutory extracts, and downstream integrations can retrieve the tax-break amounts without decoding the raw PER_ASSIGNMENT_EXTRA_INFO row. A user searching for "kr_yea_tax_break_info" is in practice looking for the EIT that this view surfaces; the view is the supported, queryable interface to that EIT data.
Underlying Base Objects
The view is defined over the following documented objects:
- PER_ASSIGNMENT_EXTRA_INFO (synonym, aliased AEI) — the primary source of rows. The view filters this table to INFORMATION_TYPE = 'KR_YEA_TAX_BREAK_INFO'.
- FND_SESSIONS (synonym, aliased FND) — joined to restrict rows to the current runtime session via FND.SESSION_ID = USERENV('SESSIONID').
- FND_DATE (package) — used to convert the canonical date string in AEI_INFORMATION1 into a true date (CANONICAL_TO_DATE).
- FND_NUMBER (package) — used to convert canonical numeric strings in AEI_INFORMATION2/3/4 into numeric values (CANONICAL_TO_NUMBER).
The join condition further matches the year portion of the FND_SESSIONS effective date against the first four characters of AEI_INFORMATION1, ensuring the retrieved EIT corresponds to the session's effective year. Conceptually, the view is a filtered, decoded projection of PER_ASSIGNMENT_EXTRA_INFO rather than an aggregation of multiple base tables.
Key Columns
- ROW_ID — the ROWID of the AEI row, providing a unique row identifier.
- ASSIGNMENT_EXTRA_INFO_ID — primary key of the underlying PER_ASSIGNMENT_EXTRA_INFO record.
- ASSIGNMENT_ID — the assignment to which the tax-break information applies.
- INFORMATION_TYPE — always 'KR_YEA_TAX_BREAK_INFO' for this view.
- AEI_INFORMATION_CATEGORY — the information category of the EIT definition.
- OBJECT_VERSION_NUMBER — standard EBS optimistic-locking version column.
- EFFECTIVE_DATE — CANONICAL_TO_DATE(AEI_INFORMATION1); the effective date of the tax-break record, whose year drives the join to the session.
- HOUSING_LOAN_INTEREST_REPAY — CANONICAL_TO_NUMBER(AEI_INFORMATION2); the housing loan interest repayment amount.
- STOCK_SAVING — CANONICAL_TO_NUMBER(AEI_INFORMATION3); the stock savings amount.
- LT_STOCK_SAVING — CANONICAL_TO_NUMBER(AEI_INFORMATION4); the long-term stock savings amount.
Common Use Cases and Queries
Typical uses include year-end adjustment reporting, payroll verification, and integration extracts that need Korean tax-break amounts per assignment. Note the session-dependent predicate: the view only returns rows for the current FND session and matching year, so it must be queried from within an EBS runtime session.
- Retrieve tax-break details for a single assignment for the current session year.
- Build a listing of all assignments with housing loan interest or stock savings values.
- Feed a year-end tax settlement extract with decoded numeric amounts.
Sample query:
SELECT assignment_id,
effective_date,
housing_loan_interest_repay,
stock_saving,
lt_stock_saving
FROM apps.pay_kr_tax_break_v
WHERE assignment_id = :p_assignment_id;
SELECT assignment_id,
housing_loan_interest_repay,
stock_saving,
lt_stock_saving
FROM apps.pay_kr_tax_break_v
WHERE NVL(housing_loan_interest_repay,0) > 0
OR NVL(stock_saving,0) > 0
OR NVL(lt_stock_saving,0) > 0
ORDER BY assignment_id;
Because the view applies the session and effective-year predicates internally, callers should not re-filter on INFORMATION_TYPE; they should instead supply the assignment context and rely on the view to return the correctly decoded, current-year tax-break record.
-
View: PAY_KR_TAX_BREAK_V 12.1.1
This view returns EIT value of 'KR_YEA_TAX_BREAK_INFO' based on assignment_id.
APPS.PAY_KR_TAX_BREAK_V·↳ FND_DATE·↳ FND_NUMBER·↳ FND_SESSIONS·Explore PAY module →
-
Hong Kong localisation view.
APPS.PAY_HK_IR56_QUARTERS_ACTIONS_V·↳ FF_CONTEXTS·↳ FND_NUMBER·↳ PAY_ACTION_CONTEXTS·Explore PAY module →
-
View: PAY_EMP_LOCAL_TAX_V1 12.2.2
Used to support user interface
APPS.PAY_EMP_LOCAL_TAX_V1·↳ FND_NUMBER·↳ HR_API·↳ HR_LOOKUPS·Explore PAY module →
-
View: PAY_KR_YER_PREV_ER_V 12.2.2
This view returns previous employer information from assignment EIT.YEA process does not output previous employer information as database item.Therefore, the system have to get these data from assignment EIT based on assignment_id and termi
APPS.PAY_KR_YER_PREV_ER_V·↳ FND_DATE·↳ FND_NUMBER·↳ PER_ASSIGNMENT_EXTRA_INFO·Explore PAY module →
-
View: PAY_KR_FW_TAX_BREAK_V 12.2.2
This view returns EIT value of 'KR_YEA_FW_TAX_BREAK_INFO' based on assignment_id.
APPS.PAY_KR_FW_TAX_BREAK_V·↳ FND_DATE·↳ PER_ASSIGNMENT_EXTRA_INFO·Explore PAY module →
-
This view returns EIT value of 'KR_YEA_DPNT_EDUC_TAX_EXEM_INFO' based on assignment_id.
APPS.PAY_KR_DPNT_EDUC_TAX_EXEM_V·↳ FND_DATE·↳ FND_NUMBER·↳ FND_SESSIONS·Explore PAY module →
-
View: PAY_KR_TAX_EXEM_V 12.1.1
This view returns EIT value of 'KR_YEA_TAX_EXEM_INFO' based on assignment_id.
APPS.PAY_KR_TAX_EXEM_V·↳ FND_DATE·↳ FND_NUMBER·↳ FND_SESSIONS·Explore PAY module →
-
Hong Kong localisation view.
APPS.PAY_HK_IR56_QUARTERS_ACTIONS_V·↳ FF_CONTEXTS·↳ FND_NUMBER·↳ PAY_ACTION_CONTEXTS·Explore PAY module →
-
View: PAY_KR_TAX_EXEM_V 12.2.2
This view returns EIT value of 'KR_YEA_TAX_EXEM_INFO' based on assignment_id.
APPS.PAY_KR_TAX_EXEM_V·↳ FND_DATE·↳ FND_NUMBER·↳ FND_SESSIONS·Explore PAY module →
-
View: PAY_KR_OVS_TAX_BREAK_V 12.1.1
This view returns EIT value of 'KR_YEA_OVS_TAX_BREAK_INFO' based on assignment_id.
APPS.PAY_KR_OVS_TAX_BREAK_V·↳ FND_DATE·↳ FND_NUMBER·↳ FND_SESSIONS·Explore PAY module →
-
View: PAY_JP_ISDF_NONLIFE_V 12.2.2
This view is used for Japanese localization only.
APPS.PAY_JP_ISDF_NONLIFE_V·↳ FND_NUMBER·↳ PAY_JP_ISDF_NONLIFE_DML_V·Explore PAY module →
-
Tax Batch update view
APPS.HR_DE_ASG_TAX_BATCH_UPD_V·↳ PER_ASSIGNMENT_EXTRA_INFO·Explore PER module →
-
Tax Batch update view
APPS.HR_DE_ASG_TAX_BATCH_UPD_V·↳ PER_ASSIGNMENT_EXTRA_INFO·Explore PER module →
-
View: PAY_KR_FW_TAX_BREAK_V 12.1.1
This view returns EIT value of 'KR_YEA_FW_TAX_BREAK_INFO' based on assignment_id.
APPS.PAY_KR_FW_TAX_BREAK_V·↳ FND_DATE·↳ PER_ASSIGNMENT_EXTRA_INFO·Explore PAY module →
-
View: PAY_KR_YER_PREV_ER_V 12.1.1
This view returns previous employer information from assignment EIT.YEA process does not output previous employer information as database item.Therefore, the system have to get these data from assignment EIT based on assignment_id and termi
APPS.PAY_KR_YER_PREV_ER_V·↳ FND_DATE·↳ FND_NUMBER·↳ PER_ASSIGNMENT_EXTRA_INFO·Explore PAY module →
-
This is a copy of the PER_ASSIGNMENT_EXTRA_INFO table which is populated by the EFC (Euro as Functional Currency) process.
-
View: PAY_KR_PREV_ER_V 12.1.1
This view returns EIT value of 'KR_YEA_PREV_ER_INFO' based on assignment_id.
APPS.PAY_KR_PREV_ER_V·↳ FND_DATE·↳ FND_NUMBER·↳ FND_SESSIONS·Explore PAY module →
-
View: PAY_KR_OVS_TAX_BREAK_V 12.2.2
This view returns EIT value of 'KR_YEA_OVS_TAX_BREAK_INFO' based on assignment_id.
APPS.PAY_KR_OVS_TAX_BREAK_V·↳ FND_DATE·↳ FND_NUMBER·↳ FND_SESSIONS·Explore PAY module →
-
View: PAY_KR_TAX_BREAK_V 12.2.2
This view returns EIT value of 'KR_YEA_TAX_BREAK_INFO' based on assignment_id.
APPS.PAY_KR_TAX_BREAK_V·↳ FND_DATE·↳ FND_NUMBER·↳ FND_SESSIONS·Explore PAY module →
-
This view returns EIT value of 'KR_YEA_DPNT_EDUC_TAX_EXEM_INFO' based on assignment_id.
APPS.PAY_KR_DPNT_EDUC_TAX_EXEM_V·↳ FND_DATE·↳ FND_NUMBER·↳ FND_SESSIONS·Explore PAY module →
-
This view is used for Japanese localization only.
APPS.PAY_JP_ISDF_LIFE_PENS_V·↳ FND_DATE·↳ FND_NUMBER·↳ PAY_JP_ISDF_LIFE_PENS_DML_V·Explore PAY module →
-
View: PAY_EMP_STATE_TAX_V1 12.1.1
Used to support user interface
APPS.PAY_EMP_STATE_TAX_V1·↳ FND_DATE·↳ FND_GLOBAL·↳ FND_NUMBER·Explore PAY module →
-
View: PAY_KR_SP_TAX_EXEM_V 12.2.2
This view returns EIT value of 'KR_YEA_SP_TAX_EXEM_INFO' based on assignment_id.
APPS.PAY_KR_SP_TAX_EXEM_V·↳ FND_DATE·↳ FND_NUMBER·↳ FND_SESSIONS·Explore PAY module →
-
View: PAY_KR_SP_TAX_EXEM_V 12.1.1
This view returns EIT value of 'KR_YEA_SP_TAX_EXEM_INFO' based on assignment_id.
APPS.PAY_KR_SP_TAX_EXEM_V·↳ FND_DATE·↳ FND_NUMBER·↳ FND_SESSIONS·Explore PAY module →
-
View: PAY_JP_ISDF_LIFE_GEN_V 12.1.1
This view is used for Japanese localization only.
APPS.PAY_JP_ISDF_LIFE_GEN_V·↳ FND_NUMBER·↳ PAY_JP_ISDF_LIFE_GEN_DML_V·Explore PAY module →
-
This view is used for Japanese localization only.
APPS.PAY_JP_ISDF_LIFE_PENS_DML_V·↳ PAY_ACTION_INFORMATION·Explore PAY module →
-
This view is used for Japanese localization only.
APPS.PAY_JP_ISDF_LIFE_PENS_V·↳ FND_DATE·↳ FND_NUMBER·↳ PAY_JP_ISDF_LIFE_PENS_DML_V·Explore PAY module →
-
This view is used for Japanese localization only.
APPS.PAY_JP_ISDF_NONLIFE_DML_V·↳ PAY_ACTION_INFORMATION·Explore PAY module →
-
View: PAY_EMP_LOCAL_TAX_V1 12.1.1
Used to support user interface
APPS.PAY_EMP_LOCAL_TAX_V1·↳ FND_GLOBAL·↳ FND_NUMBER·↳ HR_API·Explore PAY module →
-
View: GHR_MT_ASSIGNMENT_EI_V 12.1.1
This views is used by mass transfer in and out processes for datatransfer.
APPS.GHR_MT_ASSIGNMENT_EI_V·↳ GHR_INTERFACE·Explore GHR module →
-
View: GHR_MT_ASSIGNMENT_EI_V 12.2.2
This views is used by mass transfer in and out processes for datatransfer.
APPS.GHR_MT_ASSIGNMENT_EI_V·↳ GHR_INTERFACE·Explore GHR module →
-
This view is used for Japanese localization only.
APPS.PAY_JP_ISDF_LIFE_GEN_DML_V·↳ PAY_ACTION_INFORMATION·Explore PAY module →
-
This view is used for Japanese localization only.
APPS.PAY_JP_ISDF_LIFE_GEN_DML_V·↳ PAY_ACTION_INFORMATION·Explore PAY module →
-
This view is used for Japanese localization only.
APPS.PAY_JP_ISDF_NONLIFE_DML_V·↳ PAY_ACTION_INFORMATION·Explore PAY module →
-
View: PAY_EMP_FED_TAX_V1 12.1.1
Used to support user interface
APPS.PAY_EMP_FED_TAX_V1·↳ FND_DATE·↳ FND_GLOBAL·↳ FND_NUMBER·Explore PAY module →
-
View: PAY_EMP_FED_TAX_V1 12.2.2
Used to support user interface
APPS.PAY_EMP_FED_TAX_V1·↳ FND_DATE·↳ FND_NUMBER·↳ HR_API·Explore PAY module →
-
View: PER_QH_EIT_V 12.1.1
View of person and assignment extra information used by People Management form
APPS.PER_QH_EIT_V·↳ PER_ASSIGNMENT_EXTRA_INFO·↳ PER_PEOPLE_EXTRA_INFO·Explore PER module →
-
View: PAY_KR_PREV_ER_V 12.2.2
This view returns EIT value of 'KR_YEA_PREV_ER_INFO' based on assignment_id.
APPS.PAY_KR_PREV_ER_V·↳ FND_DATE·↳ FND_NUMBER·↳ FND_SESSIONS·Explore PAY module →
-
Extra information for an assignment.
-
View: PER_QH_EIT_V 12.2.2
View of person and assignment extra information used by People Management form
APPS.PER_QH_EIT_V·↳ PER_ASSIGNMENT_EXTRA_INFO·↳ PER_PEOPLE_EXTRA_INFO·Explore PER module →
-
View: PAY_JP_ISDF_LIFE_GEN_V 12.2.2
This view is used for Japanese localization only.
APPS.PAY_JP_ISDF_LIFE_GEN_V·↳ FND_NUMBER·↳ PAY_JP_ISDF_LIFE_GEN_DML_V·Explore PAY module →
-
This view is used for Japanese localization only.
APPS.PAY_JP_ISDF_LIFE_PENS_DML_V·↳ PAY_ACTION_INFORMATION·Explore PAY module →
-
View: PAY_JP_ISDF_NONLIFE_V 12.1.1
This view is used for Japanese localization only.
APPS.PAY_JP_ISDF_NONLIFE_V·↳ FND_NUMBER·↳ PAY_JP_ISDF_NONLIFE_DML_V·Explore PAY module →
-
View: PAY_EMP_STATE_TAX_V1 12.2.2
Used to support user interface
APPS.PAY_EMP_STATE_TAX_V1·↳ FND_DATE·↳ FND_NUMBER·↳ HR_API·Explore PAY module →
-
APPS.BEN_ASSIGNMENT_EXTRA_IN_V·↳ FND_SESSIONS·↳ PER_ALL_ASSIGNMENTS_F·↳ PER_ASSIGNMENT_EXTRA_INFO·Explore BEN module →
-
This is a copy of the PER_ASSIGNMENT_EXTRA_INFO table which is populated by the EFC (Euro as Functional Currency) process.
-
Extra information for an assignment.
-
Mapping of GHR_PA_HISTORY columns to PER_ASSIGNMENTS_EXTRA_INFO.
APPS.GHR_ASSIGNMENT_EXTRA_INFO_H_V·↳ FND_DATE·↳ GHR_GENERAL·↳ GHR_PA_HISTORY·Explore GHR module →
-
Mapping of GHR_PA_HISTORY columns to PER_ASSIGNMENTS_EXTRA_INFO.
APPS.GHR_ASSIGNMENT_EXTRA_INFO_H_V·↳ FND_DATE·↳ GHR_GENERAL·↳ GHR_PA_HISTORY·Explore GHR module →
-
APPS.BEN_ASSIGNMENT_EXTRA_IN_V·↳ FND_SESSIONS·↳ PER_ALL_ASSIGNMENTS_F·↳ PER_ASSIGNMENT_EXTRA_INFO·Explore BEN module →