DBA Data[Home] [Help]

APPS.AR_ARXINREV_XMLP_PKG dependencies on GL_TRANSLATION_RATES

Line 168: from gl_translation_rates tr

164: if C_CURR = P_CURRENCY then return(1.00);
165: else
166: IF P_RATE_TYPE_LOOKUP = 'PERIOD' THEN
167: select decode(tr.EOP_RATE, 0,0, 1/tr.EOP_RATE) into eop_rate
168: from gl_translation_rates tr
169: where tr.set_of_books_id = P_SET_OF_BOOKS_ID
170: and tr.to_currency_code = C_CURR
171: and upper(tr.period_name) = upper(P_REVALUATION_PERIOD)
172: and tr.actual_flag = 'A';