APPS.EDW_CURRENCY dependencies on EDW_LOCAL_SYSTEM_PARAMETERS

Line 25: From EDW_LOCAL_SYSTEM_PARAMETERS SP;

21: BEGIN
22: Select /*+ FULL(SP) CACHE(SP) */
23: warehouse_currency_code, rate_type
24: into l_global_currency_code, l_global_rate_type
25: From EDW_LOCAL_SYSTEM_PARAMETERS SP;
26:
27: IF (x_base_amount is not NULL) and
28: (x_base_currency_code = l_global_currency_code) then
29: l_converted_amount := x_base_amount;

Line 169: From EDW_LOCAL_SYSTEM_PARAMETERS SP;

165:
166: Select /*+ FULL(SP) CACHE(SP) */
167: warehouse_currency_code, rate_type
168: into l_global_currency_code, l_global_rate_type
169: From EDW_LOCAL_SYSTEM_PARAMETERS SP;
170:
171: if x_trx_currency_code = l_global_currency_code then
172: return 1;
173: else

Line 199: from edw_local_system_parameters lsp,

195: BEGIN
196:
197: select nvl( curr.minimum_accountable_unit, power( 10, (-1 * curr.precision)))
198: into l_mau
199: from edw_local_system_parameters lsp,
200: gl_currencies curr
201: where lsp.warehouse_currency_code = curr.currency_code;
202:
203: if l_mau is null then