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:

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

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.