View: HR_SUMMARY_KEY_VALUES_V

Product:	PER - Human Resources
Description:	This holds the key types and values from HR_SUMMARY_KEY_VALUES and HR_SUMMARY_KEY_TYPES.
Implementation/DBA Data:	APPS.HR_SUMMARY_KEY_VALUES_V

View Text

SELECT KV.NAME
, KT.NAME
, KV.ITEM_VALUE_ID
FROM HR_SUMMARY_KEY_VALUE KV
, HR_SUMMARY_KEY_TYPE KT
WHERE KV.KEY_TYPE_ID = KT.KEY_TYPE_ID
AND KV.BUSINESS_GROUP_ID = NVL(HR_GENERAL.GET_BUSINESS_GROUP_ID
, KV.BUSINESS_GROUP_ID)

Columns