View: HR_DE_SOC_INS_ADD_INF_TYPES_V

Product:	PER - Human Resources
Description:	Holds organization info types for Germany
Implementation/DBA Data:	APPS.HR_DE_SOC_INS_ADD_INF_TYPES_V

View Text

SELECT INF.ORGANIZATION_ID
, LU.MEANING PROVIDER_TYPE
, LU.LOOKUP_CODE PROVIDER_CODE
FROM HR_ORGANIZATION_INFORMATION INF
, HR_LOOKUPS LU
WHERE INF.ORG_INFORMATION_CONTEXT = 'CLASS'
AND INF.ORG_INFORMATION2 = 'Y'
AND LU.LOOKUP_TYPE = 'DE_SOC_INS_ADD_INF_TYPE'
AND LU.LOOKUP_CODE = INF.ORG_INFORMATION1

Columns