Results for “com_wpf_qualify_info”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

APPS.PAY_JP_SI_CHANGE_OF_ADDRESS_V is a Japanese localization reporting view in Oracle E-Business Suite that presents Social Insurance (SI) change-of-address events for employees in Japanese business groups. It is designed to support statutory reporting to Japanese authorities, most notably the preparation and validation of Social Insurance qualification, disqualification, and address-change submissions. The view joins assignment, person, address, and payroll balance information into a single denormalized result set that reports the effective date on which an address change took effect, the new and previous addresses, the relevant organization identifier, and the Social Insurance classification (HI, WP, or WPF) associated with the event. A distinctive feature of the view is its reliance on the PAY_JP_BALANCE_PKG package to retrieve entry values — organization identifiers and qualification numbers — dynamically at query time. The user-supplied search term "date_from" maps directly to the view's EFFECTIVE_DATE column, which is derived from PER_ADDRESSES.DATE_FROM on the newly effective address row.

Underlying Base Objects

The view is defined over the following documented base objects:

• PER_ALL_ASSIGNMENTS_F (synonym) — primary assignment and person context.
• PER_ADDRESSES (synonym) — supplies DATE_FROM (exposed as EFFECTIVE_DATE) and the new and previous ADDRESS_ID values via two aliased instances.
• PAY_ELEMENT_ENTRIES_F, PAY_ELEMENT_ENTRY_VALUES_F, PAY_ELEMENT_LINKS_F (synonyms) — element entry data used to identify SI qualification records and their dates.
• PER_BUSINESS_GROUPS_PERF (view) — business group context and the derived IDs generated by HR_JP_ID_PKG.
• HR_JP_ID_PKG (package) — resolves element type IDs and input value IDs for the COM_HI_QUALIFY_INFO, COM_WP_QUALIFY_INFO, and COM_WPF_QUALIFY_INFO elements.
• PAY_JP_BALANCE_PKG (package) — returns entry value numbers and character values (organization, HI number, WP number) for a given assignment and effective date.
• FND_DATE (package) — date conversion utility referenced by the view logic.

The view's SELECT list carries an ORDERED, NO_MERGE, USE_NL hint, indicating the definition is tuned for nested-loop execution over the underlying address and element entry tables.

Key Columns

• ASSIGNMENT_ID / PERSON_ID — the assignment and person for whom the address change applies.
• BUSINESS_GROUP_ID — the business group owning the assignment.
• EFFECTIVE_DATE — sourced from PER_ADDRESSES.DATE_FROM; the date the new address takes effect. This is the column most commonly filtered using a date_from range.
• NEW_ADDRESS_ID / PREV_ADDRESS_ID — the newly effective and prior address records.
• ORGANIZATION_ID — the SI organization reference retrieved through PAY_JP_BALANCE_PKG for the effective date.
• HI_NUMBER / WP_NUMBER — truncated (10-character) Social Insurance qualification numbers for Health Insurance (HI) and Welfare Pension (WP).
• SI_TYPE — derived by summing decode results to classify the record as HI (1), WP (2), or WPF (4).

Common Use Cases and Queries

Typical usage includes generating Social Insurance change-of-address notifications, auditing SI qualification data, and reconciling address history against SI numbers. A representative query filters by the effective date range:

• SELECT person_id, assignment_id, effective_date, new_address_id, prev_address_id, hi_number, wp_number, si_type FROM apps.pay_jp_si_change_of_address_v WHERE effective_date BETWEEN :p_date_from AND :p_date_to ORDER BY person_id, effective_date;
• SELECT si_type, COUNT(*) FROM apps.pay_jp_si_change_of_address_v WHERE effective_date >= :p_date_from GROUP BY si_type;

Because ORGization and number values are resolved through PAY_JP_BALANCE_PKG per row, queries should be constrained by date and business group to limit execution cost. The EFFECTIVE_DATE (date_from) filter is the primary and most efficient selection predicate.