Product: | PER - Human Resources |
---|---|
Description: | Contains data related to Oracle HR to Oracle Payroll Interface (H2PI) for HR organizations |
Implementation/DBA Data: | APPS.HR_H2PI_HR_ORGANIZATIONS_V |
SELECT ORG.LAST_UPDATE_DATE
, ORG.BUSINESS_GROUP_ID
, ORG.ORGANIZATION_ID
, ORG.NAME
, ORG.DATE_FROM
, ORG.DATE_TO
, ORG.LOCATION_ID
, ORG.INTERNAL_EXTERNAL_FLAG
, ORG.ATTRIBUTE_CATEGORY
, ORG.ATTRIBUTE1
, ORG.ATTRIBUTE2
, ORG.ATTRIBUTE3
, ORG.ATTRIBUTE4
, ORG.ATTRIBUTE5
, ORG.ATTRIBUTE6
, ORG.ATTRIBUTE7
, ORG.ATTRIBUTE8
, ORG.ATTRIBUTE9
, ORG.ATTRIBUTE10
, ORG.ATTRIBUTE10
, ORG.ATTRIBUTE11
, ORG.ATTRIBUTE13
, ORG.ATTRIBUTE14
, ORG.ATTRIBUTE15
, ORG.ATTRIBUTE16
, ORG.ATTRIBUTE17
, ORG.ATTRIBUTE18
, ORG.ATTRIBUTE19
, ORG.ATTRIBUTE20
FROM HR_ALL_ORGANIZATION_UNITS ORG
, HR_ORGANIZATION_INFORMATION OGI
WHERE ORG.ORGANIZATION_ID = OGI.ORGANIZATION_ID
AND OGI.ORG_INFORMATION_CONTEXT = 'CLASS'
AND OGI.ORG_INFORMATION1 = 'HR_ORG'