VIEW: APPS.HR_SUMMARY_KEY_VALUES_LOOKUP_V

Source

View Text - Preformatted

SELECT kv.name ,decode(kv.name,'GSP_OTHER',fnd_message.get_string('PER','PER_74885_OTHER'),hr_general.decode_lookup(substr(kt.key_function,36,instr(kt.key_function,',')-37),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 substr(kt.key_function,1,35)='hr_summary_util.get_lookup_values(''' and kv.business_group_id =NVL(hr_general.get_business_group_id, kv.business_group_id)

View Text - HTML Formatted

SELECT KV.NAME
, DECODE(KV.NAME
, 'GSP_OTHER'
, FND_MESSAGE.GET_STRING('PER'
, 'PER_74885_OTHER')
, HR_GENERAL.DECODE_LOOKUP(SUBSTR(KT.KEY_FUNCTION
, 36
, INSTR(KT.KEY_FUNCTION
, '
, ')-37)
, 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 SUBSTR(KT.KEY_FUNCTION
, 1
, 35)='HR_SUMMARY_UTIL.GET_LOOKUP_VALUES('''
AND KV.BUSINESS_GROUP_ID =NVL(HR_GENERAL.GET_BUSINESS_GROUP_ID
, KV.BUSINESS_GROUP_ID)