VIEW: APPS.HR_SUMMARY_KEY_VALUES_BAND_V

Source

View Text - Preformatted

SELECT kv.name, utr.display_sequence, kt.name, kv.item_value_id FROM hr_summary_key_value kv, hr_summary_key_type kt, pay_user_tables ut, pay_user_rows_x utr WHERE kv.key_type_id = kt.key_type_id and substr(kt.key_function,1,33) = 'hr_summary_util.get_band_values(''' and kv.business_group_id = NVL(hr_general.get_business_group_id, kv.business_group_id) and ut.user_table_name = substr(kt.key_function,34,instr(kt.key_function,',')-35) and ut.business_group_id = kv.business_group_id and ut.user_table_id = utr.user_table_id and kv.name = utr.row_low_range_or_name

View Text - HTML Formatted

SELECT KV.NAME
, UTR.DISPLAY_SEQUENCE
, KT.NAME
, KV.ITEM_VALUE_ID
FROM HR_SUMMARY_KEY_VALUE KV
, HR_SUMMARY_KEY_TYPE KT
, PAY_USER_TABLES UT
, PAY_USER_ROWS_X UTR
WHERE KV.KEY_TYPE_ID = KT.KEY_TYPE_ID
AND SUBSTR(KT.KEY_FUNCTION
, 1
, 33) = 'HR_SUMMARY_UTIL.GET_BAND_VALUES('''
AND KV.BUSINESS_GROUP_ID = NVL(HR_GENERAL.GET_BUSINESS_GROUP_ID
, KV.BUSINESS_GROUP_ID)
AND UT.USER_TABLE_NAME = SUBSTR(KT.KEY_FUNCTION
, 34
, INSTR(KT.KEY_FUNCTION
, '
, ')-35)
AND UT.BUSINESS_GROUP_ID = KV.BUSINESS_GROUP_ID
AND UT.USER_TABLE_ID = UTR.USER_TABLE_ID
AND KV.NAME = UTR.ROW_LOW_RANGE_OR_NAME