DBA Data[Home] [Help]

APPS.POA_EDW_VARIABLES_PKG dependencies on EDW_CURRENCY

Line 295: l_global_currency_rate := edw_currency.get_rate (

291: OR l_rate_type is NOT NULL) then
292: l_currency_code := p_currency_code;
293: l_rate_date := p_rate_date;
294: l_rate_type := p_rate_type;
295: l_global_currency_rate := edw_currency.get_rate (
296: p_currency_code, p_rate_date, NULL);
297: end if;
298: elsif (p_rate_type = 'User') then
299: if (p_rate_date <> l_rate_date OR p_currency_code <> l_currency_code OR

Line 306: l_global_currency_rate := edw_currency.get_rate (

302: l_currency_code := p_currency_code;
303: l_rate_date := p_rate_date;
304: l_rate_type := p_rate_type;
305: l_rate := p_rate;
306: l_global_currency_rate := edw_currency.get_rate (
307: p_currency_code, p_rate_date, NULL) * p_rate;
308: end if;
309: else /* p_rate_type is NOT NULL and p_rate_type <> 'User' */
310: if (p_rate_date <> l_rate_date OR p_currency_code <> l_currency_code OR

Line 315: l_global_currency_rate := edw_currency.get_rate (

311: p_rate_type <> l_rate_type OR l_rate_type is NULL) then
312: l_rate_type := p_rate_type;
313: l_currency_code := p_currency_code;
314: l_rate_date := p_rate_date;
315: l_global_currency_rate := edw_currency.get_rate (
316: p_currency_code, p_rate_date, p_rate_type);
317: end if;
318: end if;
319: