VIEW: APPS.HR_SUMMARY_KEY_VALUES_V

Source

View Text - Preformatted

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)

View Text - HTML Formatted

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)