View: HR_H2PI_ADDRESSES_V

Product:	PER - Human Resources
Description:	Contains data related to Oracle HR to Oracle Payroll Interface (H2PI) addresses
Implementation/DBA Data:	APPS.HR_H2PI_ADDRESSES_V

View Text

SELECT PA.LAST_UPDATE_DATE
, PA.BUSINESS_GROUP_ID
, PA.ADDRESS_ID
, PA.PERSON_ID
, PA.STYLE
, PA.DATE_FROM
, PA.DATE_TO
, PA.ADDRESS_TYPE
, PA.ADDRESS_LINE1
, PA.ADDRESS_LINE2
, PA.ADDRESS_LINE3
, PA.TOWN_OR_CITY
, PA.REGION_1
, PA.REGION_2
, PA.REGION_3
, PA.POSTAL_CODE
, PA.COUNTRY
, PA.TELEPHONE_NUMBER_1
, PA.TELEPHONE_NUMBER_2
, PA.TELEPHONE_NUMBER_3
, PA.ADD_INFORMATION13
, PA.ADD_INFORMATION14
, PA.ADD_INFORMATION15
, PA.ADD_INFORMATION16
, PA.ADD_INFORMATION17
, PA.ADD_INFORMATION18
, PA.ADD_INFORMATION19
, PA.ADD_INFORMATION20
, PA.ADDR_ATTRIBUTE_CATEGORY
, PA.ADDR_ATTRIBUTE1
, PA.ADDR_ATTRIBUTE2
, PA.ADDR_ATTRIBUTE3
, PA.ADDR_ATTRIBUTE4
, PA.ADDR_ATTRIBUTE5
, PA.ADDR_ATTRIBUTE6
, PA.ADDR_ATTRIBUTE7
, PA.ADDR_ATTRIBUTE8
, PA.ADDR_ATTRIBUTE9
, PA.ADDR_ATTRIBUTE10
, PA.ADDR_ATTRIBUTE11
, PA.ADDR_ATTRIBUTE12
, PA.ADDR_ATTRIBUTE13
, PA.ADDR_ATTRIBUTE14
, PA.ADDR_ATTRIBUTE15
, PA.ADDR_ATTRIBUTE16
, PA.ADDR_ATTRIBUTE17
, PA.ADDR_ATTRIBUTE18
, PA.ADDR_ATTRIBUTE19
, PA.ADDR_ATTRIBUTE20
FROM PER_ADDRESSES PA
WHERE PA.PRIMARY_FLAG = 'Y'
AND EXISTS (SELECT PP.PERSON_ID
FROM HR_H2PI_EMPLOYEES_V PP
WHERE PP.PERSON_ID = PA.PERSON_ID)

Columns