[Home] [Help]
View: HR_H2PI_ORGANIZATION_CLASS_V
Product: | PER - Human Resources |
Description: | Contains data related to Oracle HR to Oracle Payroll Interface (H2PI) for organization classes |
Implementation/DBA Data: |
APPS.HR_H2PI_ORGANIZATION_CLASS_V
|
View Text
SELECT OGI.LAST_UPDATE_DATE
, ORG.BUSINESS_GROUP_ID
, OGI.ORG_INFORMATION_ID
, OGI.ORGANIZATION_ID
, OGI.ORG_INFORMATION_CONTEXT
, OGI.ORG_INFORMATION1
, OGI.ORG_INFORMATION2
FROM HR_ORGANIZATION_INFORMATION OGI
, HR_ALL_ORGANIZATION_UNITS ORG
WHERE ORG.ORGANIZATION_ID = OGI.ORGANIZATION_ID
AND OGI.ORG_INFORMATION_CONTEXT ='CLASS'
AND OGI.ORG_INFORMATION1 ='HR_ORG'
Columns
Name |
LAST_UPD_DATE |
BUSINESS_GROUP_ID |
ORG_INFORMATION_ID |
ORGANIZATION_ID |
ORG_INFORMATION_CONTEXT |
ORG_INFORMATION1 |
ORG_INFORMATION2 |