APPS.OKL_ACCOUNTING_UTIL dependencies on FND_CURRENCIES_VL

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 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);