Results for “prev_address_id”
8 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
PAY_JP_SI_CHANGE_OF_ADDRESS_V is an APPS-owned database view within the Oracle E-Business Suite Payroll (PAY) product family that supports Japanese statutory social insurance reporting. Specifically, it supplies the data set required for the KOUNEN HIHOKENSHA JYUSHO HENKOU TODOKE, the notification of change of address for employees enrolled in the Japanese employees' pension insurance (kounen hihokensha) scheme. The view is registered as VALID in both Oracle EBS 12.1.1 and 12.2.2, and its definition depends on several Payroll and Human Resources packages and synonyms, including HR_JP_ID_PKG, PAY_JP_BALANCE_PKG, and FND_DATE.
Rather than storing data itself, the view consolidates information from assignment, address, and element entry structures and derives additional attributes through PL/SQL calls. Its output aligns with the layout expectations of the Japanese statutory report, presenting each affected assignment with its new and previous addresses alongside pension and insurance qualification attributes.
Underlying Base Objects
The documented referenced base objects are:
- PER_ALL_ASSIGNMENTS_F (synonym to PER_ALL_ASSIGNMENTS_F) — source of ASSIGNMENT_ID, PERSON_ID, and effective-dated assignment context.
- PER_ADDRESSES (synonym) — provides both the new address (PAD1) and the previous address (PAD2) rows.
- PER_BUSINESS_GROUPS_PERF (view) — supplies BUSINESS_GROUP_ID used to resolve legislation-specific element and input value identifiers.
- PAY_ELEMENT_ENTRIES_F, PAY_ELEMENT_ENTRY_VALUES_F, PAY_ELEMENT_LINKS_F (synonyms) — element entry and input value data used to determine qualification dates and SI type.
- HR_JP_ID_PKG (package) — resolves element type 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) — its GET_ENTRY_VALUE_NUMBER and GET_ENTRY_VALUE_CHAR functions retrieve the organization ID, HI number, and WP number as of a given date.
- FND_DATE (package) — date handling utility referenced by the view.
The hint block /*+ ORDERED NO_MERGE(V) USE_NL(...) */ indicates the view is tuned for nested-loops joins against a driving inline view (V1) that resolves the input value IDs per business group.
Key Columns
- ASSIGNMENT_ID — assignment that owns the change-of-address event.
- PERSON_ID — person identifier for the employee.
- BUSINESS_GROUP_ID — legislative business group.
- EFFECTIVE_DATE — the DATE_FROM of the new address record.
- NEW_ADDRESS_ID / PREV_ADDRESS_ID — address identifiers for the new and prior addresses, used to drive the report's before/after address comparison.
- ORGANIZATION_ID — derived organisation value obtained via PAY_JP_BALANCE_PKG.GET_ENTRY_VALUE_NUMBER, resolved according to whether the qualification date belongs to the HI, WP, or WPF element.
- HI_NUMBER and WP_NUMBER — pension and workers' insurance numbers, truncated to 10 bytes via SUBSTRB.
- SI_TYPE — a summed flag derived from the input value ID (1 = HI, 2 = WP, 4 = WPF), identifying which social insurance scheme the row pertains to.
Common Use Cases and Queries
The view is typically consumed by the Japanese statutory report generation logic and by custom reporting on address changes affecting social insurance notifications. A representative query filters by business group and effective date to retrieve change-of-address rows for a reporting period:
SELECT assignment_id, person_id, new_address_id, prev_address_id, hi_number, wp_number, si_type FROM apps.pay_jp_si_change_of_address_v WHERE business_group_id = :p_bg_id AND effective_date BETWEEN :p_from AND :p_to;- Joining the view to PER_ADDRESSES to display the formatted address lines (including address_line3) for both the new and previous addresses:
SELECT v.assignment_id, a1.address_line1, a1.address_line2, a1.address_line3, a2.address_line1, a2.address_line2, a2.address_line3 FROM apps.pay_jp_si_change_of_address_v v JOIN apps.per_addresses a1 ON a1.address_id = v.new_address_id JOIN apps.per_addresses a2 ON a2.address_id = v.prev_address_id WHERE v.business_group_id = :p_bg_id;
Such queries are useful for auditing the source data feeding the KOUNEN HIHOKENSHA JYUSHO HENKOU TODOKE and for troubleshooting missing or mismatched address lines in the printed output.
-
PAY_JP_SI_CHANGE_OF_ADDRESS_V is used by Japanese statutory report of KOUNEN HIHOKENSHA JYUSHO HENKOU TODOKE
APPS.PAY_JP_SI_CHANGE_OF_ADDRESS_V·↳ FND_DATE·↳ HR_JP_ID_PKG·↳ PAY_ELEMENT_ENTRIES_F·Explore PAY module →
-
PAY_JP_SI_CHANGE_OF_ADDRESS_V is used by Japanese statutory report of KOUNEN HIHOKENSHA JYUSHO HENKOU TODOKE
APPS.PAY_JP_SI_CHANGE_OF_ADDRESS_V·↳ FND_DATE·↳ HR_JP_ID_PKG·↳ PAY_ELEMENT_ENTRIES_F·Explore PAY module →
-
eTRM - PAY Tables and Views 12.1.1
Temporary table used to hold invalid location addresses.
-
eTRM - PAY Tables and Views 12.2.2
Temporary table used to hold invalid location addresses.