[Home] [Help]
133: WHERE mode_flag IN ('I','D')
134: AND error_code IS NOT NULL;
135:
136: -- Update used_for_ab_translation = 'Y' if the currency and conversion
137: -- type is used in standard or average translation in the system
138: UPDATE GL_DAILY_RATES_INTERFACE RI
139: SET used_for_ab_translation =
140: ( SELECT nvl(max('Y'), 'N')
141: FROM GL_DAILY_CONVERSION_TYPES CT,