[Home] [Help]
View: HR_H2PI_BG_AND_GRE_V
Product: | PER - Human Resources |
Description: | Contains data related to Oracle HR to Oracle Payroll Interface (H2PI) for business groups and GREs |
Implementation/DBA Data: |
APPS.HR_H2PI_BG_AND_GRE_V
|
View Text
SELECT ORG.LAST_UPDATE_DATE
, ORG.ORGANIZATION_ID
, ORG.BUSINESS_GROUP_ID
, ORG.DATE_FROM
, ORG.NAME
, ORG.DATE_TO
, ORG.LOCATION_ID
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 IN ('HR_BG'
, 'HR_LEGAL')
AND ORG.ATTRIBUTE2 = 'Y'
Columns
Name |
LAST_UPD_DATE |
ORGANIZATION_ID |
BUSINESS_GROUP_ID |
DATE_FROM |
NAME |
DATE_TO |
LOCATION_ID |