View: HR_FR_COMP_PENSION_PRVS_V

Product:	PER - Human Resources
Description:
Implementation/DBA Data:	APPS.HR_FR_COMP_PENSION_PRVS_V

View Text

SELECT OI1.ORG_INFORMATION1
, OU1.BUSINESS_GROUP_ID
, OUT1.NAME
, OI1.ORG_INFORMATION2
, OU2.ORGANIZATION_ID
, OUT2.NAME
FROM HR_ALL_ORGANIZATION_UNITS OU1
, HR_ORGANIZATION_INFORMATION OI1
, HR_ALL_ORGANIZATION_UNITS OU2
, HR_ORGANIZATION_INFORMATION OI2
, HR_ALL_ORGANIZATION_UNITS_TL OUT1
, HR_ALL_ORGANIZATION_UNITS_TL OUT2
WHERE OI2.ORG_INFORMATION_CONTEXT || '' = 'CLASS'
AND OI2.ORG_INFORMATION1 = 'FR_SOCIETE'
AND OI2.ORG_INFORMATION2 = 'Y'
AND OU2.ORGANIZATION_ID = OI2.ORGANIZATION_ID
AND OU2.ORGANIZATION_ID = OI1.ORGANIZATION_ID (+)
AND OI1.ORG_INFORMATION_CONTEXT (+) || '' = 'FR_COMP_PE_PRVS'
AND OU1.ORGANIZATION_ID = TO_NUMBER(OI1.ORG_INFORMATION1)
AND OU1.ORGANIZATION_ID = OUT1.ORGANIZATION_ID
AND USERENV('LANG') = OUT1.LANGUAGE
AND OU2.ORGANIZATION_ID = OUT2.ORGANIZATION_ID
AND USERENV('LANG') = OUT2.LANGUAGE

Columns