91: IS
92: -- get the first pop down which is the first dimnsion other than time, time_comaprison_type
93: CURSOR c_akitems(pRegionCode in varchar2) IS
94: select nvl(attribute2, attribute_code), attribute4
95: from ak_region_items
96: where region_code = pRegionCode
97: and display_sequence = (
98: select min(display_sequence)
99: from ak_region_items
95: from ak_region_items
96: where region_code = pRegionCode
97: and display_sequence = (
98: select min(display_sequence)
99: from ak_region_items
100: where region_code = pRegionCode
101: and node_query_flag = 'Y'
102: and nvl( substr(attribute2, 1, instr(attribute2, '+')-1), attribute_code) NOT IN ('TIME', 'TIME_COMPARISON_TYPE', 'EDW_TIME_M', 'CURRENCY', 'FII_CURRENCIES','AS_OF_DATE')
103: -- and nvl(attribute2, attribute_code) <> 'AS_OF_DATE' (reverting the fix for 2726787)
359: l_dimension_group VARCHAR2(150);
360:
361: CURSOR c_RnkLvlShrtName (pRegionCode IN VARCHAR2) IS
362: SELECT nvl(attribute2, attribute_code)
363: FROM ak_region_items
364: WHERE region_code = pRegionCode
365: AND display_sequence = (
366: SELECT min(display_sequence)
367: FROM ak_region_items
363: FROM ak_region_items
364: WHERE region_code = pRegionCode
365: AND display_sequence = (
366: SELECT min(display_sequence)
367: FROM ak_region_items
368: WHERE region_code = pRegionCode
369: AND NVL(substr(attribute2, 1, instr(attribute2, '+')-1), attribute_code)
370: NOT IN ('TIME', 'TIME_COMPARISON_TYPE', 'EDW_TIME_M', 'AS_OF_DATE')
371: );