Results for “stock_saving”
18 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 →
-
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 →
-
PACKAGE: APPS.PAY_KR_AEI_API 12.2.2
-
PACKAGE: APPS.PAY_KR_AEI_API 12.1.1
-
PACKAGE: APPS.PAY_KR_YEA_PKG 12.1.1
-
PACKAGE: APPS.PAY_KR_YEA_PKG 12.2.2
-
eTRM - PAY Tables and Views 12.2.2
Temporary table used to hold invalid location addresses.
-
eTRM - PAY Tables and Views 12.1.1
Temporary table used to hold invalid location addresses.