Search Results pay_jp_itax_dep_v

Overview

PAY_JP_ITAX_DEP_V is a read-only database view owned by the APPS schema in Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. It is part of the PAY (Payroll) product and is documented as being used exclusively for the Japanese localization. The view presents a filtered subset of payroll action information records, specifically those related to Japanese income tax dependency data. Its purpose is to expose assignment-level tax dependency attributes in a form suitable for reporting, payroll processing, and integration with Japanese statutory tax calculations.

The view is registered in ETRM with a status of VALID and does not store data itself; it derives all content dynamically from its single base object. Because it is defined in the APPS schema, it is accessible to standard EBS responsibilities and concurrent programs that operate under the APPS account, subject to the usual security and menu grants.

Underlying Base Objects

The view is defined over one documented base object: the synonym PAY_ACTION_INFORMATION, which resolves to the underlying payroll action information table. The view does not introduce joins to other tables. Instead, it applies a fixed WHERE clause that restricts the data to a single category and context type.

The defining predicate is:

• ACTION_CONTEXT_TYPE = 'AAP' — restricts rows to the assignment action context.
• ACTION_INFORMATION_CATEGORY = 'JP_ITAX_DEP' — restricts rows to the Japanese income tax dependency category.

The view text also includes the ROWID pseudo-column, which allows tools and forms to address individual rows for update or navigation purposes. Because the view is a simple projection over a single base object, it is inherently updatable for the columns that map directly to the base table.

Key Columns

The view exposes the following columns, each corresponding to a column in PAY_ACTION_INFORMATION:

• ROW_ID — the ROWID of the underlying row, used for row identification and direct addressing.
• ACTION_INFORMATION_ID — the unique identifier of the action information record.
• OBJECT_VERSION_NUMBER — the optimistic locking version number, used to detect concurrent updates.
• ACTION_CONTEXT_ID — the identifier of the context in which the action occurs.
• ACTION_CONTEXT_TYPE — the context type; always 'AAP' in this view.
• ASSIGNMENT_ID — the assignment to which the tax dependency information applies.
• EFFECTIVE_DATE — the date from which the action information is effective.
• ACTION_INFORMATION_CATEGORY — the category; always 'JP_ITAX_DEP' in this view.
• NUM_JUNIOR_DEPS — the number of junior dependents declared for Japanese income tax purposes.
• LAST_UPDATE_LOGIN, LAST_UPDATED_BY, LAST_UPDATE_DATE — standard audit columns.
• CREATED_BY, CREATION_DATE — standard creation audit columns.

The NUM_JUNIOR_DEPS column is the substantive business attribute, carrying the dependent count used in Japanese withholding tax computations.

Common Use Cases and Queries

Typical scenarios include extracting dependent counts for an assignment as of a payroll period, auditing changes to dependent declarations, and feeding Japanese tax calculation routines.

Example: retrieve current dependency information for a specific assignment.

• SELECT assignment_id, effective_date, num_junior_deps
  FROM apps.pay_jp_itax_dep_v
  WHERE assignment_id = :p_assignment_id
  ORDER BY effective_date DESC;

Example: list all dependency records effective within a period.

• SELECT assignment_id, effective_date, num_junior_deps
  FROM apps.pay_jp_itax_dep_v
  WHERE effective_date BETWEEN :p_start_date AND :p_end_date;

Because the view is filtered to a single category, queries do not need to add the ACTION_CONTEXT_TYPE or ACTION_INFORMATION_CATEGORY predicates. The view should be used only within the Japanese localization context; for other localizations, the underlying PAY_ACTION_INFORMATION table must be queried with the appropriate category.