78: p_in_join_tbl => l_in_join_tbl1);
79:
80:
81:
82: --Convert the currency suffix to conform to ISC standards
83: IF (l_cur_suffix = 'g')
84: THEN l_currency := 'g';
85: ELSIF (l_cur_suffix = 'sg')
86: THEN l_currency := 'g1';
136: -- Add measure columns that need to be aggregated
137: -- No Grand totals required.
138:
139:
140: --Convert the currency suffix to conform to ISC standards
141: IF (l_cur_suffix = 'g')
142: THEN l_currency := 'g';
143: ELSIF (l_cur_suffix = 'sg')
144: THEN l_currency := 'g1';