[Home] [Help]
View: PER_JP_ADDRESS_CHANGES_V
Product: | PER - Human Resources |
Description: | This view is used by Japanese statutory report (Notification for Address Change of National Pension Type 3 Insured). |
Implementation/DBA Data: |
APPS.PER_JP_ADDRESS_CHANGES_V
|
View Text
SELECT PA1.PERSON_ID
, PA1.ADDRESS_TYPE
, PA1.ADDRESS_ID
, PA2.ADDRESS_ID
, PA2.DATE_FROM
FROM PER_ADDRESSES PA1
, PER_ADDRESSES PA2
WHERE PA1.PERSON_ID = PA2.PERSON_ID
AND PA1.DATE_TO = PA2.DATE_FROM - 1
AND PA1.ADDRESS_TYPE = PA2.ADDRESS_TYPE
Columns
Name |
PERSON_ID |
ADDRESS_TYPE |
OLD_ADDRESS_ID |
NEW_ADDRESS_ID |
EFFECTIVE_DATE |