APPS.OKL_ACCOUNTING_UTIL dependencies on FND_CURRENCIES

Line 326: FROM fnd_currencies_vl

322: l_sysdate DATE := G_SYSDATE;
323:
324: CURSOR curr_csr IS
325: SELECT '1'
326: FROM fnd_currencies_vl
327: WHERE currency_code = p_currency_code
328: AND ENABLED_FLAG = 'Y'
329: AND TRUNC(NVL(start_date_active, l_sysdate)) <= TRUNC(l_sysdate)
330: AND TRUNC(NVL(end_date_active, l_sysdate)) >= TRUNC(l_sysdate);

Line 705: FROM fnd_currencies_vl

701: FROM OKL_SYS_ACCT_OPTS;
702:
703: CURSOR prec_csr IS
704: SELECT PRECISION
705: FROM fnd_currencies_vl
706: WHERE currency_code = p_currency_code
707: AND enabled_flag = 'Y'
708: AND TRUNC(NVL(start_date_active, l_sysdate)) <= TRUNC(l_sysdate)
709: AND TRUNC(NVL(end_date_active, l_sysdate)) >= TRUNC(l_sysdate);

Line 787: FROM fnd_currencies_vl

783:
784:
785: CURSOR prec_csr IS
786: SELECT PRECISION
787: FROM fnd_currencies_vl
788: WHERE currency_code = p_currency_code
789: AND enabled_flag = 'Y'
790: AND TRUNC(NVL(start_date_active, l_sysdate)) <= TRUNC(l_sysdate)
791: AND TRUNC(NVL(end_date_active, l_sysdate)) >= TRUNC(l_sysdate);

Line 1651: FROM fnd_currencies fc

1647: l_profl_val VARCHAR2(80);
1648:
1649: CURSOR cur_csr IS
1650: SELECT fc.precision, fc.extended_precision, fc.minimum_accountable_unit
1651: FROM fnd_currencies fc
1652: WHERE fc.currency_code = p_currency_code;
1653:
1654: BEGIN
1655:

Line 1754: FROM fnd_currencies fc

1750: BEGIN
1751: BEGIN -- get currency info
1752: SELECT PRECISION
1753: INTO l_precision
1754: FROM fnd_currencies fc
1755: WHERE fc.currency_code = p_currency_code;
1756: EXCEPTION
1757: WHEN NO_DATA_FOUND THEN
1758: l_precision := 0;

Line 1922: FROM fnd_currencies_vl

1918: SELECT cc_rounding_rule INTO l_rounding_rule
1919: FROM OKL_SYS_ACCT_OPTS;
1920:
1921: SELECT PRECISION INTO l_precision
1922: FROM fnd_currencies_vl
1923: WHERE currency_code = p_currency_code
1924: AND enabled_flag = 'Y'
1925: AND TRUNC(NVL(start_date_active, l_sysdate)) <= TRUNC(l_sysdate)
1926: AND TRUNC(NVL(end_date_active, l_sysdate)) >= TRUNC(l_sysdate);

Line 1984: FROM fnd_currencies_vl

1980: FROM OKL_SYS_ACCT_OPTS;
1981:
1982: CURSOR prec_csr IS
1983: SELECT PRECISION
1984: FROM fnd_currencies_vl
1985: WHERE currency_code = p_currency_code
1986: AND enabled_flag = 'Y'
1987: AND TRUNC(NVL(start_date_active, l_sysdate)) <= TRUNC(l_sysdate)
1988: AND TRUNC(NVL(end_date_active, l_sysdate)) >= TRUNC(l_sysdate);

Line 2084: p_to_currency IN fnd_currencies.currency_code%TYPE,

2080:
2081: PROCEDURE convert_to_functional_currency
2082: (
2083: p_khr_id IN OKC_K_HEADERS_B.id%TYPE,
2084: p_to_currency IN fnd_currencies.currency_code%TYPE,
2085: p_transaction_date IN DATE,
2086: p_amount IN NUMBER,
2087: x_contract_currency OUT NOCOPY OKC_K_HEADERS_B.currency_code%TYPE,
2088: x_currency_conversion_type OUT NOCOPY OKL_K_HEADERS.currency_conversion_type%TYPE,

Line 2194: p_to_currency IN fnd_currencies.currency_code%TYPE,

2190:
2191: PROCEDURE convert_to_functional_currency
2192: (
2193: p_khr_id IN OKC_K_HEADERS_B.id%TYPE,
2194: p_to_currency IN fnd_currencies.currency_code%TYPE,
2195: p_transaction_date IN DATE,
2196: p_amount IN NUMBER,
2197: x_return_status OUT NOCOPY VARCHAR2,
2198: x_contract_currency OUT NOCOPY OKC_K_HEADERS_B.currency_code%TYPE,

Line 2349: p_from_currency IN fnd_currencies.currency_code%TYPE,

2345:
2346: PROCEDURE convert_to_contract_currency
2347: (
2348: p_khr_id IN OKC_K_HEADERS_B.id%TYPE,
2349: p_from_currency IN fnd_currencies.currency_code%TYPE,
2350: p_transaction_date IN DATE,
2351: p_amount IN NUMBER,
2352: x_contract_currency OUT NOCOPY OKC_K_HEADERS_B.currency_code%TYPE,
2353: x_currency_conversion_type OUT NOCOPY OKL_K_HEADERS.currency_conversion_type%TYPE,

Line 2468: p_from_currency IN fnd_currencies.currency_code%TYPE,

2464:
2465: PROCEDURE convert_to_contract_currency
2466: (
2467: p_khr_id IN OKC_K_HEADERS_B.id%TYPE,
2468: p_from_currency IN fnd_currencies.currency_code%TYPE,
2469: p_transaction_date IN DATE,
2470: p_amount IN NUMBER,
2471: x_return_status OUT NOCOPY VARCHAR2,
2472: x_contract_currency OUT NOCOPY OKC_K_HEADERS_B.currency_code%TYPE,